troubleshooting Question

Error when connecting to sql server 2008 r2 via ODBC or Visual Studio

Avatar of dzirkelb
dzirkelbFlag for United States of America asked on
.NET ProgrammingMicrosoft SQL Server 2008
4 Comments1 Solution1155 ViewsLast Modified:
I am trying to connect to a fresh install sql server 2008 via ODBC from windows 7 and visual studio, both reject the connection.

The error I get is:

provider: named pipes provider, error: 40 - could not open a conection to sql server

There is more to it, but that is the general error.

I also am not able to connect to the server via ODBC.  The server is recognized as I can select it from my drop down, I just can't connect to it.  The error states the server does not exist or access is denied.

I have enabled TCP connection and remote connections on the sql server.  I have opened up port 1433 for outbound and inbound connections on the server, and on my windows 7 machine.  I am connecting using Windows Authentication and I am a domain admin.

Any ideas on what to do next?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 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 4 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