Forum Discussion

arun_1047's avatar
arun_1047
Icon for Helper I rankHelper I
8 years ago

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...
Report Server
arun_1047's avatar
arun_1047
Icon for Helper I rankHelper I
8 years ago

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 .

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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