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

If you want to verify that SPNs are set on an account you can run the following command to list them (I don't think you need any special domain privileges to run this but I'm not 100% sure - sorry!).

setspn –L DOMAIN\ACCOUNT

Swap "DOMAIN\ACCOUNT" for the account that's running your back end service (e.g. SQL Server/SSAS), which the SPNs should be created on.

 

To create an SPN (for which you will need a certain level of domain privileges) run:

setspn –A SERVICE/SERVER:PORT DOMAIN/ACCOUNT

Here, SERVICE is specific to the service in operation, SERVER:PORT is the server hosting the service, and DOMAIN/ACCOUNT is the account running the service.

 

Here's an example for SQL Server:

setspn –A MSSQLSvc/MYSERVER:1433 MY_DOMAIN\SQL_ACCOUNT

Here's an example for SSAS:

setspn –A MSOLAPSvc.3/MYSERVER MY_DOMAIN\SQL_ACCOUNT

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Replace the emoticons with colon + P!!!