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.
Install sql server 2014 step by step password#
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 2014 step by step install#
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 AdventureWorks2012 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 kommentar(er)
