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.
| Author |
Topic |
|
Lacuna
Starting Member
2 Posts |
 Posted - 2009-05-20 : 05:37:56
|
| I am getting the following error:Microsoft OLE DB Provider for ODBC Drivers error '80004005'[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Bits of information about my server which might help:- Running SQL server 2000 developer edition and as of yesterday also running an instance of SQL server 2005 standard edition. - Can connect locally to db using studio express but can not connect remotely- Have added the 2005 instance and sql browser to the exceptions in the firewall- Have given windows and sql server authentication to the instanceWhat else should I be checking?Initially I wanted to upgrade my developer edition to standard but apparently that is not an option, you would have to go to a 2008 developer or 2008 enterprise edition, and I have a standard licence so I've had to run the 2000 and 2005 concurrently. Any help would be much appreciated as I can't figure it out :( |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-05-20 : 07:10:07
|
| Go to the surface area configuration and allow remote access. |
 |
|
|
Lacuna
Starting Member
2 Posts |
Posted - 2009-05-20 : 07:23:49
|
quote:
Originally posted by RickD
Go to the surface area configuration and allow remote access.
Thank you, I've already done that tho with no success. Have tried with both option (Using tcp/ip only and the option including named pipes as well) |
|
|
|
|
|
|
SQL Server does not exist or access denied