Cannot connect to Remote SQL Server Named Instance

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![/] is also not allowed for a servername -the instance is part of the na
me.
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@.discussions.microsoft.com> wrote in message
news:DE18DCC1-CA47-4066-8E34-2ED8250A9DD5@.microsoft.com...
> 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!|||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@.discussions.microsoft.com> 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!|||Thanks for the suggestion. Unfortunately it didn't work...
The name without the square brackets works with Management Studio locally.
Do you have any other ideas?
Thanks,
Mark
"Arnie Rowland" wrote:

> [/] 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@.discussions.microsoft.com> wrote in message
> news:DE18DCC1-CA47-4066-8E34-2ED8250A9DD5@.microsoft.com...
>
>