Article ID: 923896
Article Last Modified on 5/14/2007
APPLIES TO
- Microsoft Windows SharePoint Services 3.0
SYMPTOMS
When you try to run the Microsoft Windows SharePoint Services 3.0 pre-upgrade scan tool (Psconfig.exe) from the command line, you receive the following error message:
CAUSE
This issue occurs if the Windows SharePoint Services 3.0 database is hosted on a separate computer that is running Microsoft SQL Server. In this situation, the Windows SharePoint Services search logon account may not have the correct permission to access or to query the Windows SharePoint Services database on the computer that is running SQL Server.
WORKAROUND
To work around this issue, stop the Windows SharePoint Services Search service. Then, add a domain account that has permissions to access the computer that is running SQL Server. To do this, follow these steps:
- Use an account that has administrative permissions to log on to the computer that is running Windows SharePoint Services 3.0.
- Click Start, click Run, type cmd in the Open box, and then click OK.
- At the command prompt, move to the
%programfiles%\common files\microsoft shared\web server extensions\12\bin folder. - Type the following at the command prompt, and then press ENTER:
This command stops and disables the Windows SharePoint Services Search service.
stsadm -o spsearch -action stop
- Click Start, point to Administrative Tools, and then click Services.
- In the Services MMC snap-in, right-click Windows SharePoint Services Search, and then click Properties.
- In the Windows SharePoint Services Search Properties dialog box, click the Log On tab.
- Click This account, type the name of the domain account that has the correct permissions, type the password, and then type the password again in the Confirm password box.
- Click the General tab, click the list next to Startup type, and then click Automatic. Click Apply, click Start, and then click OK.
Additional query words: WSSv3
Keywords: kbtshoot kbexpertiseinter kbprb KB923896
