Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 683
  • Last Modified:

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.

1 Solution
Assuming that your source objects on SERVER1 are in a database called MyDatabase, then you would do well to create an empty database by the same name on BACKUP1 before you push the subscription.  This will allow you to set the initial size of the data and log files appropriately.

Then right-click on the Distributor Agent and select Properties.  Then make sure the "owner" has sufficient rights to push the data to the subscriber.  (You may wish to create a separate login just for this purpose).
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.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now