5001 Error while connecting to Project Server thro' LgnPsAu.asp!

[aruljohnson]

Hi all,

I am facing a strange problem pls help!

I have freshly installed Project Server 2003 in Windows 2003 box where
my .net web application is running. Its Multiple server installation.
The Sql Server is in a seperate 2000 Machine.

I could able to login to project server by both Windows Integerated
Authentication and by Project Server Authentication through Web
Access! But If I tried to connect to the project server thro my
application by Project Server Authentication I am not getting the
cookie, instead getting error 5001 - Access to the database was
Unsuccessful.
If I typed the url directly in the browser the same result - 5001. But
Windows Integerated Authentication is working fine.

If it is the problem with DAC or ProjectServerUser/ProjectServer role
passwords in the Registry then Web Acces itself won't work. This is
something strange!

This is what I am trying:

http://<MyServerName>/lgnPsAu.asp?un=administrator&pwd=mypassword -
5001 - Even directly typed in the browser.

http://<MyServerName>/projectserver/lgnintau.asp -- Working fine.
pls help me with the solution.

Arul

 

[V Prabakaran]

Hi Arul,

When you tried connecting from Project to Project Server, you receive 5001
error; however, you are able to connect through PWA.

- Please, ensure you have logged into the system with same windows account
and tried connecting to project server.
- In the client machine check, whether you have added the Project server
URL into the trusted site.

Please go through this KB Article for further clarification,

- http://support.microsoft.com/default.aspx?scid=kb;en-us;839773

You can also refer the following article that is for more information.

- http://support.microsoft.com/default.aspx?scid=kb;en-us;324835

I hope this address your issue.

Warm Regards,

VP

 

[aruljohnson]

hi VP,

Thanks for your suggestions. I have already gone thro the link which
you have sent. Those links gives the solution if you have problem on
connecting to Project Server thro PWA. In my case PWA is working fine.

If I connect using windows authentication its getting me the cookie.
The problem is only while connecting to project server using project
server authentication login form (lgnpsau.asp).

I have even verified the event viewer log of Sql Server, its failing in
PjGenericQuery.cpp file the description 'Sql Server doesn't exist or
Access denied'.

I am still not able to get the solution. your suggestions are
appreciated.

 

[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.



Expand AllCollapse All

 

[ddrhodes]

Is sql server configured with mixed-mode authentication?

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.



Expand AllCollapse All

hi VP,

Thanks for your suggestions. I have already gone thro the link which
you have sent. Those links gives the solution if you have problem on
connecting to Project Server thro PWA. In my case PWA is working fine.

If I connect using windows authentication its getting me the cookie.
The problem is only while connecting to project server using project
server authentication login form (lgnpsau.asp).

I have even verified the event viewer log of Sql Server, its failing in
PjGenericQuery.cpp file the description 'Sql Server doesn't exist or
Access denied'.

I am still not able to get the solution. your suggestions are
appreciated.