Can't Login to Project Server 2003 with Project Pro 2003 - SQL Error

[Mike Murphy]

When I attempt to login using Windows Authentication to
Project Server, I receive the following SQL errors. Other
users setup with the same permissions in Project Server
can access, so I assume it is a configuration issue on my
local machine. Has anyone seen this error and can someone
explain how to resolve it?

Error:
Connection Failed:
SQL State: '01000'
SQL Server Error: 010051
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection Failed:
SQL State: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.

Thanks,

Mike

 

[Nico Oosthuysen]

Hi Shamunda,

What sql error are you getting? perhaps try to ensure that Name Resolution
to your server is working properly? I had a issue at one client where the
ip of the project server was changed, but the DNS records not properly
updated, and i kept on getting sql errors when trying to log into project
server.

Hi Mike -

Did you ever find a solution to this issue? I'm having the same problem

and have tried everything from you cliconfig.exe, adding entries in my hosts
files...etc..but nothing works.

 

[Brian K - Project MVP]

When I attempt to login using Windows Authentication to
Project Server, I receive the following SQL errors. Other
users setup with the same permissions in Project Server
can access, so I assume it is a configuration issue on my
local machine. Has anyone seen this error and can someone
explain how to resolve it?

Error:
Connection Failed:
SQL State: '01000'
SQL Server Error: 010051
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()).
Connection Failed:
SQL State: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied.

Thanks,

Mike

Upgrade your version of MDAC to be the same as the version on the
server.

You can find the version by checking the file version on the
msadcs.dll.


--
___
Brian K
Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com

 

[sumit]

do check if you are using the TCP/IP protocol

execute "cliconfg.exe" from run and check the protocol under "default network library", it should be TCP/I

Regards
sumit