On my Vista laptop, I have SQL 2005 Standard installed, along with GP 10.0.
This has never happened before. When I try to login through my ODBC
connection in Control Panel...Admin Tools...., I get the following error:
SQL State: 08001
SQL Server Error 0
Unable to complete login process due to delay in opening server connection.
Obviously, this issue with the ODBC connection is preventing me for the
first time from logging into GP on my private laptop.
Specifcally, I get this error in the SQL Server DSN Configuration window
when I enter my "sa" password and click "Next".
Just to see if the Windows Firewall was an issue, I temporarily turned it
off. No effect.
Can you ping the server both by name and IP? If you can by IP and not by
name, that points to name resolution - DNS.
Have you flushed the DNS cache?
This one is out there, but is the protocol enabled?
Did it ever work?
Can you connect using the SQL Server driver and not the Native Client?
Is the server 64-bit?
Is the Server clustered?
I didn't have a chance to read it. I've got to rush off.