question

jlyell avatar image
jlyell asked

I have 4 instances of SQL server running on the same VM, 2012, 2014,2016 and 2017. I am setting up replication distribution or publish and getting this error at the very end <>

An error occurred during Service Master Key decryption There is no remote user 'distributor_admin' mapped to local user '(null)' from the remote server 'repl_distributor'. Changed database context to 'master'. (.Net SqlClient Data Provider) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=13.00.5081&EvtSrc=MSSQLServer&EvtID=33094&LinkId=20476 ------------------------------ Server Name: DB_SERVER Error Number: 33094 Severity: 16 State: 9 Procedure: sp_addlinkedsrvlogin Line Number: 91

replicationsql server servicemaster data service
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

There is a known issue, does this help?

https://support.microsoft.com/en-gb/help/3091643/fix-error-occurs-when-you-configure-sql-server-replication-or-set-up-a

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.