ODBC Connect Problem w/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
Hi,
Following things you need to check:
1. If SQL Browser is enabled and started.
2. If firewall is on, you need to put sql server and sql browser in
exception list. Regarding this, you may refer to following two method:
#1. Get IP and port of target SQL Server, suppose it is 123.123.123.123 and
1433 ->
Test connect using osql and target of Stcp:123.123.123.123,1433, like
so:
osql -Stcp:123.123.123.123,1433 -E
#2. Try telnet to port as well, if this fails it is firewall:
telnet 123.123.123.123 1433
Best regards,
Vincent Xu
Microsoft Online Partner Support
================================================== ====
Get Secure! - www.microsoft.com/security
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties,and confers no rights.
================================================== ====
--[vbcol=seagreen]
19:52:44 CST)[vbcol=seagreen]
TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfee d00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews. com!cyclone.austin.rr.com!
news.rr.com!tornado.texas.rr.com.POSTED!53ab2750!n ot-for-mail[vbcol=seagreen]

ODBC Connect Problem w/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!
GregCHi,
Following things you need to check:
1. If SQL Browser is enabled and started.
2. If firewall is on, you need to put sql server and sql browser in
exception list. Regarding this, you may refer to following two method:
#1. Get IP and port of target SQL Server, suppose it is 123.123.123.123 and
1433 ->
Test connect using osql and target of Stcp:123.123.123.123,1433, like
so:
osql -Stcp:123.123.123.123,1433 -E
#2. Try telnet to port as well, if this fails it is firewall:
telnet 123.123.123.123 1433
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
19:52:44 CST)[vbcol=seagreen]
TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone.austin.rr.com!
news.rr.com!tornado.texas.rr.com.POSTED!53ab2750!not-for-mail[vbcol=seagreen]sql