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:
Propriétés

ID d'article : 2709869 - Dernière mise à jour : 19 nov. 2012 - Révision : 1

Commentaires