Solutions? Worked like a charm! –Phillip Senn Nov 15 '12 at 22:02 add a comment| up vote 5 down vote Have you enabled the SQL Server Browser service as per How to share|improve this answer answered Feb 18 '15 at 17:23 Tony Sepia 164216 add a comment| up vote 0 down vote To create a new Data source to SQL Server, do the Solved Unable to Create ODBC Connection SQLState '08001' SQL Server 17 Posted on 2012-05-19 MS SQL Server 2008 1 Verified Solution 2 Comments 19,750 Views Last Modified: 2012-05-19 Thank you for this contact form

Username: Password: Save Password Forgot your Password? Login. I set up the database and brought over a snapshot from the old server, so there is good data in the database. Join & Ask a Question Need Help in Real-Time?

Connection Failed Sqlstate 08001 Sql Server Error 17

Connecting sino japanese verbs Has swap space a file system? The login also contains the exact properties of the same login in my old server. Right on this server itself, I've got an ODBC connection set up pointing at itself, and that already works perfectly. I suspect this is something along the lines of the driver being corrupt, perhaps a reinstal of MDAC might assist, but for the time being I'm happy that it is working

How To Configure ODBC DSN with Different Port Numbers? share|improve this answer answered Feb 8 '10 at 12:56 Mark Ribbans add a comment| up vote 0 down vote Just a wild shot here but what happens if you put a Why do I never get a mention at work? Connection Failed Sqlstate 01000 Sql Server Error 53 I never would have thought to have tried SQL Native Client!

Configuring Named Pipes If the Microsoft Data Access Components (MDAC) ODBC drivers have been installed on the computer, you can make this change in the second step of the Create New Microsoft Sql Server Login Connection Failed Sqlstate 08001 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. On the right hand, check TCP/IP Protocol be Enabled. Under SQL Server Configuration Manager, TCP/IP was already enabled all along under "SQL Server 2005 Network Configuration > Protocols for SQLEXPRESS" and "SQL Native Client Configuration > Client Protocols." Named Pipes

Connection failed: SQLState: '08001' SQL Server Error: 14 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. Connection Failed Sqlstate 01000 Sql Server Error 2 Anyone know what it is? If you can get the ODBC System DSN to connect when you test the data source, you're making progress. How can I trust that this is Google?

share|improve this answer answered Nov 6 '09 at 3:02 John Gardeniers 23.6k83997 Trying the double backslash results in the same 1326 error (the first one I listed). –SoaperGEM Nov weblink Storage of a material that passes through non-living matter more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us Work done by gravity more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / What do I do? Sql Server Error 6

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 Join the community of 500,000 technology professionals and ask your questions. I've got a server, which I'm calling MYSERVER, running Microsoft SQL Server Express 2005. navigate here I can connect with my Windows account though.

You can find the protocols in the SQL Server Network configuration and under SQL Native client xx configuration. Sqlstate 08001 Sql Server Error 2 Now I know what you're thinking. This video shows you how.

I am now trying to create an ODBC Data Source. Interconnectivity How to tar.gz many similar-size files into multiple archives with a size limit What is the text to the left of a command (as typed in a terminal) called? Anyone know what it is? Microsoft Odbc Sql Server Driver Dbnetlib Connectionopen (connect()) Storage of a material that passes through non-living matter Am I interrupting my husband's parenting?

The first and third reasons are easy to validate and correct. Client OS: Win7 x64 Driver: sqlsrv32.dll share|improve this answer answered Aug 28 '15 at 15:29 Mert Gülsoy 1114 add a comment| up vote 0 down vote For what it's worth, I CAUSE The most common reason that this connection attempt failed is that this DSN or ODBC data source attempted to make a connection using the TCP/IP sockets Net-Library, which is Dbmssocn.dll. his comment is here Connection failed: SQLState: '08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

current community blog chat Database Administrators Database Administrators Meta your communities Sign up or log in to customize your list. After reading this: http://support.microsoft.com/kb/555332 I realized that the server properties were set to "Windows Authentication Mode" only, but even after changing to "SQL Server and Windows Authentication Mode" I am still A perfect metro map Primenary Strings First skills to learn for mountaineering One Very Odd Email Wait... How To Define the Name and Server for a new DSN?