Friday, February 24, 2012

How to impersonate known user to AS 2000

I am developing an application in C# 2.0 that will access a AS 2000 cube. I want the application to access the cube with a known account. I do not want to use XMLA.

My ConnectionString looks like this:

Data Source=MyServer; Catalog=GL; User ID=ReportUser; Password=mypass

My code looks like this:

AdomdConnection Connection = new AdomdConnection(ConnectionString);
Connection.Open();

ReportUser is a local account on the server. The cube has a single role where ReportUser is a member.

When trying to open the connection I get an exception that the connection was actively refused by the server.

Help?

Thanks

Sorry - you can't do that unless you set up http authentication and use basic auth for your virtual directory. (please use https)

And that takes Enterprise edition in 2000 (but standard in 2005!).

No comments:

Post a Comment