Managing Replication in VS .NET

Drawer PDF417 in VS .NET Managing Replication

19

15. In the Process Account text box, type COMPUTERNAME\ReplSnapAgent, where COMPUTERNAME is your server name. 16. In the Password and Confirm Password text boxes, type P@ssw0rd. 17. Below Connect To The Publisher, verify that By Impersonating The Process Account is selected. 18. Click OK and then click Next. 19. On the Wizard Actions page, select both check boxes. You want SSMS to create the publication as well as the script to have as a reference in the documentation. Click Next. 20. On the Script File Properties page, set the file name to C:\ReplicationPractice\ Scripts\CreateProductsPublicationSecure.sql. Select Overwrite The Existing File and click Next. 21. Name the publication Products and review the configuration. Click Finish to create the publication, the job to run the Snapshot Agent, and the script. 22. Wait until the publication is created and then click Close. 23. Right-click the recently created Products publication and choose Properties. 24. Select the Publication Access List page. 25. Click Add, select the ReplSnapAgent login, and click OK. 26. Click Add again, select the SubscriberUser, and click OK twice. 27. Close SSMS where you are logged on with the PublisherUser account.

In this practice, you create a snapshot publication in a secured environment. You use a limited access account with no special rights at the server level and rights at the Subscriber database and subscription databases. You assign a Windows user account to the distribution agent. 1. Navigate to Start, All Programs, Microsoft SQL Server 2005. 2. Right-click Microsoft SSMS and choose Run As. 3. In the Run As dialog box, select The Following User. In the User Name text box, type SubscriberUser and type the password P@ssw0rd. You will not use a sysadmin account to create the publication; instead, you will use an account with dbo_owner access to the publishing database and no access to the Subscriber database. Click OK. 4. Connect to the default database engine by using Windows authentication.

5. Expand the Replication, Local Publications folder. 6. Right-click the recently created Products publication and choose New Subscriptions. The New Subscription Wizard starts. On the New Subscription Wizard page, click Next. 7. On the Select Publication page, verify that the Products publication is selected. Click Next. 8. On the Distribution Agent Location page, verify that Run All Agents At The Distributor (Push Subscriptions) is selected. Click Next. This process configures push agents to distribute the publication. 9. On the Subscribers page, select the check box for your server, and from the Database drop-down list, select the SubsTesting database. This process will configure SubsTesting as the Subscriber database. Click Next. 10. On the Distribution Agent Security page, click the ( ) button to configure the agent security context. As Figure 19-14 shows, you will assign a Windows user account to the Distribution Agent. Use the following options:

Process Account: COMPUTERNAME\ReplDistAgent (replace COMPUTERNAME with your server name). Password: P@ssw0rd.

19

Confirm Password: P@ssw0rd. In the Connect To The Distributor section, verify that By Impersonating The Process Account is selected. In the Connect to the Subscriber section, verify that By Impersonating The Process Account is selected.

11. Click OK to configure the distribution agent s security and then click Next. 12. On the Synchronization Schedule page, from the Agent Schedule drop-down list, select Define Schedule. 13. In the New Job Schedule dialog box, in the Frequency section, verify that Weekly is selected from the Occurs drop-down list. Verify that Recurs Every is set to 1 and then select the Sunday check box. 14. In the Daily Frequency section, verify that Occurs Once At is selected and set the time to 12:30 AM. 15. Click OK. This process will configure the Distribution Agent to run once a week on Sunday at half past midnight. Click Next. 16. On the Initialize Subscriptions page, verify that Immediately is selected. Click Next. 17. On the Wizard Actions page, select both check boxes. You want SSMS to create the publication as well as the script to have as a reference in the documentation. Click Next. 18. On the Script File Properties page, set the file name to C:\ReplicationPractice\ Scripts\CreateProductsSubscriptionSecure.sql. Select Overwrite The Existing File and click Next. 19. Click Finish to create the subscription and the job to run the Distribution Agent. 20. Wait for the subscription creation to complete and then click Close. 21. Close SSMS.