Error message

Hi,

I keep getting this error message while creating and deploying my report. I already restart the SQL server services(MSSQLServer) a lot of times, it is still the same.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'AdventureWorks'. (rsErrorOpeningConnection)

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I also got another error message while deploying my report.

The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)

Anybody knows how to solve this?

For the first error, try enabling named pipe for SQL server. Make sure you restart RS service after restarting SQL service.|||

I already tried that. Sometimes it works, but after a few minutes, it give me back the same error message or this:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)|||

Oh ... You need to fix "Initialization" first. I am surprised it worked for you at all. However, the error message doesn't make sense to me. Can you try resetting database connection from the config tool? Make sure every tab is green.

Perhaps the easiest solution is to reinstall RS.