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. Also any other PC makes the ODBC connection to A without any problems Any idea will be appritiated. 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 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
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. 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). 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. So does that mean I just need to use some different syntax to specify the IP along with an instance name?
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 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 I'm not sure what to do.
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 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 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. Sqlstate 08001 Sql Server Error 2 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
sql-server odbc share|improve this question asked Nov 6 '09 at 0:22 SoaperGEM 3224818i thought about this Here's what's going on.
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 Sql Server Error 14 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. 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
Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Now I know what you're thinking. Sqlstate 08001 Error 17 What do I do? Sqlstate 01000 Sql Server Error 2 I log in using SQL Server Authentication (not Windows authentication), and it's set up like this: Like I said, that one works.
I tried setting it up like this: This doesn't work. up vote 25 down vote favorite 7 Note: I've obviously changed the server names and IPs to fictitious ones. Connection failed: SQLState: '08001' SQL Server Error: 14 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. I can ping server B perfectly fine from A. Sql Server Error 6
Thanks in advance. 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 Thank you NewDBA, Jun 23, 2005 #2 satya Moderator I would refer this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q328306 and take the measures defined there.