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

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:

1. Log on to the server as the local administrator.
2. Click Start, and then click Run.
3. Type regedit, and then click OK.
4. Locate the following registry key:

   HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

5. 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.
6. Quit Registry Editor.
7. Click Start, and then click Run.
8. Type cmd, and then click OK.
9. At the command prompt type Osql -E, and then press ENTER.
   
   Note This command is case sensitive.
10. At the command prompt type the following text (with the single quotes) where new_password is the new sa account password, and then press ENTER:

    sp_password null,'new_password','sa'

11. At the command prompt type go, and then press ENTER.

To change the existing password, follow these steps:

1. Click Start, and then click Run.
2. Type cmd, and then click OK.
3. At the command prompt type Osql -E, and then press ENTER.
   
   Note This command is case sensitive.
4. At the command prompt type the following text (with the single quotes) where old_password is the current password and new_password is the new password for the sa account, and then press ENTER:

   sp_password 'old_password','new_password','sa'

5. At the command prompt type go, and then press ENTER.

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.