I am trying to make a connection to a named instance of a server that has a "\" in the name. In this case it is a SQL2000 Server instance (named: "SQLSERVER\SQLSERVER2000") that is running on a server that also has a SQL7 Server instance (named: "SQLSERVER") running on it. Using the following, I can connect to the SQL7 instance, but I'm getting an error messsage when I try to connect to the SQL2000 server instance:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNMPNTW]Specified SQL server not found.
/whitepapers/databases.asp, line 9


Here's an example of the connection that I'm trying to use:
<%
sConnect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sqluser;Initial Catalog=master;Data Source=SQLSERVER\SQLSERVER2000"
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open sConnect
%>

Any Ideas?

Firstly:
Check that the named instance of SQL server has actually been started.

Secondly:
Check to see if you have to use the SQL Server switch facility to switch in the named instance from the default SQL Server 7 instance.

Thanks for the replies. The service was definately started and I'm not sure what you were refering to with the "SQL Server Switch Facility"
I actually ended up getting the connection to work after updating the MDAC on the IIS Server. I think it was running on MDAC 2.1 or earlier; I updated it to 2.6. I had moved the page to another server and it found the SQL Server without problems there. After updating that it took me a few more tries but now it's found it without further errors.

Hi

I have since read that if you want to connect to a named instance of SQL Server you need to be using MDAC 2.6 anyway.

Try this link:
http://www.able-consulting.com/MDAC/...erForSQLServer

That's a great link. Thanks for passing it on, it's nice to have some verification that the MDAC is what needed to be fixed to solve the error. Thanks!

MDAC 2.7 is installed, yet the error continues to reign. HELP!

What is your computer Name? Is that "SQLSERVER" itself? Or try giving the server IP address.

Also can you check if the Instance should be given as "SQL Server 2000" ? - with spaces in between. I searched a lot on sample instance name and found no clue, Still search is on, But I guess this there should be some problem with spelling it out there.

Will update you if I find something useful.

-Vijay G