Friday, March 9, 2012

Remote instance not listed in Available Servers in Enterprise Manager

When using the register available servers in Enterprise Manager, the
named instances on a remote machine are not listed. The unnamed
instance is listed and will register successfully.
I have tried manually typing the names of the remote NAMED instances;
then tried to authenticate and get the message "SQL server does not
exist or access denied".
Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
2 Instances
Unnamed
DEV\DB1
On the remote machine SQL Server 2000 (MSDE Edition) installed
3 Instances;
Unnamed
REM\DB1
REM\DB2
Both machines are on the same domain. All SQL server instances are
running.
I have also used the svrnetcn.exe tool to make sure the Named Pipes
and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
been changed to 1433 on all remote instances. (both machines were
rebooted)
What else can I check ?
Thanks
D> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
Each instance on a machine must listen on a unique TCP port. Consequently,
all of the instances on your REM machine can't be listening on the same 1433
port. Check the errorlog file for those instances for related TCP port
binding errors and change the named instance ports, if needed.
The normal configuration is that the default (unnamed) instance listens on
1433 and named instance ports are determined dynamically. When a client
connects to a named instance, it firsts gets a list of running named
instances via a UDP 1434 request and then connects to the TCP port of the
specified instance. Make sure your firewall allows TCP 1433, UDP 1434 and
TCP traffic on the named instance ports. See
http://support.microsoft.com/kb/287932
--
Hope this helps.
Dan Guzman
SQL Server MVP
"DM" <dmcb73@.gmail.com> wrote in message
news:1190197075.363594.146870@.22g2000hsm.googlegroups.com...
> When using the register available servers in Enterprise Manager, the
> named instances on a remote machine are not listed. The unnamed
> instance is listed and will register successfully.
> I have tried manually typing the names of the remote NAMED instances;
> then tried to authenticate and get the message "SQL server does not
> exist or access denied".
> Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
> 2 Instances
> Unnamed
> DEV\DB1
> On the remote machine SQL Server 2000 (MSDE Edition) installed
> 3 Instances;
> Unnamed
> REM\DB1
> REM\DB2
> Both machines are on the same domain. All SQL server instances are
> running.
> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
> What else can I check ?
> Thanks
> D
>

No comments:

Post a Comment