Your question, your audience. Choose who sees your identity—and your question—with question security.
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]Connectio
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.
Connection failed:
SQLState: '01000'
SQL Server Error: 5 (sometimes this error is error 231)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connectio
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.
2-
2
5 Comments
If you are connecting from a different machine to the SQL Server machine make sure the 'SQL Server Browser' service is started
Actually, scrub that. That only matters when connecting via the management studio.
But it might be worth while trying to connect via the management studio using the username / password you are trying to use in your odbc connection, just to test the credentials / connectivity.
Silly question, but can you ping the hostname you are using in your odbc connection, does this resolve correctly?
But it might be worth while trying to connect via the management studio using the username / password you are trying to use in your odbc connection, just to test the credentials / connectivity.
Silly question, but can you ping the hostname you are using in your odbc connection, does this resolve correctly?
Featured Post
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
OfficeMate Freezes on login or does not load after login credentials are input.
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job.
The first step is to acquire the necessary licen…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses
Course of the Month9 days, 18 hours left to enroll
606 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.