Replication: SQL Server 2000 - Part 2 - Getting Started: Step-By-Step
(Page 2 of 7 )
Set Up Proper Login for Replication
To set up replication, you must use a login account that is a member of SQL Server's Process Administrators (or higher authority) server role. I used “sa” and had no problems.
Configuring Server for Publishing, Subscribers and Distributor
Under SQL Server enterprise manager navigate to the Tools/Replication menu, run Configure Publishing and Distribution Wizard:
Select your server as Publisher, Distributor and Subscriber server:
Specify the location where snapshots, from publishers that use this distributor, will be stored:
Configure your server with the default settings or apply custom settings; in this example I would use the default settings.
With the above settings you have enabled your server as a distributor server, and have created Publishers and Subscribers. This process will also create a New Distribution Database under the selected server.
Next: Getting Started: Step-By-Step, Cont'd. >>
More SQL Server Articles
More By Mahesh Kodli
