DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2709869 - Last Review: November 19, 2012 - Revision: 2.0

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

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
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support