Home > Archive > MS SQL Server ODBC > March 2006 > ODBC Connect Prob in 2005









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author ODBC Connect Prob in 2005
gc

2006-03-17, 11:23 am


I have attempted to establish ODBC connections w/ the Microsoft SQL Native
Client Version 09.00.1399 (from 2 different machines) and get the following
error:

Connection Failed:
SQLState: '08001'
SQL Server Error: 1326
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a
connection to SQL Server [1326]
Connectio Failed:
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][SQL Native Client]Login Timeout Expired
Connection Failed:
SQLState: '08001'
SQL Server Error: 1326
Microsoft][SQL Native Client]An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default setting SQL Server does
not allow remote connections.


* Win2003 Server 64bit; SQL Server 2005 x64
* SQL Server authentication
* Allow Remote connections is checked on the SQL Server
* The clients show driver ver 09.00.1399 in the ODBC Sources, the Server's
ODBC Sources shows ver 09.00.1399.00, although the SQL Server 2005 shows
09.00.1399.06.

thanks!
GregC
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com