SQL SERVER CONNECTION FAILED
Hi all when i am navigate into reportserver url i got below error ...... 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) what is the reason for that and what is the solution ................Yashwant Singh Mourya.
June 21st, 2011 1:16am

Hi YASHWANT, Thanks for your question. Based on my research and experience, the issue of Named Pipes Provider, error: 40 - Could not open a connection to SQL Server may be caused by the below five reasons: 1. Incorrect connection string, such as using SqlExpress. 2. Named Pipes(NP) was not enabled on the SQL instance. 3. Remote connection was not enabled. 4. Server not started, or point to not a real server in your connection string. 5. Other reasons such as incorrect security context. The detail solutions of the previous reasons, I would recommend you see this similar thread had handled by the other partner: http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/2a8f2e64-74cf-46f2-b2be-bbb08b1502cb. If your issue still exsits, please feel free to let me know. Thanks, Sharp Wang Best Regards. Sharp Wang
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2011 9:59am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics