Can I add Microsoft.AnalysisServices assembly into SQL CLR stored proc

Hot Topic

Xml serialization--strange character in output
How to install SQL Server Express as a ClickOnce prerequisite?
Append text to textbox without scrolling
Managing connection strings across projects
Thoughts, Opinions, and Experiences of the Enterprise Library under .NET 2.0?
Help: new to Data access stuff
Making VB.net 2003 SqlDataAdapter work
Add datacolumn to the datatable at a specified index
Error calling asp.net window from asp application
datatable adapter does not generate insert and update statements for queries with join

.NET Development

Socket Recive Problem
document.getElementById().innerHTML fails with 'Unknown Error' in IE
C3767 error with regex
ComException when running web service
Bug with NullableConverter ?
getting the client url from web services
Suggest Collection
Searches IN vb.net and access
Create virtual com port in C#?
Set generic collection? (Java HashSet)

Can I add Microsoft.AnalysisServices assembly into SQL CLR stored proc

My general problem is that I want to make a runtime component that:

  • will sit on the SQL Server machine
  • will be called with a large xml parameter, then use AMO to define and process a new AS database
  • Can be invoked from a non windows machine using jdbc or web services. Preferably jdbc.

I made a CLR C# SQL stored procedure that references the Microsoft.AnalysisServices assembly (adding the reference to the project file using a text edtor)

Problem is that when I try to add the Microsoft.AnalysisServices assembly to an SQL server database I get this error.

CREATE ASSEMBLY failed because method "add_CollectionChanging" on type "Microsoft.AnalysisServices.ModelComponentCollection" in safe assembly "Microsoft.AnalysisServices" has a synchronized attribute. Explicit synchronization is not allowed in safe assemblies.

I'm a novice with CLR. Am I trying to do something stupid Is there an easily solution

thanks in Advance

Zub

Answer this question

Can I add Microsoft.AnalysisServices assembly into SQL CLR stored proc

  • SqlShaun

    I would write a component that does the job (maybe also using stored procedures) and then host it in IIS as a web service and in any other context you need it.

  • TootPeep

    I don't know much about AS, but consider remoting (the HttpChannel) or directly System.Net.HttpListener. Of course you could also use the database or a file to talk with the non-Windows machine.

  • Bluesky_Jon

    I'm trying to avoid a dependency on IIS.

    I aslo need to trigger this from a non windows machine using java.

    Another approach is to write an AS CLR Assembly and then call it using MDX via XMLA. Trouble is it seems that you need the AS Data pump installed in IIS to use XMLA. I'm trying to figure out how to use the the same channel that MS does for XMLA.

  • mazen44

    Thanks

    I am now aware of the PERMISSION_SET option. UNSAFE is not recommended and is actually quite difficult to achieve with the AnalysisServices assembly. I guess this is saying I should not do it - right

    Zub

  • Pierre-Yves Troel

    You would have to change the permission set of the assembly. Search in MSDN for "CREATE ASSEMBLY".
  • Can I add Microsoft.AnalysisServices assembly into SQL CLR stored proc
Answer this question