Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 830
  • Last Modified:

SQL Server Login Connection Failed

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
stillsyra
Asked:
stillsyra
  • 2
  • 2
1 Solution
 
DerekStoneCommented:
Is port TCP/1433 open on the firewall if one is in use?
0
 
doggybsCommented:
If you are connecting from a different machine to the SQL Server machine make sure the 'SQL Server Browser' service is started
0
 
doggybsCommented:
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
 
stillsyraAuthor Commented:
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
 
stillsyraAuthor Commented:
I just added an inbound rule on the windows firewall and it works. Thank you very much for the help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now