Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


enable clr

Posted on 2010-01-05
Medium Priority
Last Modified: 2012-05-08
I have a Database on my Local machine which have assembly and when i upload this database online assembly didn't uploaded because clr is disabled and when i try to enable clr on online serve an error message say that I don't have permission!! Is this from server owner so I contact with him or i do something error?
Question by:hazemfadl

Accepted Solution

waltersnowslinarnold earned 668 total points
ID: 26180073
I believe, you may not have proper privilage to enable the assembly. so you better avail suitable privilage to enable the same..
LVL 60

Assisted Solution

chapmandew earned 668 total points
ID: 26180251
Yes, you'll need to have your dba enable the clr.  Once that is done you should be good to go.
LVL 25

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 664 total points
ID: 26182062
You need to have permissions to change the configuration of the server with SQL Configuration Manager or with sp_configure procedure.  You have to be either sysadmin or serveradmin to make the change.  But if clr is disabled then you will not be able to create an assembly in a database.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question