Forum Discussion
Getting error in Report Server while selecting an option "As User Viewing the report"
Hello, I have built a report using Direct Query(SQL Server) . While deploying report in Report server, i have used an option "As User Viewing the report" instead of providing the default credentia...
Thanks for your reply.
The link which you shared provide details on "how to configure SPNs for Analysis service". Can you help me out how to do the same for the SQL server Database? We are using SQL direct Query .
Sure... follow the same steps as with analysis services but swap "MSOLAPSvc.3" with "MSSQLSvc".
Then remember to set delegation on the Report Server account for MSSQLSvc as well.
More details on setting SPNs for SQL Server here: https://technet.microsoft.com/en-gb/library/bb735885.aspx