Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

SQL Server Reporting Services Account is a local user and is not supported – Error installing SrsDataConnector

Published by

Rajeev Pentyala

on

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 — 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.

🙂

Advertisements

Advertisements

3 responses to “SQL Server Reporting Services Account is a local user and is not supported – Error installing SrsDataConnector”

Venkatesh Ekkaluri.

June 24, 2015

Hello Rajeev,
I have a requirement like ,when a new e-mail comes in to the crm-mail box(ex. support@mycompany.com), I have to check whether an Account is existed or not for the sender mail id. How can i achive this one.. can u please give a response asap..
Thanks in Advance
Venkatesh Ekkaluri.
venkatesh.e108@gmail.com

Reply
1. Rajeev Pentyala
  
  June 25, 2015
  
  Hi,
  When Sync Email it creates a record in CRM, if i understand your requirement correctly you need to check you business logic before the record gets created in CRM.
  You can register a Plug-in on Create message with Stage Pre-operation and throw exception after you Business Logic check to prevent creation.
  
  Reply
Nova Lodge Pattaya Agoda

March 10, 2017

Nova Lodge Pattaya Agoda

SQL Server Reporting Services Account is a local user and is not supported – Error installing SrsDataConnector | Rajeev Pentyala – Dynamics CRM Blog

Reply

Leave a reply to Nova Lodge Pattaya Agoda Cancel reply

Visitors

2,096,142 hits

Top Posts

Copilot Studio | Create an Agent and Use Adaptive Cards

Copilot Studio | Create an Agent and Use Adaptive CardsJuly 15, 2025Rajeev Pentyala

[Step by Step] Beginner : Create a PCF control and add it to a custom page

[Step by Step] Beginner : Create a PCF control and add it to a custom pageDecember 2, 2024Rajeev Pentyala

Power Apps Code App with Dataverse: Building CRUD Operations

Power Apps Code App with Dataverse: Building CRUD OperationsDecember 15, 2025Rajeev Pentyala