Saturday, February 25, 2012

Can I Use ADOMD or AMO In ASP.NET 2.0

Hi~

I know some function can be used in debug mode,like MsgBox()...,in ASP.NET 2.0.

But I don't know that Can ADOMD or AMO be used in ASP.NET 2.0.

Could someone tell me?

thanks~

Server: SQL Server 2005

OS: Windows 2003

Yes you can use both ADOMD and AMO from ASP.NET. The main "trick" is to get the code executing as a user that has the approriate rights to access the required SSAS objects. Setting up your application pool up to run under a domain account that is in appropriate SSAS roles is one way of getting this to work.

No comments:

Post a Comment