![]() In this section, you configure distribution at the publisher and set the required permissions on the publication and distribution databases. Select OK to close the repldata Properties dialog box.įor more information, see Secure the snapshot folder. You'll need this path later when you're configuring your snapshot folder. Select the Sharing tab again and note the Network Path for the share. Verify that the following permissions are allowed: Repeat the previous step to add permissions for the Distribution Agent as \repl_distribution, and for the Merge Agent as \repl_merge. In the Select Users, Computers, Service Accounts, or Groups box, type the name of the Snapshot Agent account that you created previously, as \repl_snapshot. In the Permissions for repldata dialog box, select Add. In the repldata Properties dialog box, select the Security tab and select Edit: Select OK to close the Advanced Sharing dialog box. Repeat step 6 to add the other two accounts that you created previously: \repl_merge and \repl_distribution.Īfter you add the three accounts, assign the following permissions:Īfter your share permissions are configured correctly, select OK to close the Permissions for repldata dialog box. In the Select User, Computers, Service Account, or Groups box, type the name of the Snapshot Agent account that you created previously, as \repl_snapshot. In the Advanced Sharing dialog box, select Share this Folder, and then select Permissions. On the Sharing tab in the repldata Properties dialog box, select Advanced Sharing.ī. Right-click this folder and select Properties.Ī. The default location is C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Data. In File Explorer, browse to the SQL Server data folder. Create a share for the snapshot folder and assign permissions In this section, you configure the snapshot folder that's used to create and store the publication snapshot. ![]() Repeat the previous step to create the repl_merge account. Repeat the previous step to create the repl_logreader, repl_distribution, and repl_merge accounts:Ĭreate local Windows accounts for replication agents at the subscriberĪt the subscriber, open Computer Management from Administrative Tools in Control Panel.Įnter repl_distribution in the User name box, provide the password and other relevant information, and then select Create to create the repl_distribution account. Right-click Users and then select New User.Įnter repl_snapshot in the User name box, provide the password and other relevant information, and then select Create to create the repl_snapshot account: In System Tools, expand Local Users and Groups. Create local Windows accounts for replication agents at the publisherĪt the publisher, open Computer Management from Administrative Tools in Control Panel. ![]() If the publisher and subscriber share the same instance, the steps that are used to create accounts at the subscriber are not required. The publisher and subscriber might share the same instance of SQL Server, but it is not a requirement. The subscriber instance (NODE2\SQL2016) is remote. In the replication tutorials, the publisher and distributor share the same instance (NODE1\SQL2016) of SQL Server. For instructions on restoring a database in SSMS, see Restoring a database. Install SQL Server 2017 Developer edition.ĭownload the AdventureWorks sample database. SQL Server Compact cannot be a subscriber in transactional replication. To enhance security, the sample databases are not installed by default.Īt the subscriber server (destination), install any edition of SQL Server, except SQL Server Compact. The AdventureWorks2022 sample database.These editions cannot be replication publishers. Any edition of SQL Server, except SQL Server Express or SQL Server Compact.To complete this tutorial, you need SQL Server, SQL Server Management Studio (SSMS), and an AdventureWorks database:Īt the publisher server (source), install: This tutorial is for users who are familiar with fundamental database operations, but who have limited exposure to replication. Create Windows accounts for replication.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |