Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


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.

↑ Back to the top


More Information

For more information about the issue that is described in the "Symptoms" section, visit the following Microsoft website:

↑ Back to the top


Keywords: kbtshoot, kbsurveynew, kbentirenet, kbprb, kb

↑ Back to the top

Article Info
Article ID : 2709869
Revision : 1
Created on : 1/7/2017
Published on : 11/19/2012
Exists online : False
Views : 989