Thursday, March 22, 2012

Can not connect to non-default instance from remote computer

I installed SQL2005 as default instance.
After that I installed SQL2000 with instance name "SQL2K". Then I installed
SP4.
I can'not connect to SQL2K instance from remote machine. But if I log on at
machine on which SQL Server installed I can connect to instance.
And I can connect to default instance (SQL2005) from remote machine.
How to solve this problem?Is the SQL Server Browser service running? It helps resolve names of named
instances to the port number. Since SQL Server 2005 is the default instance,
it is probably using port 1433. Therefore SQL Server 2000 must be using some
other port, but you don't know which port, but the SQL Server Browser
service will know.
--
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Alexey Rokhin" <ar@.hotmail.com> wrote in message
news:%23PF4wc16FHA.1416@.TK2MSFTNGP09.phx.gbl...
>I installed SQL2005 as default instance.
> After that I installed SQL2000 with instance name "SQL2K". Then I
> installed SP4.
> I can'not connect to SQL2K instance from remote machine. But if I log on
> at machine on which SQL Server installed I can connect to instance.
> And I can connect to default instance (SQL2005) from remote machine.
> How to solve this problem?
>

No comments:

Post a Comment