Login for Updatable Subscriptions
If you selected Replicate on the Updatable Subscriptions page of this wizard, you must specify an account at the Subscriber under which connections to the Publisher are made for immediate updating subscriptions. Connections are used by the triggers that fire at the Subscriber and propagate changes to the Publisher. This account is required even if you selected Queue changes and commit when possible on the Updatable Subscriptions page, because by default the New Subscription Wizard configures queued updating with the ability to switch to immediate updating if required.
The account specified for the connection should only be granted permission to insert, update, and delete data on the views that replication creates in the publication database; it should not be given any additional permissions. Grant permissions on views in the publication database that are named in the form syncobj_<HexadecimalNumber> to the account you configured at each Subscriber.
There are three options available for the type of connection:
A linked server or remote server that you have already defined.
A linked server that replication creates; the connection is made with the credentials you specify in this wizard.
A linked server that replication creates; the connection is made with the credentials of the user making the change at the Subscriber.
The first two options can be specified in this wizard. The last option can only be specified using sp_link_publication (Transact-SQL); specify a value of 1 for the parameter @security_mode.
- Create a linked server that connects using the following SQL Server Authentication login:
Replication creates a linked server using the credentials specified in the Login and Password fields.
Enter a Microsoft SQL Server login that has only the permissions described in this topic.
Enter a strong password for the login specified in Login.
- Confirm Password
Re-enter the password to confirm that it was entered correctly.
- Use a linked server or remote server that you have already defined.
This option requires a linked server or remote server that you have already defined. For more information, see Linked Servers (Database Engine) and Remote Servers. Ensure that the login used for the linked server or remote server has a strong password and has only the permissions described in this topic.