You are currently offline, waiting for your internet to reconnect

Error message when you try to deploy an assembly in SQL Server 2012: "Clr Assembly must have main file specified"

Symptoms

When you try to deploy an assembly to a Microsoft SQL Server 2012 Analysis Services instance by using Microsoft SQL Server Management Studio 2012, you receive an error message that resembles the following:
Clr Assembly must have main file specified.
(Microsoft.AnalysisServices)
------------------------------
Program Location:

at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Create(IMajorObject parent, IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowOverwrite, XmlaWarningCollection warnings)
at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode)
at Microsoft.AnalysisServices.ManagementDialogs.OlapRegisterClr.SendDataToServer()
Cause
This issue occurs if the following conditions are true:
  • The assembly uses a version of Msmgdsrv.dll.
  • The version of Msmgdsrv.dll was compiled by using a version of the Microsoft .NET Framework that is earlier than the Microsoft .NET Framework 4.
Note This is by design.
Resolution
To resolve this issue, follow these steps:
  1. Recompile the assembly by targeting the .NET Framework 4.0 runtime.
  2. Deploy the assembly by using SQL Server Management Studio 2012.
More information
For more information about the issue that is described in the "Symptoms" section, visit the following Microsoft website:
Properties

Article ID: 2709869 - Last Review: 11/19/2012 18:04:00 - Revision: 2.0

  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • SQL Server 2012 Enterprise Core
  • kbtshoot kbsurveynew kbprb KB2709869
Feedback