Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

ODBC Connection to SQLServer Error: 10060 Expand / Collapse
Author
Message
Posted Friday, April 27, 2012 1:04 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:25 AM
Points: 43, Visits: 105
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
4) I can Remote Desktop Connection using my local computer

Can anyone help?
Post #1291775
Posted Friday, April 27, 2012 2:22 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
Sounds like you need to enable remote connections. If value_in_use is 0 for this:

SELECT  name,        
value_in_use
FROM sys.configurations
WHERE name = N'remote access'

Then you'll want to log into the server again, from the local server, and run this:

EXEC sys.sp_configure 
N'remote access',
N'1'
GO
RECONFIGURE WITH OVERRIDE
GO



__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1291829
Posted Friday, April 27, 2012 2:28 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:25 AM
Points: 43, Visits: 105
I checked the value, it was set to 1.
Post #1291837
Posted Friday, April 27, 2012 2:36 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
You posted in a SQL 2008 forum, so to be sure, is it a SQL 2008 or 2008R2 instance we're talking about? If so, your error message says DBNETLIB which points to you may be using a SQL 2000 driver. Do you have the SQL Native Client installed? If so, you should choose that driver when setting up the DSN, i.e. "SQL Server Native Client 10.0", not "SQL Server". The driver version (scroll right in the dialog where you pick the driver) should start with "2009.".

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1291845
Posted Friday, April 27, 2012 2:42 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:25 AM
Points: 43, Visits: 105
Actually my SQL Server is 2012 (I guess I posted on the wrong section, should I remove this post?), I just checked my ODBC connection, it has

SQL Server 2000.85.1132.00

There is no SQL Server Native Client, what should I do next?
Post #1291851
Posted Friday, April 27, 2012 2:47 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
No worries on the 2012 thing, now that we know, it'll be easy to get you some help.

You need the SQL 2012 Client Development Tools. You can get them here: SQL SERVER 2012 EXPRESS EDITION

I think you could go with SQL Server Express with Tools (with LocalDB, Includes the database engine and SQL Server Management Studio Express). If you do not want to install a local instance of the database engine you can get the client tools only by choosing SQL Server Management Studio Express (Tools only).


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1291857
Posted Friday, April 27, 2012 3:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:25 AM
Points: 43, Visits: 105
In my company, we have this offered to be downloaded.

Microsoft SQL Server Native Client 10.0 MUI

Is this enough?
Post #1291888
Posted Friday, April 27, 2012 3:14 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
I do not think you can connect to a SQL 2012 instance with SSMS 2008.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1291889
Posted Friday, April 27, 2012 3:27 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 7:27 PM
Points: 7,107, Visits: 12,657
I see you mentioned the Native Client 10.0, not SSMS...you may be able to use the SQL 2008 Native Client to create an ODBC DSN that will connect to 2012, you just may not have access to all connection-functionality that 2012 offers.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1291894
Posted Friday, April 27, 2012 3:59 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 10:25 AM
Points: 43, Visits: 105
Unfortunately, when I installed the SQL Server Express with Tools, it popped up an error message saying that my computer does not meet the minimum requirement for SQL Server 2012.

So, I downloaded the SQlocalDB.msi file, it said I must install a Windows service pack that contains a newer version of the Windows Installer Service.

So..in essence...if there are no other ways, I willl have to to install 10.0?

Post #1291908
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse