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?