Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Download and install MSSQL EXPRESS from Microsoft (free)

    • https://docswww.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-2017download/details.aspx?id=55994

    • Configure

      • Authentication mode: mixed

      • Set a strong password for user ‘sa’
        Keep the password for user ‘sa’ for later.

    • During the installation the connection string is shown. It contains the name of the server instance, usually localhost\SQLEXPRESS. Keep the instance name for later.

  • Make sure TCP is enabled (“SQL Server Configuration Manager”)

  • Make sure that the following services are running and startup type is set to Automatic:

    • SQL Server (SQLEXPRESS)

    • SQL Server Browser

  • Make sure that the “sqlcmd” (try run in Poweshell) command line tool is installed. If not it can be downloaded from https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility

...