Can only connect to sql server express 2012 via named pipes
I have sql server express 2012 installed on windows 2008, locally everything works just fine i can connect via tcpip and named pipes. Remotely i can connect with ssms only using named pipes. By remote i mean within the same LAN, they are plugged into the same switch.
I have tried disabling the firewall on both sides to eliminate blocking traffic. i have toggled the tcpip setting on and off (i read somewhere that they got it working just but flipping them off and back on). I have double/triple checked all the settings that i'm aware of and everything seems to be correct.
- Tcp is enabled
- Tcp port is set to 1433, udp port is set to 1434
- Server has static ip
- Start up log says: Server is listening on [ 'any' 1433].
- Firewall rules are in place
Any suggestions on things that i can look into? i have really just run out of ideas.
EDIT: I used to have a copy of sql server 2008 installed on this box before i switched over to 2012. I uninstalled 2008 and then installed 2012 express; not sure if this changes anything but its another part of the puzzle.
EDIT #2: Here is the error message that i from a .net application that is trying to connect remotely.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The wait operation timed out.)]
EDIT #3: it looks like this is something that breaks when you install visual studio 11 or more likely .net 4.5, at least for some people; which i just did as well. Connection error after installing VS 11 And some more details
Check the TCP IP setting properties in COnfiguration Manager, the IPAll should set the dynamic to be empty and static to 1433.