7 Replies Latest reply on Sep 8, 2009 12:41 PM by John.Taylor

SQL Server System Common Language Runtime (CLR)

thurgoodj187 Jun 11, 2009 3:07 PM

I am in the process of planning an upgrade from 9.1 to 9.5 and got stopped with the following error:

SolarWinds Orion Network Performance Monito 9.5 SL20000 requieres the SQL Common Languate Runtime (CLR) Integration, bt is not currrently enabled for the SQL server used by Orion NPM. The Database user for Orion NPM does not have sufficient rights to enable this integration, but the orion configuration can enable the entegration automatically if the SysAdmin server roles are provided. Enabling the SQL Server CLR Integration requires a restart of the SQL Server used by Orion NPM.

Does this get installed on the SQL server or the Solarwinds server? Our current configuration uses an enerprise MS 2005 SQL server cluster. Would all cluster nodes have to have this installed?

Re: SQL Server System Common Language Runtime (CLR)

qle Jun 11, 2009 6:54 PM (in response to thurgoodj187)

See if the following knowledge base article helps:
How do I enable CLR Integration for SQL Server 2005?
Like Show 0 Likes(0)

Actions
- Re: SQL Server System Common Language Runtime (CLR)
  
  tkelly Jul 15, 2009 4:14 PM (in response to qle)
  
  I have a follow-up post to this. Is it in an official document somewhere stating that CLR is required. We run our system on a consilidated Enterprise SQL server also and our DBAs have intentionally not installed CLR and are fighting the installation of CLR. At this point I'm stuck where I can't upgrade. I'm hoping maybe the document will go into why it's required and what benefits we will see from it.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: SQL Server System Common Language Runtime (CLR)
    
    Andy McBride Jul 15, 2009 4:36 PM (in response to tkelly)
    
    The Orion NPM Administrators Guide calls out the requirement in the System Requirements section.
    http://www.solarwinds.com/support/orion/orionDoc.aspx
    There are a number of references out on the web regarding the benefits, but they all are written in DBA talk. For Orion, CLR allows for improved performance.
    Andy
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: SQL Server System Common Language Runtime (CLR)
      
      Debbi Sep 8, 2009 10:34 AM (in response to Andy McBride)
      
      In the release notes for 9.5 it says: If SQL Server System Common Language Runtime (CLR) Types are not already installed, Orion NPM will install them.
      I upgraded but did not get any error message, and here I have been running on 9.5 for several weeks not knowing that CLR is not enabled. It was only when I tried to edit custom properties that I had a problem! I am scheduled to enable CLR on Thursday AM and was told to run the Wizard after the SQL server reboot. I hope that will be sufficient and I will not have to reinstall. What else in 9.5 relies on CLR that may be broken and I just have not noticed???
      Debbi
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: SQL Server System Common Language Runtime (CLR)
        
        John.Taylor Sep 8, 2009 11:03 AM (in response to Debbi)
        
        CLR is also used by the config wizard to setup a couple of database maintenance scripts for wireless, energywise, and Netflow's CBQoS. If these scripts are not correctly generated and you use any of these features, then your database tables will grow very large very quickly.
        John Taylor
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: SQL Server System Common Language Runtime (CLR)
        
        Debbi Sep 8, 2009 12:15 PM (in response to John.Taylor)
        
        Thanks. I hope running the wizard will be sufficient, and I will not have to reinstall.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: SQL Server System Common Language Runtime (CLR)
        
        John.Taylor Sep 8, 2009 12:41 PM (in response to Debbi)
        
        I believe that it will be
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post