Tuesday 7 July 2015

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

No comments:

Post a Comment