ODBC Connect Prob in 2005


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
.

Relevant Pages

  • Re: Upsizing wizard access Sql Server express
    ... Sylvain Lafontaine, ing. ... Troubleshooting connection problem: ... database into sql server express 2005 by using the upsizing wizardi go ... SQL Server Error: 2 ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Connection failed SQL State 01000 SQL error 52
    ... Connection failed ... SQL Server Error: 52 ... I have tried SQL Server authentication, ...
    (microsoft.public.project)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)