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

View products that this article applies to.

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()

↑ Back to the top

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.

↑ Back to the top