5001 error

[GMartin]

Ok - we had to restart the SQL server that hosts our test project server
database. Restart the hard way :-(

Since it came back, we now get the dreaded 5001 error when we hit the WebAccess
page or try to use pro to update a project.

I found the Q article that discussed resetting the SQl accounts. i created new
accounts, granted them appropriate access. I downloaded and installed EditSite
and using it to run the connection test. All Tests pass - error continues.

Here's the odd thing When I hit the webaccess home page from the project server,
I can see projects and resources. Doing so off the server results in the 5001
error.

The Event viewer on the Proj Svr reports a ton of 0x80004005 errors and every
5th one says this:

File: C:\Office\dev\project\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: <Description><![CDATA[Assert Detected. The error code was also
included.]]></Description>
___________________________________

Component: Microsoft OLE DB Provider for SQL Server
Description: <Description><![CDATA[[DBNETLIB][ConnectionOpen (Connect()).]SQL
Server does not exist or access denied.]]></Description>

---------------

Install details:
Project svr runs on a Win2k3 server with SQL 2000 on a separate box.

Thanks in advance

\\Greg

 

[GMartin]

Ok - we had to restart the SQL server that hosts our test project server
database. Restart the hard way :-(

Since it came back, we now get the dreaded 5001 error when we hit the
WebAccess page or try to use pro to update a project.

I found the Q article that discussed resetting the SQl accounts. i
created new accounts, granted them appropriate access. I downloaded and
installed EditSite and using it to run the connection test. All Tests
pass - error continues.

Install details:
Project svr runs on a Win2k3 server with SQL 2000 on a separate box.

Thanks in advance

\\Greg

Problem resolved. I restarted SQl server cleanly and everything came back fine.

\\Greg