Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.
Connect with xMatters.
Course Of The Month
1 day, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space.
Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders.
Click on Start and then select Computer to view the available drives on the se…
Suggested Courses
Course of the Month1 day, 14 hours left to enroll
Earn Certification
MCSA Configuring Windows 7 Exam 70-680
$49.00$44.10
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.