Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

unsafe assembly permission was denied on object 'server' database 'master' [closed]

How do I add permissions for this:

unsafe assembly permission was denied on object 'server' database 'master'
like image 970
cdub Avatar asked Sep 14 '12 21:09

cdub


People also ask

How do I grant unsafe Assembly permission?

use master;grant unsafe assembly to [Domain\Username]; Run any programs (such as Visual Studio or any C# utilities) in Administrator mode to give them sufficient permissions to publish UNSAFE assemblies.

What is an assembly SQL?

An assembly in SQL Server is an object that references a managed application module (. dll file) that was created in the . NET Framework common language runtime. An assembly contains class metadata and managed code.


1 Answers

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

like image 82
Nic Avatar answered Oct 22 '22 09:10

Nic