How to Manually Enable CLR on SQL Server

  • Article

Applies To: System Center Service Manager 2010 SP1

Use the following procedure to manually enable common language runtime (CLR) on the SQL Server that hosts the restored Service Manager database.

To enable CLR

  1. On the Windows desktop, click Start, click All Programs, click Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2008, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, follow these steps:

    1. In the Server Type list, select Database Engine.

    2. In the Server Name list, select the server name for your Service Manager database.

    3. In the Authentication list, select Windows Authentication, and then click Connect.

  3. In the Microsoft SQL Server Management Studio toolbar, click New Query.

  4. Type the following in the SQLQuery pane.

    sp_configure @configname=clr_enabled, @configvalue=1

    GO

    RECONFIGURE

    GO

  5. Press F5 to execute this script.

  6. In the Messages pane, observe that Configuration option 'clr' enabled is displayed.

Did you find this information helpful? Please send your suggestions and comments about System Center Service Manager documentation to scsmdocs@microsoft.com.