I need to create a SQL server CLR object. I can't create this because by default SQL server has 'enable CLR' disabled in SP_CONFIGURE. When I try to turn this on by running the following code, I get an error saying I don't have the permissions to change this.
EXEC sp_configure 'show advanced options' , '1';
reconfigure;
GO
EXEC sp_configure 'clr enabled' , '1' ;
reconfigure;
GO
From what I have read, the login for the user running this code needs to have serveradmin or sysadmin privileges. Of the system admin has to grant the user in question 'Alter settings' by running the following code:
USE Master
GO
GRANT ALTER SETTINGS TO <yourUserName>
GO
My question is how can I turn on this CLR option? I can turn it on on our local server because I can log in as the sysadmin. But I am trying to figure this out on our Cloud server which is on hosted on cloud space. Logging on to our hosted database server there are nearly 100 different databases of other companies like ours. That means I can't get admin access. How would I go about changing this setting, and is there a way to make it only apply to a single database, or will enabling it from the admin side allow all of the other database users to create CLR objects?