My Short and to the (Share)Point thoughts

Connecting SharePoint to a SQL Instance on static port

If you are using a SQL server instance on static port (best practice for to secure SQL) there are a couple of things you need to do.

  1. On the SQL server, in the firewall configuration, allow inbound connections to your static port.
  2. In the SharePoint Configuration Wizard, you need to put "dbserver\instance,PortNumber" for the Database server name.