Hello, I am getting the following when trying to view report using the web interface: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'AdventureWorks'. (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) Any help is greatly appreciated. Thank you, Salim

Have You Configured the Datasource which has the correct credentials to access the database ?Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Hi Salim71, Thanks for your question and Rakesh’s reply. This error is returned by the instance of the Database Engine that hosts the report server database. In most cases, this error occurs because the SQL Server service is stopped. Or, if you are using SQL Server Express with Advanced Services or a named instance, this error will occur if the report server URL or connection string for the report server database is not correct. To work through these issues, please refer to the resolution in this MSDN article: Troubleshooting Server and Database Connection Problems. Thanks, Sharp Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Hi salim, http://blog.sqlauthority.com/2007/04/23/sql-server-fix-error-40-could-not-open-a-connection-to-sql-server/ Hope the above link is helpful to you. Thanks, Madhava