Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Connection Failed, Error 2

Author  Topic 

azoic
Starting Member

4 Posts

Posted - 2008-11-04 : 08:15:06
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.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-11-04 : 08:30:10
Enable surface area config
Go to Top of Page

azoic
Starting Member

4 Posts

Posted - 2008-11-04 : 09:09:23
Thanks, I have been into Surface Area Configuration:
Services and connections: the engine and browser are running
Features:
Ad Hoc Remote queries is enabled
CLR Integration is enabled
OLE Automation is enabled
xp_cmdshell is enabled
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-11-04 : 12:31:12
quote:
Originally posted by azoic

Thanks, I have been into Surface Area Configuration:
Services and connections: the engine and browser are running
Features:
Ad Hoc Remote queries is enabled
CLR Integration is enabled
OLE Automation is enabled
xp_cmdshell is enabled




So its ok now ?
Go to Top of Page

azoic
Starting Member

4 Posts

Posted - 2008-11-04 : 14:38:15
No, it's still not working. Have you any more ideas?
For server name I am typing (local). If I type garbage I get a different error (53).
The error happens after I enter my login name. I used SQL server authentication with sa.
If I use NT authentication, I get the same message. I also get the same message if I use an invalid login.

Thanks
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-11-04 : 14:46:28
Try and ping the server.

Do you have a firewall ?
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2008-11-04 : 14:52:39
Did SQL Express install as a named instance (e.g. "MyServer\SQLExpress")? I have seen other machines setup that way. Not sure if that is a default setting or not, but it could throw a message like that if your connection is not specifying the named instance.

---------------------------
EmeraldCityDomains.com
Go to Top of Page

azoic
Starting Member

4 Posts

Posted - 2008-11-04 : 15:39:33
Both SQL Server and Access are on the same PC so can I assume it isn't a firewall issue?

When I installed SQL Express, it failed the first time because it said there was already an SQLExpress instance. I don't know why although previously SQL Express 2008 was uninstalled so maybe it was something to do with that. I reran and called it SQLExpress2005 and the installation completed OK.

When I get the error creating the DSN I typed "(local)" for "Which SQL Server do you want to connect to?". If I type "pc_name\SQLExpress2005" - it works!!! (I am typing this reply while trying it out.) Many thanks for your help.
Go to Top of Page
   

- Advertisement -