How to connect a remove SQLServer 2005 with instance name

  • Thread starter Thread starter ad
  • Start date Start date
A

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?
 
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.
__________________________________
 
Back
Top