Tuesday, 20 July 2010 1:04 AM
I am writing some code to read/write data between Project Server 2007 and our application database.
I'm testing the Project Server login procedure, passing in credentials of a user account with admin permissions for Project and SQL.
Windows login fails with no error message. Forms login fails with the following Exception:
"Server was unable to process request. ---> Unable to connect to SQL Server database. ---> A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
On the database server, the following error is in the Events log:
"Login failed for user 'domain\PROJSERVER$'. Reason: Failed to open the explicitly specified database. [CLIENT: <named pipe>]"
The Details view indicates it's trying to access "master" database.
I have tried setting the PROJSERVER$ account as DBO to master database and all Project Server-related databases, but it does not help.
What am I doing wrong? How do I get it working?
Tuesday, 20 July 2010 8:59 AM
I am not sure to the exact issue that you are having. However I had something similar and this was resolved by confirming how SQL Server was configured for Project Server. It is work reviewing your setup once again to ensure all parts have been confgured correctly......
Review the following KB article to ensure this is correct - http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx
Hope this helps to begin with.