SSRS server randomly get disconnected (sql server 2016)

• casagrandi

  Old Hand

  Points: 351

  More actions

  October 9, 2023 at 9:04 am

  #4304318

  I have a problem with my SSRS server that randomly can't connect to my data source. It works all the time but sometimes I get an error in my reports that indicate that the server failed to connect.

  Any tips or leads to identify the source of this problem?

  Here is my connection string:

  Data Source=dbServer;Initial Catalog=MEGADB

  I'm using database login and password for the connection.

  The restart of the SSRS service solve my problem but it's not practical to do that every time that happens

  My error here :

  

  The SSRS service is running  in a separate machine

  Machine 1 (SSRS) >> Machine 2 (DB)

  SQL Server version: SQL Server 2016

  Thank you so much for your help

  • This topic was modified 1 year, 2 months ago by  casagrandi.
  • This topic was modified 1 year, 2 months ago by  casagrandi.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  October 9, 2023 at 10:13 am

  #4304376

  You need to get the full error message to see what the connection problem is.

  So either browse the report on the report server or enable remote errors, it will give you more information to look into as to what is causing it.