Upgrade Adviser 2014 Errors and Warnings for CLR

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  April 17, 2015 at 9:31 am

  #317527

  Listed below is a sample of the warnings and errors that I get when I run the Upgrade Adviser on a Server.

  What actions need to be taken?

  Database Engine:

  Error: User defined CLR objects have been detected. These objects may function differently in CLR version 4.0 when the database compatibility is raised to 110.

  Database: ContractsDEV

  CLR object name: PropertyDecrypt

  Type description: CLR_SCALAR_FUNCTION

  Create date: 7/22/2013 8:30:10 AM

  Assembly name: CSSSQLEncrypt

  Database: ContractsDEV

  CLR object name: PropertyEncrypt

  Type description: CLR_SCALAR_FUNCTION

  Create date: 7/22/2013 8:30:10 AM

  Assembly name: CSSSQLEncrypt

  Intergrated Services:

  Warning: Update provider names in connection strings to be compatible with SQL Server 2014

  Database: ContractsDEV

  CLR object name: PropertyDecrypt

  Type description: CLR_SCALAR_FUNCTION

  Create date: 7/22/2013 8:30:10 AM

  Assembly name: CSSSQLEncrypt

  Database: ContractsDEV

  CLR object name: PropertyEncrypt

  Type description: CLR_SCALAR_FUNCTION

  Create date: 7/22/2013 8:30:10 AM

  Assembly name: CSSSQLEncrypt

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• harshapulletikurti

  Valued Member

  Points: 51

  More actions

  October 12, 2015 at 4:45 am

  #1832775

  Were you able to find a work around to this issue?

  I also have encountered a similar error while i was planning to upgrade from Sql 2008 to Sql 2012. Any help is appreciated.

  -Harsha