SQL Server Reporting Services Account is a local user and is not supported

Today when I was installing SrsDataConnector after installing CRM got the following error.

“SQL Server Reporting Services Account is a local user and is not supported”


A quick search gave me the reason of the error and also the solution to resolve it.

Reason — Whenever we install SQL Server Reporting Services using default settings, the service account will be set to ReportServer. And we cannot install SrsDataConnector with Report Server account.
 

  • Search and Open the Reporting Services Configuration Manager
  • Update the Use built-in account to “Local System”
  • While updating Service Account, system asks you “Backup Encryption Key” with below screen.
  • Close the “SrsDataConnector” installation wizard and Start again. This time you won’t see any issue.

 Hope this helps.
 

Happy CRM’ing
Gopinath

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s