Error conecting to SQL Server 2005 from Access 2002

Question

question

nthabiseng asked Oct 19, '09

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.

sql-server-2005 login

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Benjamin commented · Oct 20, 2009 at 04:56 PM

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

0 ·

Answer 1 · 2009-10-20T16:55:28Z

Benjamin answered Oct 20, '09

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?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question