Allowing Remote Connections to SQL Server 2005 through Windows Firewall
Posted on 2015-01-19
I am trying to allow sql remote connections to SQL Express 2005.
Now if I turn off the windows firewall I can connect successfully, However when I turn on the public profile settings it stops any connection being made.
I've added UDP port 1434 and TCP port 1433 to be allowed as both incomgin and outgoing ruls on the fire wall.
However when I try to connect through VS im getting the 40 error, saying the server doesnt exist?