Showing posts with label 2007. Show all posts
Showing posts with label 2007. Show all posts

Thursday, January 24, 2013

How to change service accounts and service account passwords in SharePoint Server 2007/2010

There might be a Need in the org to change the password of the service account as some administrator has Left or for some other reason to avoid any integrity issue .

Just as I was walking through the process of Changing Service account passwords in 2010 which i found the simplest .

I also wanted to share the old way of changing service accounts and service account passwords in SharePoint Server 2007 .

Please refer to the below link

http://support.microsoft.com/kb/934838

The steps in the KB article would walk you through the individual STSADM commands that were necessary to update the password for the following accounts on every server in the SharePoint Farm:

•Farm account
•Application pool account(s)
•Windows SharePoint Services Help Search Service
•Content access account (used by the Windows SharePoint Services Help Search Service)
•Shared Services Provider (SSP) account(s)
•Office SharePoint Server Search service

However in Sharepoint 2010 we have Managed Accounts

Launch SharePoint 2010 Central Administration (logon as Setup Farm Account)
Navigate to ‘Application Management’
In ‘Security’ Section Click‘Configure Manage Accounts
Click Register Managed Account

Add the New Account
User Name (NEW USER)
Password (NEW PASSWORD)

Update Security Groups on Each SharePoint Server.
Start – Administrative Tools – Computer Management
Expand System Tools -> Local Users and Groups – Groups
Set the permissions as below:

ADMINISTRATORS – add the new farm account confirm it exists
WSS_WPG – add the new farm accountconfirm it exists
WSS_ADMIN_WPG – add the new farm accountconfirm it exists

Launch Central Administration
Select Security
Select Configure Service Accounts
Update the following Accounts:
• Farm Account
• Windows Service – Microsoft SharePoint Foundation Sandboxed Code Service
• Windows Service – User Profile Synchronization Service
• Windows Service – Web Analytics Data Processing Service
• Service Application Pool – SecurityTokenServiceApplicationPool
• Service Application Pool – SharePoint Web Services System

You can also change only the password of the Service account

Launch SharePoint 2010 Central Administration (logon as Setup Farm Account)
Navigate to ‘Application Management’
In ‘Security’ Section Click
‘Configure Manage Accounts
Click on Edit besides the service account and then fill in the details
The Managed account should be already selected
Check the Change password now box
Set account password to new value
Confirm Password
Click ok

Hope This helps some Administrators .

You can also refer - http://blogs.technet.com/b/seanearp/archive/2011/01/25/updating-passwords-on-sharepoint-2010.aspx

Tuesday, October 9, 2012

Cannot add an existing SharePoint 2007 list to a Office Access 2007 database

One of my users had this issue .

The user was trying to add an existing list to a access 2007 db . and was getting an error .

Error : You do not have the necessary permissions to use the '<ListName>' object. Have your system administrator or the person who created this object establish the appropriate permissions for you .

After we did some research i found a KB article for the same .

http://support.microsoft.com/kb/924739

In this the Cause is mentioned as

This problem occurs because the Access 2007 database engine disallows columns that have names that contain more than 64 characters

To work around this problem, use only column names that contain less than 64 characters in Windows SharePoint Services lists

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section

Please check out the Steps to reproduce the problem in the KB article (link) provided.

Wednesday, July 4, 2012

Microsoft Support Lifecycle

If you are still using Sharepoint 2007 be aware that mainstream support for this product will end at October 9th, 2012. You can check the same on the below link

http://support.microsoft.com/lifecycle/?p1=11373  

Extended support will be provided till October 10th, 2017.

That means that no new hotfixes will be created for WSS 3.0 or MOSS 2007 after October 9th, 2012 - except security fixes.For for details about the difference between Mainstream support and Extended Support see the below link

http://support.microsoft.com/gp/lifepolicy

Monday, June 4, 2012

Adding a hit counter in Sharepoint 2007 using SharePoint Designer 2007

Today One of my client wanted to add a Hit counter on his page . I informed him about the Site usage Report . However he wanted something that is visible to the users as well .

After a Some Research found that we can add a Hit counter Using Sharepoint Designer 2007 .

* Open The Designer and open teh web page .
* Click the New Document button on the toolbar.
* In Page view at the bottom of the document window, click Design.
* Put the insertion point where you want to create the hit counter.
* On the Insert menu, click Web Component.
* Under Component type, click Hit Counter.
* Under Choose a counter style, double-click a hit counter style, and then click Finish.
To set the counter to a specific number, click to select the Reset counter to check box, and then type the number.

To display a fixed number of digits in the hit counter, click to select the Fixed number of digits check box, and then type the number.

For example, to display the hit counter as "00#" instead of as a single or double digit, click to select the Fixed number of digits check box, and then type 3.

Click OK.

To use the hit counter on the page
1.Put the insertion point before the hit counter object on the page.
2.Type You are visitor followed by a space

For reference : http://support.microsoft.com/kb/825532

Tuesday, May 29, 2012

February 2011 Cumulative Update for WSS V3 and MOSS 2007

Windows SharePoint Services 3.0 Cumulative Update Server Hotfix Package (WSS server-package): February 22, 2011

http://support.microsoft.com/default.aspx?scid=kb;EN-US;2475886

Office SharePoint Server 2007 Cumulative Update Server Hotfix Package (MOSS server-package): February 22, 2011

http://support.microsoft.com/default.aspx?scid=kb;EN-US;2475885

Note : After installing the fixes you need to run the SharePoint 2010 Products Configuration Wizard on each machine in the farm

Users cannot see the checked out files in the folder/ library

I Came across a Issue today wherein the user opened a ticket for the below issue Issue : Users cannot see the checked out files in the fo...