Error Running Report in SQL Server Reporting Services

Navigation
2

The following error is occurring when you run some Reporting Services report:

  

"Error in report processing. (rsProcessingAborted)   create a connection to the 'Production' data source.   (rsErrorOpeningConnection) A network-related or instance-specific   error occurred while establishing a connection to SQL Server. The   server was not found or was not accessible. Verify that the instance   name is correct and that SQL Server is configured to allow remote   connections. (provider: Named Pipes Provider, error: 40 - Could not   open a connection to SQL Server) "

Procedures:

  • Enabled TCP / IP and Pipe Name in SQL Server settings;
  • All SQL Server services started ;
  • Remote connection allowed on bank instance;
  • Firewall and antivirus disabled on the server.
asked by anonymous 05.10.2018 / 13:36

1 answer

0

Option 1

Solving this problem is easy:

  • Go to run (Win + R)

  • Type services.msc

  • Restart MSSQLSERVER

Translated by: StackOverflow

Option 2

The first thing I would try is to get a bit more information about the error

  • This is a very general message.

You can enable erros remotos as per the error message and replicate the error. For more information.

Enable remote errors

Or check the Report Server error logs to see which error was logged.

%programfiles%\Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles\

The next step would be to connect as the data source user to the database, run any code / stored procedures that the log is using with the same parameters that you are using when running the report and see if errors occur.

Translated by: StackOverflow

Further reads: Microsoft

    
12.10.2018 / 02:02
Show NULL SQL values [duplicate] Synchronize 3 Select with Loading + JQuery / Ajax