Error executing report in SQL Server Reporting Services

Asked

Viewed 873 times

2

The following error is occurring while running a Reporting Services report:

"Report processing error. (rsProcessingAborted) Not possible to create a connection to the data source 'Production'. (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. (Previous: Named Pipes Provider, error: 40 - Could not open a Connection to SQL Server)"

Procedures performed:

  • TCP/IP and Pipe Name enabled in SQL Server settings;
  • All SQL Server Services starships;
  • Allowed remote connection in the bank instance;
  • Firewall and antivirus disabled on server.
sql sql-server reporting-services

  • I hope this helps: named-Pipes-Provider-error-40

  • Caiodepaulasilva, had already performed all these steps.

  • Does the error happen with any report or with any specific report? Did this report work before or always gave this error? The error happens when the report is triggered from a specific machine or from any one?

1 answer

0

Option 1

Solving this problem is easy:

  • Go to the run (Win+R)

  • Typo services.msc

  • Restart the MSSQLSERVER

Translated from : Stackoverflow

Option 2

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

  • This message is very generic.

You can activate erros remotos according to 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 registered.

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

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

Translated from : Stackoverflow

Other readings: Microsoft

Browser other questions tagged sql sql-server reporting-services

You are not signed in. Login or sign up in order to post.