Odbc Connection Failed Sql Server Error 14
Contents |
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow connection failed sqlstate 08001 sql server error 17 the company Business Learn more about hiring developers or posting ads with us Server Fault
Connection Failed Sqlstate 01000
Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join
Sqlstate 01000 Sql Server Error 53
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 top How do I get this SQL
Sqlstate 01000 Sql Server Error 2
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 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 odbc connection to sql server failed 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 SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. 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 SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()). Connection failed: SQLState: '08001' SQL Server Error: 14 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. Now I know what you're thinking. You might be thinking, "duh, you probably didn't open the firewall for port 1433, dummy." Except I did, a
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on connection failed sqlstate 01000 sql server error 10060 over! We've restricted the ability to create new threads on these forums. sql server error 6 SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! sqlstate 08001 sql server error 2 Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums Other SQL Server Topics (2005) Erro 14 Reply to Topic Printer Friendly Author Topic Shookums Starting Member http://serverfault.com/questions/82007/how-do-i-get-this-sql-server-odbc-connection-working USA 13 Posts Posted-06/14/2010: 15:44:31 I have Master computer using SQL 2005 express. I am getting this:connection failed:SQL State: '01000'SQL Server Error: 14(Microsoft)(ODBCSQL Server Driver)(Shared memory)(Connection Open)(Invalid Instance()Connection FailedSQL State: '08001SQL Server Error 14MicrosoftODBCSQL Server Driver Shared Memory invaid connectionWhat am I doing wrong? My test in OCBC to the database fails each time.Any help is appreciated.Sherry tkizer Almighty SQL Goddess http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=146017 USA 38200 Posts Posted-06/14/2010: 15:50:26 Try via TCP/IP: serverName,portNumberIf that works and you don't want to remember the port, then I can help you setup an alias.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog Shookums Starting Member USA 13 Posts Posted-06/14/2010: 17:20:59 When you say server name- the one that came up when I set up SQL-Server? then go to the port and put in my 1433?Sherry Shookums Starting Member USA 13 Posts Posted-06/14/2010: 17:25:08 currntly:TCI/pc- Server is: .Name is: .Port is grey - 1433Data base has a default of 1433, and normally it looks for the (local) server and data base name with passcode. tkizer Almighty SQL Goddess USA 38200 Posts Posted-06/14/2010: 17:27:22 Log into the database server directly, open a cmd window and type hostname. That's the name you need to test with. 1433 is just the default port, you need to find out what port you are using it and use that to test it. You can see the port in SQL Server Configuration Manager or in t