Microsoft SQL Server 2019 or 2022 Express

Follow these instructions to install, setup, and configure VoiceConsole to use Microsoft SQL Server 2019 or 2022 Express.

  1. Download SQL Server 2019 or 2022 Express from www.microsoft.com and install, selecting basic type.

  2. Download SQL Server Management Studio (SSMS) from www.learn.microsoft.com and install it.

  3. Open SSMS and connect to Database Engine

    • Set the Server name to localhost\SQLExpress

    • Set Authentication to Windows Authentication.

    • Click Connect.

  4. In the left Object Explorer pane, select Databases, right-click, and select New Database.

    • Enter the name of the new database and click OK.

  5. Select Security > Logins and right-click to select New Login.

    • Select SQL Server authentication.

    • Enter login name and password.

    • Uncheck User must change password at next login.

    • Click OK.

  6. Select Security > Logins > (the new login created in the previous step) and right-click to select Properties.

    • Select the Server Roles page.

    • Check the sysadmin server role and click OK.

  7. Right-click on DB engine (this is labeled localhost\SQLExpress) and select Properties.

    • Select the Security page.

    • Set Server authentication as SQL Server and Windows Authentication mode and click OK.

  8. Launch SQL Server 2019 Configuration Manager.

  9. Click SQL Server Network Configuration.

  10. Double click on Protocols for SQLEXPRESS.

    • If TCP/IP protocol is disabled, a default choice for security with SQL Server installations, right-click on TCP/IP protocol in the context menu and choose Enable.

    • Double-click on TCP/IP protocol and click on the IP Addresses tab.

    • Scroll down to the IPAll section.

    • Double-click the cell next to TCP Dynamic Ports and delete any number in that cell.

    • Double-click the cell next to TCP Port and enter 1433.

    • Click Apply and then OK.

  11. Click on SQL Server Services.

  12. In the right-hand pane, note that the SQLEXPRESS instance of SQL Server is running. Right-click SQL Server (SQLEXPRESS) and select Restart. The server stops and then restarts, which applies the changes made above.

  13. During VoiceConsole installation, make the following entries on the select Database Configuration tab:

    • Database Server: SQL Server

    • Select Basic Settings

    • Database Hostname: localhost\SQLExpress

    • Database Port: 1433 (default)

    • Database Username: as configured above

    • Database Password:.as configured above

    • Database Schema: dbo