Solved
SQL Server Login Connection Failed
Posted on 2011-03-16
I have a SQL Server 2008 RTM Standard edition 64 bit, installed on Windows server 2008 standard 64 bit SP2. I'm trying to set up an ODBC connection to a SQL Server database, but got the Connection Failed error.
Connection failed:
SQLState: '01000'
SQL Server Error: 5 (sometimes this error is error 231)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
The SQL server is TCP/IP enabled with default port 1433, and allows remote connections. I can create ODBC connection and telnet the port on the server itself, but not on other servers or workstations.
Thanks for the help.