troubleshooting Question

Cannot connect to MS SQL Server 2008 R2 on Win2008 Server R2 using MS SQLMS

Avatar of Marsh-Narewec
Marsh-Narewec asked on
Microsoft DevelopmentMicrosoft SQL Server.NET Programming
15 Comments1 Solution690 ViewsLast Modified:
Dear all
From my laptop I am unable to connect to the network SQL server  ( MS SQL 2008 R2, Win2008 R2 Server) using MS SQL Mgt Studio. It gives me following 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) (.Net SqlClient Data Provider)

However I am able to access my web application on the server which accesses the database on that server.

Please assist.
ASKER CERTIFIED SOLUTION
Jaime Olivares
Software Architect
Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros