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