Installing SQL Server Express @ Dhante.com

1. Synopsis

This document describes the installation procedure for SQL Server Express on Windows.

This free version will allow for DB sizes up to 10GB.

Download SQL Server Express via the SQL Server 2019 setup program.
Run it.
Then click on the Download Media button to download a self extracting .exe file which can then be stored on a file server share.

Enable TCP/IP
1. Right click on Protocols for SQLExpress
2. Expand SQL Server Network Configuration.
3. Right click on TCP/IP
4. Click on Enable.
The default port for SQL Server is 1433 but it can be set to a custom value within the TCP Port setting.
1. Right click on TCP/IP and choose Properties.
2. Click the IP Adresses tab.
3. Scroll to the bottom of the window.
4. Add the port Note: we are using a custom port:

Full document here
Launch an elevated CMD prompt window.
Run the netsh command. Note: if you specified a custom port in the previous state, you should specify that value here too as the localport value:

netsh advfirewall firewall add rule name = MSSQL dir = in protocol = tcp action = allow localport = 1285 remoteip = localsubnet profile = DOMAIN

Install SSMS on the server that hosts the SQL Server and on any number of desktops.

This step is optional
Connect to the the SQL Server via SqlServer Management Studio
Right mouse click on the server name and select Server Properties.
Change DB Settings
Even after making the changes, the gui will still reflect the old values until the SQL Server is restarted.
Restart SQL Server

This operation may have to be completed on the server that hosts the SQL Server.
Confirm changes have been made: