Your SQL port must be open to be able to connect over the internet (Usually port 1444). How to check which port SQL is using and whether it is open. 1. Go into windows file explorer and right-click "This PC" then click "Manage".
I was looking for a PowerShell replacement of the script provided in MS KB “How to open the firewall port for SQL Server on Windows Server 2008” which uses the netsh command to open the Windows firewall ports for SQL Server. Because in future versions of Windows, Microsoft might remove the Netsh functionality for Windows Firewall with Advanced Security. How to determine and change the port of an SSAS Instance Nov 19, 2010 Remove Dynamic Port Configuration from a SQL Server Instance Dec 19, 2018
Also DOH I realised I would need the windows Cluster and also add SQL server ports. Review of ports now need to add. TCP. 1433, 3343, 139, 445 . UDP. 3343, 137, 138 . To keep it simple adding 137 & 138 as TCP ports as well. So new ports for rules for the block rule adapted to allow these required ports.
This port's adjacent UDP cousin hosted the fastest spreading Internet worm ever seen at the time. What's interesting about this port (1433) is that a less well known, and significantly less prolific SQL worm, known as the "SQL Snake" was discovered to be exploiting a different SQL server vulnerability almost a year earlier. It didn't make How To Open Firewall Port 1433 for SQL Server Database In the Rule Type dialog box, select Port, and then click Next. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, In my case we are using the default which is 1433. Click Next. In the Action dialog box, select Allow the connection, and then click Next.
Sep 21, 2011
The default port for SQL Server Database Engine is 1433. And as a best practice it should always be changed after the installation. 1433 is widely known which makes it vulnerable to attacks. Configure a Windows Firewall for Database Engine Access The SQL Server Browser service lets users connect to instances of the Database Engine that are not listening on port 1433, without knowing the port number. …