one user cannot connect to sql server; can ping server
Posted on 2006-06-30
One of my network logins has lost his ability to connect to the SQL Server. Cannot create an ODBC connection. I am using SQL Authentication so the network login shouldn't matter. If someone else is logged on to this workstation, the connection works fine (still SQL Authentication).
The bad login can still Ping the SQL server.
The ODBC connection is using port 1433. Telnet to 1433 works fine.
Any ideas? Is MDAC user or workstation specific?