We currently are using SQL Server Analysis services as the back end and using Telerik for WPF to display various Pivot Tables from the SQL Server cubes. We provide Telerik control with a Connection settings object via the AdomdDataProvider class to provide connection information as follows
"Provider=MSOLAP.5;User Id=genericuserid;Password=[password];Data Source=[servername];Initial Catalog=[cubename]Timeout=360
The issue we are having is that we are finding that unless that actual Windows domain user (i.e. the person logged in) has access (via a role defined in the SQL Server cube) then they are refused access even if the user id in the connection string (in this example 'genericuserid') does have full admin privileges, In other words it seems that SQL Server for the purposes of getting at the CUBE data is ignoring the user id passed in the connection string and always using the domain user id.
Is there anyway I can force SQL Server to use the 'genericuserid' so I do not have to explicitly give users access via a role.
Thanks