When
we will deploy a CLR objects like CLR stored procedures, CLR data types etc we
may get error message like:
Deploy error SQL01268: .Net SqlClient Data Provider: Msg 10327,
Level 14, State 1, Line 1 CREATE ASSEMBLY for assembly '' failed because
assembly '' 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.
Solution:
ALTER DATABASE SampleDB SET
TRUSTWORTHY ON
EXEC dbo.sp_changedbowner @loginame = N'sa', @map = false
Note: Replace the SampleDB by
your database name.
No comments:
Post a Comment