Unable to Add Service Reference in a 2012 CLR database project

• Shon Thompson

  SSC-Addicted

  Points: 474

  More actions

  April 17, 2014 at 3:56 pm

  #287694

  I created a CLR procedure with a service reference in Visual Studio 2010 that is being used in SQL Server 2008 R2. We recently tried to deploy it to a 2012 SQL Server, but were unable to due to compatibility issues. When I tried to upgrade the package to Visual Studio 2013 I got this error message:

  Unable to cast object of type 'Microsoft.VisualStudio.Data.Tools.Package.Project.DatabaseFileNode' to type 'Microsoft.VisualStudio.Data.Tools.Package.Project.Internal.FolderNode'

  I tried to create this using the 2012 Data Tools, but was unable to add a service reference with the GUI. It appears Microsoft has removed this functionality. My company has a third party app that we have limited control over, which is why we need this functionality. I'm wondering if anyone knows a workaround for this other than creating a custom class library for these CLRs that were previously working as suggested in this thread:

  http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c086b200-e0cf-4407-a1da-42b7ab38be1f/how-add-web-reference-to-ssdt-project?forum=ssdt&prof=required