Connection Failed, Error 2 - SQL Server Forums

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

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

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 ?

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

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 ?

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

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources