Thursday, November 13, 2014

Failed to retrieve RS configuration information: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException

This is the issue where you configure report server in SharePoint integrated mode and runs fine opening the web service url which shows that reports are configured properly. But you get into an issue when you try to use the web service url in CA and report server configuration settings.

1) Open Central admin adn go to general settings- report server configuration
2) Open the settings and add the web service url to the page and choose the trusted account (should be the same taht you user while configuring report server on Sql side) and click OK. It takes a while and then thorw the error "Failed to retrieve RS configuration information: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException"

To fix this, in our case it was related to our sql server side where port 80 was blocked and thats why SP was not able to make connection to the sql side.

Go to Sql server and open configuration manager- under report web service url- change the url to port 8080 or whatever you want and reconfigure again.Then once done, use that url and go back to CA and it should work

How you can check whether port is blocked. Use Telent client feature on your server
Open cmd and type:-
Telnet "ServerName" port

If it gets black out, it means port is open if not then its blocked and you will see a message.

No comments:

Post a Comment