且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

为什么SQL Server无法使用SQL Server连接器连接到Azure密钥库

更新时间:2023-01-30 21:16:34

我遇到了类似的问题,提供程序尝试创建注册表项,但是没有创建权限,因此失败.尝试从此博客

I ran into a similar issue, the provider tries to create a registry key but doesn't have permissions to do so, therefore it fails. Try the following steps taken from this blogpost

打开注册表编辑器

  1. 导航到HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft
  2. 创建一个名为"SQL Server加密提供程序"的新密钥(不带引号)
  3. 右键单击该键,从上下文菜单中选择权限".
  4. 将此键的完全控制"权限授予Windows服务帐户 运行SQL Server
  1. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft
  2. Create a new Key called "SQL Server Cryptographic Provider" (without quotes)
  3. Right click the key, from the context menu select ‘permissions.
  4. Give Full Control permissions to this key to the Windows service account that runs SQL Server