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."Robert M." <rmizzaro@.integratedbsi.com> wrote in message
news:9ff47a28.0407270533.280efcbd@.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/defaul...306&Product=sql
Simon|||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" <sql@.hayes.ch> wrote in message news:<41068db6$1_2@.news.bluewin.ch>...
> "Robert M." <rmizzaro@.integratedbsi.com> wrote in message
> news:9ff47a28.0407270533.280efcbd@.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/defaul...306&Product=sql
> Simon
No comments:
Post a Comment