Link to home
Start Free TrialLog in
Avatar of jhance
jhance

asked on

SQL Server 2000 Replication Problem

I have two SQL Server 2000 installations, on two different servers.  The database currently exists on SERVER1 which is the AD controller for the domain.  I'm attempting to have this database replicate to the server BACKUP1 which is a member server in this same domain.

I setup the SERVER1 as a Publisher/distributor and configured the database to replicate.  I created a subscription to the other computer.  

I'm getting the error messages:

Error Message:

The process could not access database 'MyDatabase' on server 'BACKUP'.

Error Detals:

Could not locate entry in sysdatabases for database 'MyDatabase'. No entry found with that name. Make sure that the name is entered correctly.
(Source: BACKUP (Data source); Error number: 911)

Obviously SERVER1 is having difficulty replicating to BACKUP but I'm not sure how to resolve this.

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of knightEknight
knightEknight
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of imran_fast
imran_fast

make sure your subscriber database exists not nessesary to be the same name as the database on server1 and the sql server agent on both the server (server1 and backup1)  should run under same user name.