locked
SSRS 2017 Issues RRS feed

  • Question

  • I get an error when trying to edit a Data Source - "Something went wrong. Please try again later"

    Here is the error in RSPortal Log

    RSPortal!reportserverwebapp!RSPortal.exe!f!11/03/2017-17:09:46:: e ERROR: OData exception occurred: System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host

    Any ideas?

    Friday, November 3, 2017 9:18 PM

All replies

  • Hi Bryan Holland,

    According to the error information, it seems the connection issue. When you add the data source, the report sever cannot visit the datasource remote host because it was "forcibly closed by the remote host". 

    So could you please check the firewall on the remote host? There might be a rule blocking the remote visit. And is there a proxy server for the remote host? And does the account have sufficient permission to connect and read the datasource? 

    You could follow Data Connections, Data Sources, and Connection Strings to set the SSRS datasource. If it is correctly set, you need to check the connection of remote host. 

    Best Regards,

    Henry 

    • Proposed as answer by Henry Jiang Wednesday, November 8, 2017 5:37 AM
    Monday, November 6, 2017 2:04 AM
  • We are getting the same error when trying to create a new datasource.

    RSPortal!reportserverwebapp!RSPortal.exe!10!04/11/2018-08:40:37:: e ERROR: OData exception occurred: System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 10.0.xx.xx:80
       at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
       at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
       --- End of inner exception stack trace ---

    Wednesday, April 11, 2018 1:44 PM