SQL SERVER 消息 10343，消息 15151 解决办法

铁来方

已于 2024-12-09 16:00:41 修改

阅读量305

点赞数 1

文章标签： sql 数据库

于 2024-12-09 15:59:50 首次发布

本文链接：https://blog.youkuaiyun.com/qq_26864945/article/details/144350530

版权

消息 10343，级别 14，状态 1，第 5 行
CREATE or ALTER ASSEMBLY for assembly '*******' with the SAFE or EXTERNAL_ACCESS option failed because the 'clr strict security' option of sp_configure is set to 1. Microsoft recommends that you sign the assembly with a certificate or asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly.
消息 15151，级别 16，状态 1，第 10 行
Cannot alter the assembly '*******', because it does not exist or you do not have permission.

解决办法：

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;

EXEC sp_configure 'clr strict security', 0;
RECONFIGURE;

再执行，创建你的 “程序集”

再创建你的“标识量函数”

再最后，启用 CLR

 exec sp_configure 'show advanced options', '1';
go
reconfigure;
go
exec sp_configure 'clr enabled', '1'
go
reconfigure;
exec sp_configure 'show advanced options', '1';
go