SQL server only visible when firewall rule set to public
Posted: Wed Apr 06, 2011 12:05 pm
Hi all,
I have connected my server and computer via an OpenVPN. I have installed SQL server 2008 R2 express on the server and disabled the firewall. From the client, I can use a .udl file to connect to the server successfully.
I have enabled the firewall. I have set up two firewall rules allowing all connections coming from and going to the SQL Server service and the SQL Browser service. When Both the rules' profiles are set to "Public" (i.e. public network connections are allowed), the connection works between the client and the server, using connection string "10.8.0.1\SQL2008R2", however when the rules are set to "Private" (i.e. private network and vpn connections are allowed), the connection fails.
Can anybody shed any light on this problem?
Thanks,
Max.
I have connected my server and computer via an OpenVPN. I have installed SQL server 2008 R2 express on the server and disabled the firewall. From the client, I can use a .udl file to connect to the server successfully.
I have enabled the firewall. I have set up two firewall rules allowing all connections coming from and going to the SQL Server service and the SQL Browser service. When Both the rules' profiles are set to "Public" (i.e. public network connections are allowed), the connection works between the client and the server, using connection string "10.8.0.1\SQL2008R2", however when the rules are set to "Private" (i.e. private network and vpn connections are allowed), the connection fails.
Can anybody shed any light on this problem?
Thanks,
Max.