unable to logon to Project Server database (Error 5001)

[Poonam Thawani]

The following error is encountered whenever I attempt to login to Project
Server databse through Project Web Access.

"Microsoft Project was unable to log you on at this time because the
Microsoft Project Server database cannot be accessed. Please try again later
or check with your Microsoft Project Server administrator. (5001) "

I had tried the resolution provided on microsoft site (
http://support.microsoft.com/?scid=kb;en-us;839773&spid=2525&sid=global) for
the above error.

But the problem persist.
Looking at the event viewer on the server error shows :

"
Type: Error
Category:None
Event ID : 2
User : NT AUTHORITY\LOCAL SERVICE
Computer :SPSDEVELOPER
Description
"Component: PjSvrSecurity
File:
C:\Office\dev\project\WebClient\source\server\pjsvrsecurity\CPjSvrSecurity.cpp
Line: 188
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>"


"Component: PjQuery
File: C:\Office\dev\project\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 748
Error Number: 0x80004003
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>"


Brief Summary

The project Server 2003 installation is a Single server installation running
Windows Server 2003,Microsoft SQL Server 2000,SQL server Analysis Services &
Sharepoint Portal server 2003.

The project server 2003 was installed successfully and the project default
webparts (Project Timesheet,Project Report,Project Center,Project Manager
Updates,Project Resource assignment,Project portfolio analyzer) were deployed
and were running successfully.

No change has been made but the above mentioned error is encountered
whenever I attempt to login through Project Web Access.

Any help would be appreciated.

 

[iPSova]

Namaste Poonam

Try adding your users in the server in which Project Server was installed
with same "username" and "passwords" as of in Project Server.
I think you are getting this error while accessing data, connecting or
publishing MPP file to Project Server later to be seen in PWA. Correct me if
I am wrong.

Pranay

 

[Aaron Tamblyn]

I would suggest using the edit site tool (download free from MS). This
allows you to test / reset the database connection. You may find entering
the IP address for the database server worth trying also.