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

Article translations Article translations
Article ID: 2709869 - View products that this article applies to.
Expand all | Collapse all

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:
https://connect.microsoft.com/SQLServer/feedback/details/698559/cannot-deploy-an-assembly-to-a-multidimensional-instance-from-ctp3

Properties

Article ID: 2709869 - Last Review: November 19, 2012 - Revision: 2.0
Applies to
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • SQL Server 2012 Enterprise Core
Keywords: 
kbtshoot kbsurveynew kbprb KB2709869

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com