Connection failed SQL State 01000 SQL error 52



When i open or close an enterprise project from the Project Server
I get this error.

Connection failed
SQLState; "01000'
SQL Server Error: 52
[Microsoft] [ODBC SQL Server Driver] [DBNETLIB] ConnectionOpen
(Connect()).
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft] [ODBC SQL Server Driver] [DBNETLIB] SQL server does not
exist or access denied.

After the error window, a window pops up asking for the connection
credentials again. After confirming them a few times, the project will
open.

The message text lead me to think that it was a bad connection string,
probably a username or password. But I setup a System DSN using the
same credentials. I have tried SQL Server authentication, an Secure
Connection (NT Authentication). Neither worked, I received the same
error.

.



Relevant Pages

  • Re: Upsizing wizard access Sql Server express
    ... Sylvain Lafontaine, ing. ... Troubleshooting connection problem: ... database into sql server express 2005 by using the upsizing wizardi go ... SQL Server Error: 2 ...
    (microsoft.public.access.adp.sqlserver)
  • ODBC Connection.
    ... There is a problem with my ODBC connection. ... a connection time out occurs and the error ... SQL Server Error: 0 ...
    (microsoft.public.sqlserver.odbc)
  • Re: Upsizing wizard access Sql Server express
    ... Troubleshooting connection problem: ... database into sql server express 2005 by using the upsizing wizardi go ... SQL Server Error: 2 ... I downloaded SSMA but my work environment does not allow for the ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Connection Strings
    ... Okay, if you're using SQL Server authentication, and the ConnectionString is changing then the rights granted to the database objects are a function of the currently assigned user. ... the query plan is not going to change based on rights. ... What makes you think the SP or SQL Server will get confused? ... If the connection string is NOT unique, ...
    (microsoft.public.dotnet.framework.adonet)
  • ODBC Connect Prob in 2005
    ... Connection Failed: ... SQLState: '08001' ... SQL Server Error: 1326 ... SQL Server Error: 0 ...
    (microsoft.public.sqlserver.odbc)