Home
> CRM, SQL, SSRS > SQL Server Reporting Services Account is a local user and is not supported – Error installing SrsDataConnector
SQL Server Reporting Services Account is a local user and is not supported – Error installing SrsDataConnector
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.
🙂
Categories: CRM, SQL, SSRS
Account is a local user, SrsDataConnector, SSRS Backup Key
Rajeev Pentyala - Microsoft Power Platform 
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
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.