Msg 10327, Level 14, State 1, Line 1
CREATE ASSEMBLY for assembly 'ClrSql' failed because assembly 'ClrSql' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS. The assembly is authorized when either of the following is true: the database owner (DBO) has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission.
해당 에러 발생 시 해결방법
ALTER DATABASE [데이터베이스명] SET TRUSTWORTHY ON
'컴퓨터 > SQL Server' 카테고리의 다른 글
SQL Data type VS C# Data type (0) | 2015.09.22 |
---|---|
SQL Server 형변환 (0) | 2015.09.09 |
MSSQL 계산열 (0) | 2014.12.10 |
MSSQL timestamp (0) | 2014.12.10 |
[링크]CLUSTERED INDEX와 NONCLUSTERED INDEX의 차이 (0) | 2014.12.07 |