Steps for localhost config:

host: localhost, or in this full name 'DESKTOP-<...>\SQLEXPRESS' will be 'DESKTOP-D8J192Q'

instance name: can be blank or 'SQLEXPRESS'

port: default is 1433 but see below

user: sql user

pwd: sql user pwd

Important Callouts:

• make sure your SQL server permits SQL Server & Microsoft Authentication in the properties view

• make sure your SQL server permits TCP/IP config. By DEFAULT, this is disable for all SQl Server

Steps for enabling TCP/IP config:

• Find 'SQLServerManager' for your SQL server instance:

• 'C:\Windows\SysWOW64\SQLServerManager15' -- number '15' can change

• go to 'SQL Server Network Configuration'

• go to your SQL server instance name

• right click the TCP/IP option and enable this traffic protocol. You'll need to restart your server instance for this change to take effect

• restart your server instance by either, in SQLServerManager, with SQL Server Services, select your instance, and toggle restart. Or by doing so in SQL Server

Steps to find port of SQL Server:

• note PID from SQLServerManager of your running instance

• run this in powershell 'netstat -ano | findstr PID'

• set port number in database config