Connection Failed Sqlstate 08001 Error 17
Contents |
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the connection failed sqlstate 08001 sql server error 5 workings and policies of this site About Us Learn more about
Connection Failed Sqlstate 08001 Sql Server Error 53
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions
Connection Failed Sqlstate 08001 Sql Server Error 0
Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's
Connection Failed Sqlstate 08001 Sql Server Error 2
how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top How do I get this SQL Server ODBC Connection working? up vote 25 down vote favorite 7 Note: I've obviously changed the server names and IPs to fictitious ones. Here's what's going on. I've got a server, which sql state 08001 sql server error 17 I'm calling MYSERVER, running Microsoft SQL Server Express 2005. Right on this server itself, I've got an ODBC connection set up pointing at itself, and that already works perfectly. I log in using SQL Server Authentication (not Windows authentication), and it's set up like this: Like I said, that one works. But next, I've got another computer which is on a totally different domain/not on the intranet, that needs to access this same SQL Server hosted on MYSERVER. Because it's on a different domain, it doesn't recognize the name "MYSERVER"; I have to point it at the IP address of MYSERVER, which we'll say is 123.456.789.012. But the ODBC connection doesn't seem to work there. I tried setting it up like this: This doesn't work. When I put in the username and password and press Next, it stalls for a good 10 to 20 seconds, and then finally comes back with the following error: Connection failed: SQLState: '01000' SQL Server Error: 1326 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC
the previous tutorial. After clicking Next on the SQL login information screen, ODBC manager will try to connect to connection failed sqlstate 01000 sql server error 10060 the SQL Server with the login information you provided. After a period connection failed sqlstate 01000 sql server error 14 of waiting time, you may get error message box saying that: Connection failed: SQLState: '01000' SQL Server connection failed sqlstate 01000 sql server error 2 Error: 53 [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. See http://serverfault.com/questions/82007/how-do-i-get-this-sql-server-odbc-connection-working the picture below: Three possible reasons for the failing: Wrong server name - You provided an incorrect server name. SQL Server not configured to take a network connection - You need to check the SQL Server configuration. Wrong login name or password - You provided incorrect login name or password. The first and third http://dba.fyicenter.com/faq/sql_server_2/Getting_Connection_failed_Error_on_DSN_Creation.html reasons are easy to validate and correct. The second reason requires further investigation. Continue with the next tutorial to configure your SQL Server to take a network connection. (Continued on next topic...) What Is Open Database Communication (ODBC)? How To Add a New DSN with the ODBC Driver for SQL Server? How To Define the Name and Server for a new DSN? How To Provide Login Information for a New ODBC DSN? Why Are You Getting Errors When Creating a New ODBC DSN? What Are the Requirements on SQL Server Network Connections? How To Start SQL Server Browser Service? How To Enable TCP/IP Protocol on a SQL Server? How To Verify the Port Number of the SQL Server? How To Configure ODBC DSN with Different Port Numbers? How To Configure and Test ODBC DSN Settings? How To Connect MS Access to SQL Servers through ODBC? How Can Windows Applications Connect to SQL Servers via ODBC?
Related Articles: More... Other Tutorials/FAQs: More... Related Resources: More... Selected Jobs: More...of Ethernet switches and upgrade to Gigabit speed. 10GbE Upgrade Being in Entertainment with the amount of data that we are transferring daily. GigE just wasn't cutting https://community.spiceworks.com/topic/372789-sqlstate-08s01-08001-connection-failure it anymore. So we went the path of adding 10GbE on top of our fiber connection. Virtual Lync Server Rollout Build and deploy a virtual Lync server to replace our aging Trillian/LCS platform. http://www.dbforums.com/showthread.php?1678285-ODBC-Connection-to-SQL-Server-Error-10060 IN THIS DISCUSSION Microsoft SQL Server 2014 Microsoft Wind...Server 2008 R2 Dell 116281 Followers Follow Microsoft 490470 Followers Follow Join the Community! Creating your account only takes a few minutes. connection failed Join Now So we've been having issues with network connection loss at our company with the SQLSTATE = 08S01, or SQLSTATE =08001 error message. We have multiple servers which have applications running on them that client systems connect to and retrieve data from. One of our servers has a Microsoft mySQL Server database running on it. However both the mySQL server and the other connection failed sqlstate server that clients connect to are having network issues. If they get connected to the server straight through a remote desktop connection, they do not experience any network issues, which is odd because they are still connected through the network to the server. Either way, these problems don't happen at a given time, they are completely random, and unexpected. Sometimes we can go a full day without an issue, while other times we can have the issue multiple times within an hour or day. Server OSs: Windows 2008 R2 64-bit SP1 with all Updates, including the 2775511 enterprise hotfix rollup updated. http://support.microsoft.com/kb/2775511
Client PCs: Windows 7 64-bit SP1 with all Updates, including the 2775511 enterprise hotfix rollup updated. http://support.microsoft.com/kb/2775511 Network Hardware we use: Dell PowerConnect 5324 Switch (Main Switch), Cisco sf200-24p Switch ( multiple all around the company), Netgear WNDAP660 AP (Main AP), SonicWall TZ 210 (Main Firewall) DHCP and DNS location: Main Server hosting the mySQL server Secondary DNS location: Second server hosting other accounting applications our clients connect to. Here is what I have tried: Disabled Windows Firewall on all systems Disabled all Power Saving Features on all the system, incluis your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 15 of 17 Thread: ODBC Connection to SQL Server Error:10060 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-27-12,15:03 #1 akira919 View Profile View Forum Posts Registered User Join Date Mar 2012 Posts 17 Unanswered: ODBC Connection to SQL Server Error:10060 Hi all, I am trying to setup an ODBC connection to a SQL Server, Control Panel --> Admin Tools --> ODBC --> User DSN --> Type in Host Name --> SQL Authentication Then I get this error, Connection Failed: SQL State: '01000' SQL Server: Error: 10060 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()) Connection Failed: SQL State: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Things I have tried: 1) Enabled TCP/IP and Named-Pipes 2) Did the same on the server machine hosting SQLServer, able to log in with the same host name, and same SQL Authentication. 3) I can ping the server on my machine Can anyone help? Last edited by akira919; 04-27-12 at 15:07. Reply With Quote 04-27-12,15:38 #2 corncrowe View Profile View Forum Posts Registered User Join Date Aug 2004 Location Dallas, Texas Posts 831 Did you try windows authentication? Is the server in mixed mode? Originally Posted by akira919 Hi all, I am trying to setup an ODBC connection to a SQL Server, Control Panel --> Admin Tools --> ODBC --> User DSN --> Type in Host Name --> SQL Authentication Then I get this error, Conne