By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,592 Members | 1,931 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,592 IT Pros & Developers. It's quick & easy.

Cannot Register Instance of SQL Server 2000

P: n/a
Information:

Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
Enterprise Edition. SQL Service pack is 3a. Member of domain
ABCDomain. Server A is going to function as a Distributor.
Location: New York.

Server B: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
Standard Edition. SQL Service pack is 3a. Member of domain
ABCDomain. Server B is going to function as a Subscriber.
Location: London.

Server C: SQL Server 2000 Enterprise Edition. OS is Windows 2000 Advanced
Server. SQL Service pack 3a. Member of domain ABCDomain. Server C
is going to function as a Publisher. Location New York.

Problem: I am setting up a test replication environment prior to going live
with a replication from New York to London. When I try to register
Server A on Server B, I get the error: SQL Server does not exist or
access denied'. I get the same error when I try to register Server
B on Server A. Both boxes can ping the other. I am able to
register Server C (Publisher) on both Server A and B as well as
register both Server A and B on Server C.

I would appreciate your input as to what could be causing this
problem as well as a possible solution.

Thank you in advance.
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Robert M." <rm******@integratedbsi.com> wrote in message
news:9f**************************@posting.google.c om...
Information:

Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
Enterprise Edition. SQL Service pack is 3a. Member of domain
ABCDomain. Server A is going to function as a Distributor.
Location: New York.

Server B: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
Standard Edition. SQL Service pack is 3a. Member of domain
ABCDomain. Server B is going to function as a Subscriber.
Location: London.

Server C: SQL Server 2000 Enterprise Edition. OS is Windows 2000 Advanced
Server. SQL Service pack 3a. Member of domain ABCDomain. Server C is going to function as a Publisher. Location New York.

Problem: I am setting up a test replication environment prior to going live with a replication from New York to London. When I try to register Server A on Server B, I get the error: 'SQL Server does not exist or access denied'. I get the same error when I try to register Server B on Server A. Both boxes can ping the other. I am able to
register Server C (Publisher) on both Server A and B as well as
register both Server A and B on Server C.

I would appreciate your input as to what could be causing this
problem as well as a possible solution.

Thank you in advance.


I'm not really sure what you mean by "register" an instance - do you mean
you're using Enterprise Manager locally on Server B, and trying to register
Server A? Or do you mean you're doing something specific with the
replication tools? Either way, one key thing to check would be the service
account used for MSSQL and whether it has access to all the servers. This KB
article discusses many other possibilities:

http://support.microsoft.com/default...06&Product=sql

Simon
Jul 20 '05 #2

P: n/a
I am trying to register the instance via Enterprise Manager locally on
each SQL Server. Also, for a test, I setup MSSQLSERVER and
SQLSERVERAGENT services using a domain administrator. Still I cannot
register Server A (through EM) on Server B or Server B (through EM) on
Server A.
"Simon Hayes" <sq*@hayes.ch> wrote in message news:<41**********@news.bluewin.ch>...
"Robert M." <rm******@integratedbsi.com> wrote in message
news:9f**************************@posting.google.c om...
Information:

Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
Enterprise Edition. SQL Service pack is 3a. Member of domain
ABCDomain. Server A is going to function as a Distributor.
Location: New York.

Server B: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server
Standard Edition. SQL Service pack is 3a. Member of domain
ABCDomain. Server B is going to function as a Subscriber.
Location: London.

Server C: SQL Server 2000 Enterprise Edition. OS is Windows 2000 Advanced
Server. SQL Service pack 3a. Member of domain ABCDomain.

Server C
is going to function as a Publisher. Location New York.

Problem: I am setting up a test replication environment prior to going

live
with a replication from New York to London. When I try to

register
Server A on Server B, I get the error: 'SQL Server does not

exist or
access denied'. I get the same error when I try to register

Server
B on Server A. Both boxes can ping the other. I am able to
register Server C (Publisher) on both Server A and B as well as
register both Server A and B on Server C.

I would appreciate your input as to what could be causing this
problem as well as a possible solution.

Thank you in advance.


I'm not really sure what you mean by "register" an instance - do you mean
you're using Enterprise Manager locally on Server B, and trying to register
Server A? Or do you mean you're doing something specific with the
replication tools? Either way, one key thing to check would be the service
account used for MSSQL and whether it has access to all the servers. This KB
article discusses many other possibilities:

http://support.microsoft.com/default...06&Product=sql

Simon

Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.