HOWTO: How To enable CLR on a SQL 2005 server

The Common Language Runtime (CLR) is the virtual machine component of Microsoft’s .NET initiative. It is Microsoft’s implementation of the Common Language Infrastructure (CLI) standard, which defines an execution environment for program code. The CLR runs a form of bytecode called the Common Intermediate Language (CIL, previously known as MSIL — Microsoft Intermediate Language).

Developers using the CLR write code in a language such as C# or VB.Net. At compile time, a .NET compiler converts such code into CIL code. At runtime, the CLR’s just-in-time compiler converts the CIL code into code native to the operating system. Alternatively, the CIL code can be compiled to native code in a separate step prior to runtime. This speeds up all later runs of the software as the CIL-to-native compilation is no longer necessary.

Although some other implementations of the Common Language Infrastructure run on non-Windows operating systems, Microsoft’s implementation runs only on Microsoft Windows operating systems.

The virtual machine aspect of the CLR allows programmers to ignore many details of the specific CPU that will execute the program. The CLR also provides other important services, including the following:

– Memory management
– Thread management
– Exception handling
– Garbage collection
– Security

How To enable CLR on a SQL 2005 server (Only to be done on Cloud/Dedi Servers as this is a security concern in a shared environment)

– Login to the SQL server and from the Start Menu click Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.

– Click Surface Area Configuration for Features.

– Drill down the menu on the left and select CLR Integration and click the Enable CLR Configuration checkbox.

– Click OK and you are done.