April 12, 2005 at 8:25 am
I get the following error when trying to configure an ODBC connection to a MSSQL Server 2000 server running Windows2000, using Windows Authentication (required by vendor when migrating database to new version) My client is running Windows XP, SP1 with MDAC 2.8 RTM: I am able to connect successfully when using SQL Authentication.
Tested on 9 PC's, only 3 are able to successfully complete. 1 machine is the same as mine, the other two are running Win2k.
Connection failed:
SQLState: '01000'
SQL Server Error: 10054
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
Connection failed:
SQLState: '08S01'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
April 15, 2005 at 8:54 am
Have you checked the client connectivity on all of the PCs (in ODBC) to make sure that they're all configured to use the same protocol (tcp/ip / named pipes, etc.)
April 15, 2005 at 9:38 am
All clients ODBC settings were configured to use TCP/IP.
May 23, 2006 at 10:39 pm
I am experiencing the same problem. Can you count the number of Global groups the user trying to connect is a member of. I am thinking it might have something to do with the following article but in a SQL manner - http://support.microsoft.com/?kbid=327825
May 25, 2006 at 9:07 am
I wound up using SQL authentication on all the clients to resolve the issue. They were in only 1 global group.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply