Dinu Anastasiu
Member
- Joined
- Jun 8, 2006
- Messages
- 6
- Programming Experience
- 10+
I have developed in a User Defined Function in ADO.NET 2.0.
When I tried to deploy it I got the following message (Visual Studio):
“CREATE ASSEMBLY for assembly 'SqlUDFDirectoryListing' failed because assembly 'SqlUDFDirectoryListing' 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.”
I tried:
Thank you very much for your help,
Dinu
When I tried to deploy it I got the following message (Visual Studio):
“CREATE ASSEMBLY for assembly 'SqlUDFDirectoryListing' failed because assembly 'SqlUDFDirectoryListing' 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.”
I tried:
- <LI class=MsoNormal style="MARGIN: 0cm 0cm 6pt; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt">Grant the EXTERNAL ACCESS ASSEMBLY permission to dbo. I couldn’t find this permission in the permission list
- Set the TRUSTWORTHY database property to ON. This property is greyed out.
Thank you very much for your help,
Dinu