How to connect a remove SQLServer 2005 with instance name

[ad]

I have install e SQLServer 2005 in another machine with a specific instance.
The server name is Server1 and the instance name is MyDatabase.

When I wnat to add a new ODBC datasource, I enter Server1\MyDatabase as
server in the Wizard, but it say that "The server does not exist"

How can I connect a remove SQLServer 2005 with instance name via ODBC?

 

[Sylvain Lafontaine]

http://www.datamasker.com/SSE2005_NetworkCfg.htm

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

This stuff is for SQL-Server Express 2005 but nearly everything apply to
SQLServer 2005 too.

 

[William \(Bill\) Vaughn]

Why would you want to connect with ODBC? It's like trying to make a
trans-Atlantic call with a CB radio (possible, but difficult).


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________