Rajeev Pentyala – Microsoft Power Platform

I was getting below error while setting up SrsDataConnector

SSRS Account is a local user

Reason

• If the SQL Server Reporting Service installed using default settings, then the service account will be set to “ReportServer” and we cannot install SRSDataConnector while SSRS service running under ‘ReportServer’ account.

SSRS Account – ReportServer

Fix

Update the Service Account from “ReportServer” to some other Account by following below steps.

• Open the Reporting Services Configuration Manager
• Update the Service Account to something else such as “Local System”
• While applying Account change it will ask you “Backup Encryption Key” with below screen

SSRS Account -Change Account

• So provide the location and Password.

SSRS Backup Key

• Close the “SrsDataConnector” installation wizard
• Start the installation again.

🙂