Can't access remote SQL Server database

[Mike L.]

Hello,

I installed Project Server 2003 on Server A. The SQL Server database is
installed on Server B. When I run Project Server from Server A, it is able
to log on to the database without any problems. However, when I go to a
client machine (box C) and browse to the virtual directory on Server B, I
receive the following message:

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

Thanks in advance for any help with this.

 

[V Prabakaran]

Hi,

Try either of the following to resolve 5001 error message.

Method 1:
-------------
http://support.microsoft.com/default.aspx?scid=kb;en-us;839773
Follow those steps in the article to resolve the issue


Method 2:
--------------

Result:
=========
Receives a 5001 error on the logon page

Cause:
=========
The application server that runs Microsoft Windows 2000 (any service pack)
cannot
Successfully initiate a connection to the database server that runs Windows
Server
2003. Because Microsoft Windows Server 2003 includes MDAC 2.8, for the
application
Server to successfully initiate a connection to the server, it requires
matching
MDAC components.

Resolution:
=========
Updating to MDAC 2.8 resolved the issue.

Thanks
VP