Microsoft KB Archive/823623

= PRJ2000: Cannot Connect to the Project Central Database After a Share Point Portal Server Is Installed =

Article ID: 823623

Article Last Modified on 1/5/2007

-

APPLIES TO


 * Microsoft Project 2000 Standard Edition

-





Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
After you Install Microsoft Project Central 2000 on a server that also has Microsoft Share Point Portal Server installed, you may not be able to connect to the Project Central database.



CAUSE
This issue may occur if the system administrator (sa) password is lost or has been changed.



RESOLUTION
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To resolve this issue, change or reset the sa password by using the OSQL utility at the command prompt. To reset the sa password if the password has been lost, follow these steps:  Log on to the server as the local administrator. Click Start, and then click Run. Type regedit, and then click OK. Locate the following registry key: 

 Make sure that LoginMode is set to a REG_DWORD value of 2.

A value of 2 indicates Microsoft SQL Server and Microsoft Windows NT authentication. A value of 1 indicates Windows NT authentication only. Quit Registry Editor.</li> Click Start, and then click Run.</li> Type cmd, and then click OK.</li> At the command prompt type Osql -E, and then press ENTER.

Note This command is case sensitive.</li> At the command prompt type the following text (with the single quotes) where  is the new sa account password, and then press ENTER:

sp_password null,’ ’,’sa’

</li> At the command prompt type go, and then press ENTER.</li></ol>

To change the existing password, follow these steps: <ol> Click Start, and then click Run.</li> Type cmd, and then click OK.</li> At the command prompt type Osql -E, and then press ENTER.

Note This command is case sensitive.</li> At the command prompt type the following text (with the single quotes) where  is the current password and   is the new password for the sa account, and then press ENTER:

sp_password ‘ ’,’ ’,’sa’

</li> At the command prompt type go, and then press ENTER.</li></ol>

After you complete these steps, you must also change the sa password in the SharePoint Database Connection configuration. To do this, follow these steps:
 * 1) Click Start, point to Programs, point to Administrative tools, and then click Microsoft SharePoint Administrator.
 * 2) Under Virtual Servers, click the Administration link for your site.
 * 3) Click the Change database connection link.
 * 4) Type the username as sa, type the new password for the account, and then click Submit.

<div class="moreinformation_section">

MORE INFORMATION
For additional information about how to use the OSQL utility, click the following article number to view the article in the Microsoft Knowledge Base:

325003 HOW TO: Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility

Keywords: kbinfo KB823623

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.