Re: Cannot connect to Remote SQL Server Named Instance

Tech-Archive recommends: Fix windows errors by optimizing your registry

[/] is also not allowed for a servername -the instance is part of the name.

So put the square brackets around the entire [server/instance] name.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Forch" <Forch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DE18DCC1-CA47-4066-8E34-2ED8250A9DD5@xxxxxxxxxxxxxxxx
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!


.