How to activate .NET framework (CLR) integration in SQL Server 2005

Written by MoN

Under the default installation of Microsoft SQL Server 2005 you cannot run managed code in any instance. In order to be able to run managed code in an instance of Microsoft SQL Server 2005 you have to first enable the CLR integration. To do this you have two options. The first way is to use the stored procedure named sp_configure. To do this first start a client for the SQL Server (for example start the SQL Server MAnagement Studio. ) Connect to the desired server and type in the following command. sp_configure 'clr enabled' , 1; go reconfigure; go To be able to run this commands you must have the ALTER SETTINGS server permissions. This permissions are usually available to the sysadmin and serveradmin server roles. The second way to enable CLR integration in Microsoft SQL Server 2005 is to use the Surface Area Configuration tool provided by the SQL Server. To do this start the SQL Server Surface Area Configuration from the subfolder Configuration Tools from the folder Microsoft SQL Server 2005 from the Start Menu Programs. Select the Surfacea Area Configuration for Features option located at the bottom of the window. (marked with the red rectangle). In the new window select the 'CLR Integration' from the left tree. You should choose this option from the correct instance of SQL Server that is running on the local computer. After you do this you must check the 'Enable CLR integration' ceckbox from the right side of the window. Click Ok and then close the Surface Area Configuration tool. Subscribe now via RSS feed and get all the new tutorials written by Ashu , March 28, 2009 I find it uesfull. thanks ! Do you need more help? Ask now! Comment Name Email Website   Add Comment Trackback(0) Comments (1)

Last Updated ( Sunday, 16 September 2007 )