Analysis services + IIS can they be seperated

[Sunny]

I have developed a web application that uses owc 10 Pivot table control. My
analysis services is on server A, and i deploy my web application on server B
i.e. my iis is on machine B. I am not able to get Pivottable.ActiveView
object in this scenario. Now if i have my analysis services and my web server
both on one machine then there is no problem.
So is it necessary that we have our analysis services and IIS on same machine?
Or Is there any workaround??

Note: I need activeview object just to make costomized view of pivottable
control. So that by default i show some rowaxis, column axis and data axis
filled along with different color schema.

 

[Alvin Bruney - ASP.NET MVP]

This is a permissions problem, you need to make sure your machine and
services are configured correctly. You should be able to find more
documentation about this on MSDN or on the office website.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[Sunny]

Thanks alot for replying dude! But i got the reply from Pat. We can use http
connection for that. The reply is in servers->sql server->olap.

This is a permissions problem, you need to make sure your machine and
services are configured correctly. You should be able to find more
documentation about this on MSDN or on the office website.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

I have developed a web application that uses owc 10 Pivot table control. My
analysis services is on server A, and i deploy my web application on server B
i.e. my iis is on machine B. I am not able to get Pivottable.ActiveView
object in this scenario. Now if i have my analysis services and my web server
both on one machine then there is no problem.
So is it necessary that we have our analysis services and IIS on same machine?
Or Is there any workaround??

Note: I need activeview object just to make costomized view of pivottable
control. So that by default i show some rowaxis, column axis and data axis
filled along with different color schema.