Saturday, 30 January 2016

Report server error rsServerConfigurationError ax 2012 ssrs report / SQL server 2014

Hello ,

Today I ran a ssrs report and got the below error.

Error while setting server report parameters. Error message: The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)

Reason could be that the execution account doesn't have proper access to DB server. In case if you want this to be the desired setting, then In Report Manager Site, select the Credentials are not required option.
Otherwise you can provide proper access to execution account on your db server.

Solution:
Go To > Report Services Configuration Manager > Connect to report services
Now select Service Acount tab and check the Credentials. And Set the right username and password.

Do the same thing with Execution Account then click on apply and Exit.


Now run the same report I will work. 
Thanks.

No comments:

Post a Comment