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
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
SSRS Account -Change Account
  • So provide the location and Password.
SSRS Backup Key
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”

  1. Venkatesh Ekkaluri. Avatar
    Venkatesh Ekkaluri.

    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 Avatar
      Rajeev Pentyala

      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
  2. Nova Lodge Pattaya Agoda

    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 comment

Visitors

2,096,100 hits

Top Posts
Copilot Studio | Create an Agent and Use Adaptive CardsCopilot 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 OperationsPower Apps Code App with Dataverse: Building CRUD OperationsDecember 15, 2025Rajeev Pentyala