Forum Discussion

arun_1047's avatar
arun_1047
Helper 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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I know our Network Admins installed Kerberos, but we are fairly new to the on prem PBI RS. I do have a question: it seems to be happening with one or two reports only. The reports in question are report builder reports. They have a datasource with several datasets. Within the datasets, the query shows the datasource, but the query calls another datasource also. Example: the datasource is Landing. The query calls tables from Landing and ODS. Could this be posing an "AD" double hop issue? 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I agree sounds like a double-hop issue.

 

Have your network team correctly setup SPNs to support Kerberos authentication? They will need to create SPNs  for each data source - e.g. if you have two SQL Server servers, and one SSAS server, you will need to create SPNs on the accounts running the services for each server.

  • luisrh's avatar
    luisrh
    Responsive Resident
    7 years ago

    What jcollison2001 says above is correct...