Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Client - IIS - Analysis Services

Author  Topic 

jojo_jacob
Starting Member

24 Posts

Posted - 2005-04-06 : 06:58:22
Scenario: I have a web application which uses DSO to retrieve some data from the Analysis Services. We use a .NET architecture and the ASP page connects to the Analysis Services. The front end application uses windows authentication to show the pages.

Objective: To connect to the Analysis Services using the original user authentication. The domain users are placed in cube roles and are restricted from accessing few dimensions and/or cubes. How do I make the ASP page pass the user credentials of the Domain User who has originally logged into the front end application?

Solution: Pls let me know any ideas to achieve this.

Thanks very much

Jojo
   

- Advertisement -