본문 바로가기

컴퓨터/SQL Server

MSSQL Msg 10327 해결방법


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


출처 : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b27e8e16-2d84-4eec-a87d-df53b2e298bc/create-assembly-failed-not-authorized-for-permissionset-externalaccess?forum=sqlsecurity

'컴퓨터 > 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