Connection failed: SQLState: '08001' SQL Server Error: 14 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. Right on this server itself, I've got an ODBC connection set up pointing at itself, and that already works perfectly. View our list of code downloads. So does that mean I just need to use some different syntax to specify the IP along with an instance name?
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: I log in using SQL Server Authentication (not Windows authentication), and it's set up like this: Like I said, that one works. I know the SQL Server exists, works, and an ODBC connection can be set up properly; I'm just not sure what it is I've got wrong in my connection settings that's But the ODBC connection doesn't seem to work there.
Now I know what you're thinking. I tried setting it up like this: This doesn't work. If I try the same thing, but change the "server" from 123.456.789.012\SQLEXPRESS to just plain old 123.456.789.012, I get a different error: Connection failed: SQLState: '01000' SQL Server Error: 14 [Microsoft][ODBC Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing. 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. Sqlstate 08001 Sql Server Error 2 Based on the latter error I listed, it would seem that it can connect to the server, but simply cannot find the instance (since I didn't specify one that time).
Home Bookstore/E-Books P2P Programmer Forums Wrox Blogs Connect with Wrox Code Resources International IT Certifications Navigation Register Now View Active Topics View Archives View Unanswered Topics Wrox Programmer Forums Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the http://pro.arcgis.com/es/pro-app/tool-reference/tool-errors-and-warnings/tool-errors-and-warnings-80001-80025-080001.htm I've got a server, which I'm calling MYSERVER, running Microsoft SQL Server Express 2005.
Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Sql Server Error 14 What do I do? You might be thinking, "duh, you probably didn't open the firewall for port 1433, dummy." Except I did, and I verified this, as I can successfully run: telnet 123.456.789.012 1433 ...from Thanks in advance.
Home Articles Tips FAQ Books Software SQL Server Scripts Forum   Log in or Sign up SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Posts sql-server odbc share|improve this question asked Nov 6 '09 at 0:22 SoaperGEM 3224818
up vote 25 down vote favorite 7 Note: I've obviously changed the server names and IPs to fictitious ones. Also any other PC makes the ODBC connection to A without any problems Any idea will be appritiated. Here's what's going on. satya, Jun 24, 2005 #2 babrha New current community blog chat Server Fault Meta Server Fault your communities Sign up or log in to customize your list. Sql Server Error 6
NewDBA Member Hi I have too servers A and B Need to create ODBC connection from A to B and getting errror: View Message Thread (8 replies) Results 1 - 9 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. I can ping server B perfectly fine from A.