Thursday, March 22, 2012

Connecting to remote named instance

Hi,
I need some help connecting to a remote named instance of SQL Server 2000
Lets say the server has fqdn: "sqlsrv1.dk.mydomain.com" and is installed as
a named instance with name: "COPENHAGEN"
Trying to connect from another location using
"sqlsrv1.dk.mydomain.com\COPENHAGEN" will fail, but connecting from the
location in question using "sqlsrv1\COPENHAGEN" will succceed.
How do I do this '
In advance, thanks...
SorenSoren,
If the servers are on the same domain, you should be able to connect to the
remote server using
sqlsrv1\COPENHAGEN
Benny
P.S. Where in Denmark
"Soren Staun Jorgensen" <no@.spam.com> skrev i en meddelelse
news:O8BBndMOEHA.1456@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I need some help connecting to a remote named instance of SQL Server 2000
> Lets say the server has fqdn: "sqlsrv1.dk.mydomain.com" and is installed
as
> a named instance with name: "COPENHAGEN"
> Trying to connect from another location using
> "sqlsrv1.dk.mydomain.com\COPENHAGEN" will fail, but connecting from the
> location in question using "sqlsrv1\COPENHAGEN" will succceed.
> How do I do this '
> In advance, thanks...
> Soren
>
>|||It might be name resolution problem.
Ping sqlsrv1.dk.mydomain.com\COPENHAGEN
and
Ping sqlsrv1
is it returning the same ip address.
And also check your MDAC version.
Regards.

No comments:

Post a Comment