Unable to complete install of HRS.  Error 503 Service Unavailable when attempting to provision reports.

Version 1


    Customer is unable to install HRS on a new SQL server deployment.
    SSRS was freshly installed is verified to be working prior to running the HRS installer, but after the installer runs and SCW loads the report manager URL starts throwing this error:
    "The permissions granted to user are insufficient for performing this operatíon. (rsAccessDenied)"

    After we proceed through the SCW and hit next on the SQL Reporting page we get
    "An exception occurred while executing a Transact-SQL statement or batch"

    Then the customer gets error 503 Service Unavailable on the report manager URL and also when attempting to provision the reports.



    This was caused by insufficient permissions

    -Enable SecurityAdmin role for the database user in SQL (per page 32 of the install guide)
    -Since the installer and SCW had been run without this properly set it is necessary to uninstall/reinstall SSRS.
    -With a fresh installation of SSRS and the correct SQL permissions the HRS installation was completed successfully.