The SQL Server Reporting Services server name ERPSERVER does not exist or the Web service URL is not valid

When I deploying the reports in reporting services I got some issue after finishing the restoring the database. After some analysis i got the solution for that, if anyone is getting this type of error you can follow this steps to reduce your time to analyzing on it.

The SQL Server Reporting Services server name ERPSERVER does not exist or the Web service URL is not valid

Reason:
Your web service URL is not properly mapped in the Business intelligence >> Report services so that you are getting this type of error message

Solution:
Search the Reporting services configuration manager, you can see the screen like which I shared in below.,


Go to Report Manager URL and copy the link and save it to the AX report services and past it into 1st place (Report Manager URL)

The SQL Server Reporting Services server name ERPSERVER does not exist or the Web service URL is not valid

The SQL Server Reporting Services server name ERPSERVER does not exist or the Web service URL is not valid

Then go to web services URL copy the marked place which I mentioned below screen and past it into 2nd place (Web service URL)

The SQL Server Reporting Services server name ERPSERVER does not exist or the Web service URL is not valid


After finishing click the validate settings, now you are ready to access the database like this you will get an Infolog message.

Now you are ready to make the next process.

1 comment:

  1. hello , i am facing the above issue, but even with your steps it is not working , any other idea?

    ReplyDelete