all groups > sql server connect > august 2006 >
You're in the

sql server connect

group:

Cannot connect to Remote SQL Server Named Instance


Cannot connect to Remote SQL Server Named Instance Forch
8/10/2006 9:06:01 AM
sql server connect:
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.

Re: Cannot connect to Remote SQL Server Named Instance Arnie Rowland
8/10/2006 9:19:24 AM
[/] 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


[quoted text, click to view]

Re: Cannot connect to Remote SQL Server Named Instance Sue Hoegemeier
8/10/2006 10:23:01 AM
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
[quoted text, click to view]
Re: Cannot connect to Remote SQL Server Named Instance Forch
8/10/2006 11:10:02 AM
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

[quoted text, click to view]
AddThis Social Bookmark Button