Hello,
I have installed SQL Server 2012 Express on a computer, named SqlExpress.
Computer 1: Installed SQL Server 2012 Developer with default instance name. Firewall is on. TCP Port 1433 opened for inbound rules. Able to remotely access the default instance. When I change to "All Ports" opened for inbound rules, I'm still unable
to remotely access SqlExpress. When I turn the firewall off, remote access to SqlExpress is successful.
Computer 2: No other instances are installed. Firewall is on. Adding a TCP "ALL Ports" inbound rule does not work for remote access either. When I turn off the firewall, remote access is OK.
Below is one of the command line commands I used for adding an inbound rules.
netsh advfirewall firewall add rule name = SqlPorts dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN,PRIVATE,PUBLIC
Can anybody explain how to gain remote access to SqlEx ...
Go to the complete details ...