How do I add permissions for this:
unsafe assembly permission was denied on object 'server' database 'master'
-
5This question is one I had. Glad to find the answer below, whether the question was "closed" or not.– OliverCommented Mar 6, 2013 at 14:40
Add a comment
|
1 Answer
Check and confirm that the account you are using to create the assembly is a sysadmin on that particular SQL instance. You must be a sysadmin to install unsafe assemblies per MSDN
-
1Though the MSDN docs suggest you do, you do NOT have to be a sysadmin. The user in question needs the "UNSAFE ASSEMBLY" permission which can be granted to any login (SS login or Windows auth) through SSMS or T-SQL. Commented Oct 28, 2019 at 16:13