Error 26 connecting to SQL2008 via Project Server 2007 PSI

• Tuesday, 20 July 2010 1:04 AM

   

   
  

  0

  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?

  • Reply
  • Quote