1
votes

I want to create web service with forms authentication in SSRS and then use it to view reports retrieving data from SSAS cube. Is it possible to, after successfull logon, pass identical user's forms authentication credentials, to SSAS server so with one credentials user is authenticated in two servers? If yes, how I can achieve this task?

I'm using SQL Server 2012.

1

1 Answers

1
votes

No, because SSAS doesn't alow any form of autentication other than windows authentication. You can definetly connect to SSRS using forms (and by forms I mean a SQL Server user) but then, from SSRS on, you must use a AD user on your SSRS data source to connect to SSAS.