Friday, February 17, 2012

Enterprise Manager - Available Servers - remote instance not listed

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
DHow about trying adding aliases from SQL Server Client Network Utility?
Add Aliases for your named instances and try connecting then.
You may obtain more info about this from the following link:
http://msdn2.microsoft.com/en-us/library/aa213780(SQL.80).aspx
You may want to have a look at the following article from BOL to learn more
about Browser Service of SQL Server 2005. This may be irrelevant however it
informs you about SS2000' s listening service too. It may give you an idea.
http://msdn2.microsoft.com/en-us/library/ms181087.aspx
--
Ekrem Önsoy
"do" <dmcb73@.gmail.com> wrote in message
news:1190189984.640820.24640@.o80g2000hse.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