Solved

SQL Server Login Connection Failed

Posted on 2011-03-16
5
812 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:stillsyra
[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
 
LVL 2

Accepted Solution

by:
DerekStone earned 500 total points
ID: 35149790
Is port TCP/1433 open on the firewall if one is in use?
0
 

Expert Comment

by:doggybs
ID: 35150119
If you are connecting from a different machine to the SQL Server machine make sure the 'SQL Server Browser' service is started
0
 

Expert Comment

by:doggybs
ID: 35150290
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?
0
 

Author Comment

by:stillsyra
ID: 35150673
The server has window firewall on and port 1433 was not configured for inbound/outbound rules.

I can ping the server by name and ip address.
0
 

Author Comment

by:stillsyra
ID: 35150860
I just added an inbound rule on the windows firewall and it works. Thank you very much for the help.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Trust DNS Resolution for Unqualified Names 3 39
SQL Server 2008 R2 service pack updates 5 44
NTP time source for DC 3 44
Linked Server - SP with Param to VIew 7 21
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question