When the creation of service master key for Microsoft SQL Server 2012 or SQL Server 2014 fails during the setup, SQL Server doesn’t log this failure correctly. This leads to some issues, for example, when you try to configure SQL Server replication, you receive the following error message:
An error occurred during decryption. There is no remote user 'distributor_admin' mapped to local user '(null)' from the remote server 'repl_distributor'. Changed database context to 'master'. (Microsoft SQL Server, Error: 15466)
When you try to create a linked server together with remote logins, you encounter the error:
An error occurred during decryption
Additionally, you may receive the following error message in SQL Server error log:
<Date> <Time> spid5s Service Master Key could not be decrypted using one of its encryptions. See sys.key_encryptions for details.
When you query the catalog view sys.symmetric_keys, one row for the service master key is returned. When you query the catalog view sys.key_encryptions, no row is returned. The expected result is two rows.
After you apply this update, the metadata will be left clean if the service master key creation failure occurs during the setup, and the next SQL Server service restart will try to create a service master key again. Additionally, more error messages about the service master key creation failure will be logged in the error log.
If you have encountered this issue, this update won't work, and you have to use one of the workarounds listed in the "Workaround" section.
In order to use the changes in this cumulative update, you have to install SQL Server by using the Product Update feature and perform a slipstreamed install with RTM + SP + CU.
The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server: