我遇到了类似的问题,提供程序尝试创建注册表项,但是没有创建权限,因此失败.尝试从此博客
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
打开注册表编辑器
- 导航到HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft
- 创建一个名为"SQL Server加密提供程序"的新密钥(不带引号)
- 右键单击该键,从上下文菜单中选择权限".
- 将此键的完全控制"权限授予Windows服务帐户
运行SQL Server
- Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft
- Create a new Key called "SQL Server Cryptographic Provider" (without quotes)
- Right click the key, from the context menu select ‘permissions.
- Give Full Control permissions to this key to the Windows service account that
runs SQL Server