SQL Server Login Error (Project and Server 2002)

D

Dennis Sampson

Hi.

I am in the midst of setting up Project Server 2002 on a
Windows 2003 Server and using Project 2002 Pro to
connect. When attempting to login with a user account
that I have set-up in both server and project, I get the
following message:

Connection failed
SQL State: '01000'
SQL Server Error 10110
SQL State '08001'
SQL Server Error: 6 Specified SQL Server Not Found

When I test the connection from the account properties in
MS Project Server accounts, it connects just fine. I
just can't connect from the login screen. Any help is
greatly appreciated.

Dennis Sampson
Utah TECH CORPS (www.uen.org)
 
C

chuck

I am getting the same error message. I have 2 systems (1
W2K and 1 XP) that can connect with no problems all of
the rest which are W2K systems cannot. We have named
pipes off and TCPIP selected. All systems have MDAC 2.8
installed.

When I click ok on the error screen it brings up the
longon screen again and when I enter the IP address for
the server I am able to log on but have to go through
this process when I try to use add resources.

I am going crazy over this.
 
C

chuck

Yes,

When I change the server name to the IP address it will
let me connect but I can not share resources or other
functions with the DB. I get the same error and have to
go through the same screen again. Is it something with
SQL server or Share point services
 
C

chuck

Thanks Jan,
we have already made sure that we had completed
everything in 818047. Still getting the error for some of
the W2K systesm. 1 W2K and 1 XP Pro have no problems
connecting.

At a loss as to what to do.
 
V

Vinh Tran

Are you on a domain using DNS?

It's quite possible that the thick clients can't resolve
the IP address of the SQL Server or Project Server.

Thus, when a session is created, it's created for the
domain using an IP address instead of the server name.

Try putting the SQL Server and Project Server IPs into
your HOSTS file.




Vinh Tran
 
Top