Posted on
An error occurred while attempting to retrieve the list of local SharePoint sites configured with Reporting Services.

Yesterday When I tried to Install the Reporting Extension I faced this error.

Error:

An error occurred while attempting to retrieve the list of local SharePoint sites configured with Reporting Services.

AX: Microsoft Dynamics AX 2012 R3 CU8
OS: Microsoft Windows Server 2012 R2
SQL: Microsoft SQL Server 2014
SP: Microsoft SharePoint Server 2013

Solution:

Well, the first thing I checked was the event viewer, there was an access related issue with DB.

I opened the SSMS, Checked the service account, gave it sysadmin access and bingo! 🙂

Happy DAXing! 

Thanks & Regards,
Mail ID: pandit.umesh@hotmail.com
Skype ID: pandit.umesh

One Reply to “an error occurred while attempting to retrieve the list of local SharePoint sites configured with reporting services.”

Leave a Reply

Your email address will not be published. Required fields are marked *