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

ODBC Connection Expand / Collapse
Author
Message
Posted Monday, December 31, 2007 6:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 21, 2014 9:10 AM
Points: 88, Visits: 178
When trying to create an ODBC connection by selecting SQL Server driver, the following error is being displayed:

Connection failed:
SQL State '01000'
SQL Server Error: 2
[Microsoft] [ODBC SQL Server Driver],[Shared Memory]ConnectionOpen (Connect()).
Connection failed:
SQL State '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory] Sql Server does not exist or access denied.


The following services are started:
SQL Server ($InstanceName)
SQL Server Browser

There seem to be no security restrictions on the user because it can be used to query tables from the SQL Management Studio and by the application which uses the logon.

SQL Server 2005 Express running on a Virtual PC 2007 Virtual Machine.

Is it possibly an issue with the ODBC driver? Any ideas?
Post #437550
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse