All shared datasources connecting to external databases are currently hanging in our production sharePoint farm. However, there's no problem to ping the host servers of those databases from the reporting server, and I can connect to those databases
as well if I build up the connection in the report builder. There seem to be something messed up within SharePoint configuration.
I've already tried restarting the reporting services and the server itself, but I'm still having the same issue. Anyone can help me with this one?
What's the crendential of the connection you specify for the shared data source? Stored credentials are recommended as part of a strategy for accessing remote database servers. Please try to specify the data source connection with "Credentials
stored securely in the report server ".