Was this page helpful?

SQL Services Internal

    Use another account for report server

    By default, "SQL Server Reporting Services" works with the account "LocalSystem". This account can be replaced by a domain account.
    Start the Reporting Services Configuration tool and connect to the report server instance.

    Go to Encryption Keys, and make a backup of your actual key.
    On the Service account page, enter the domain account and password.
     

    PrtScr capture_3.jpg

    Save the encryption key, and select "current user - integrity security" in the SQL server Connection Dialog window.

    Click on apply.

    Restart the SQL Server Reporting Services (NEWTEST) service

    Open a command window (cmd) as an administrator and execute this command : C:\Newtest\Tools>WebConfigurationTool.exe /nrs

    The configuration manager add the domain user account to the Windows group SQLServerReportServerUser $ SERVER_NAME $ MSRS10_50.NEWTEST.

    You need to add this account in SQL Managment Studio in the security section

    PrtScr capture_4.jpg

     

    master:public,RSExecRole
    msdb:public,RSExecRole,SQLAgentOperatorRole,SQLAgentReaderRole,SQLAgentUserRole
    ReportServer$NEWTEST:db_owner,public,RSExecRole
    ReportServer$NEWTESTTempDB:db_owner,public,RSExecRole
    NewtestReporting:db_owner,public

     

    PrtScr capture_5.jpg

    Permission to connect to database engine: Grant
    Login: Enabled

    PrtScr capture_6.jpg

    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Page statistics
    2023 view(s), 5 edit(s) and 2306 character(s)

    Comments

    You must login to post a comment.