Re: Cannot connect to Remote SQL Server Named Instance

Tech-Archive recommends: Speed Up your PC by fixing your registry

Use SQL Server Configuration Manager and for the Services,
make sure the SQL Browser Service is running.

-Sue

On Thu, 10 Aug 2006 09:06:01 -0700, Forch
<Forch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi...

On a remote server, I have SQL 2005 installed as the default instance as
well as a new named instance.

From SQLCMD, I can connect to both instances. However, from Management
Studio, I can only connect to the default instance. Is there something
special I have to do to connect to the named instance? I try connecting
using:

[My-Server-Name]/InstanceName

Any ideas? I get the "error locating server/instance specified" generic
error.

Thanks!

.

Relevant Pages