If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
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.
If you are experiencing a similar issue, please ask a related question
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012.
Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses
Course of the Month9 days, 9 hours left to enroll
609 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.