Error conecting to SQL Server 2005 from Access 2002

I have installed SQL Server Express 2005 on Vista and I am trying to link to a table from Access 2002. When I create a New Data Source (via the ODBC option) I get the following error:

Connection Failed:                    
SQLState: '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.                    

more ▼

asked Oct 19, 2009 at 07:17 AM in Default

avatar image

11 1 1 1

Are you trying to connect to a local or remote SQL Server instance? The Shared Memory is for a local connection.

Oct 20, 2009 at 04:56 PM Benjamin
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

By default remote connections are disabled with an Express Edition installation. Verify you have enabled remote connections.

  • Start SQL Server Configuration Manager (found in Programs -> SQL Server 2005 -> Configuration Tools or by typing SQLServerManager.msc (NOTE: SQLServerManager10.msc for 2008).
  • Expand Network Configuration
  • Click the appropriate instance (SQLEXPRESS)
  • Double-click on TCP/IP and change Enabled to Yes.
  • Verify the the SQL Server Browser service is enabled (for remote connections) unless you are going to use a static TCP port.

Otherwise if you have already enabled remote connections and it is still not working, what is the connection string information you are entering?

more ▼

answered Oct 20, 2009 at 04:55 PM

avatar image

320 3 5 8

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 19, 2009 at 07:17 AM

Seen: 1798 times

Last Updated: Oct 19, 2009 at 10:38 AM

Copyright 2018 Redgate Software. Privacy Policy