Server login problem

[rhort]

I am trying to login to Project Server 2003 and keep getting the following
message:
Connection failed:
SQLState: '0100'
SQL Server Error: 3
[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.

When I enter the project server url and test the connection, it tests ok.
But, when I actually go to login, I get the message above. I have tried
changing to another user name and password, and it still doesn't work. I do
have other users that can login successfully though so I know the server is
functioning properly.

Let me know if you need any other info...thanks!

 

[Earl Lewis]

rhort,

Try setting up an ODBC connection directly to the SQL server with known good credentials . If you can get the ODBC connection working your MSProjectUser credentials might be out of synch. If you can't create an ODBC connection then you might have port 1433,1434 blocking on your network. If others can conect this is probably not happening though.

Post back your results from setting up ODBC connection.

Earl
I am trying to login to Project Server 2003 and keep getting the following
message:
Connection failed:
SQLState: '0100'
SQL Server Error: 3
[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.

When I enter the project server url and test the connection, it tests ok.
But, when I actually go to login, I get the message above. I have tried
changing to another user name and password, and it still doesn't work. I do
have other users that can login successfully though so I know the server is
functioning properly.

Let me know if you need any other info...thanks!