Ask the Community
Groups
Enabling CLR in SQL Server - Connect IT Community | Kaseya
<main> <article class="userContent"> <p> </p> <p><strong>Question:</strong></p> <p>How do I enable CLR in SQL Server?</p> <p> </p> <p><strong>Answer:</strong></p> <p>Run the following query inside SQL Server Management Studio (SSMS):</p> <p> EXEC sp_configure 'show advanced options' , '1';</p> <p> go</p> <p> reconfigure;</p> <p> go</p> <p> EXEC sp_configure 'clr enabled' , '1'</p> <p> go</p> <p> reconfigure;</p> <p> -- Turn advanced options back off</p> <p> EXEC sp_configure 'show advanced options' , '0';</p> <p> go</p> </article> </main>