服务主密钥解密过程中发生错误 [英] An error occurred during Service Master Key decryption

问题描述

我对 SQL 比较陌生，所以会尽我所能尝试解释.

I am relatively new to SQL so will try explain as best I can.

所有服务器都是 SQL Server 2012

All servers are SQL Server 2012

我目前有一个数据库，其中有两个链接服务器可以访问其他两个数据库.从这 3 个数据库中，我设置了 5 个在存储过程中引用的视图.

I currently have a database which has two Linked Servers to access two other databases. From these 3 databases I have setup 5 view which are referenced in a stored procedure.

尝试运行失败的存储过程时，我打开了该过程并尝试手动运行它以查看问题所在并收到以下错误:

When trying to run the stored procedure it was failing, I opened the procedure and tried to run it manually to see what the issue was and received the below error:

Msg 33094, Level 16, State 1, Line 16
An error occurred during Service Master Key decryption

然后我尝试将其分解，发现在尝试引用使用链接服务器的视图时收到此错误.

I then tried breaking it down and found that I was receiving this error when trying to reference the views that where using the Linked Servers.

我尝试简单地选择这些视图的前 1000 行，但奇怪的是，它会返回 5 次中的 1 次，并在其余时间给出上述错误.

I tried simple selecting the top 1000 rows of these views and strangely enough it will return the values 1 out of 5 times and give the above error the rest of the time.

我试过在谷歌上搜索这个问题，但是当数据库恢复或移动时，很多问题都被引用了，我的没有发生任何类似的事情.

I've tried Googling the issue but a lot of the issue are referenced when a database has been restored or moved, nothing of the sort has happened with mine.

建议运行以下命令以查看是否有错误，而我没有.

it was suggested to run the below to see if there was an error and I've had none.

ALTER SERVICE MASTER KEY REGENERATE

• 我还创建了一个新帐户并重新链接了两台服务器以尝试测试/修复问题.这些帐户是对数据库具有 db_datareader 权限的 SQL Server 身份验证帐户

谁能建议我应该看看什么，我有点迷茫.

Can anyone suggest what I should perhaps look at, I'm a little lost.

预先感谢您的任何帮助或建议.

Thanks in advance for any help or advice.

推荐答案

我们有相同的设置，并且在我们的一些服务器上遇到了完全相同的问题，我们将其缩小到最近的 Windows 补丁，KB3004375(更新以改进 Windows 命令行审核").删除此安全补丁后，不再有错误.

We have the same setup and had exactly the same problem on some of our servers and we narrowed it down to a recent Windows patch, KB3004375 ("Update to improve Windows command-line auditing"). After removing this security patch, there are no more errors.

如果需要，我可以详细说明.

I can elaborate more if needed.

这篇关于服务主密钥解密过程中发生错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！