Configure Microsoft SQL Server

If you choose to use Microsoft SQL Server, you will follow the same installation steps presented on the DryvIQ Platform Initial Installation page. The only difference in the installation will be to select to use Microsoft SQL Server as your database. You must then provide the credentials needed to connect to the database.

  1. When prompted to configure your database, select Use a different database.

     

  2. Select Microsoft SQL Server from the Database platform list and select Next.

     

  3. Add the Server name and Database name for your server.

  4. Select the Authentication type for the database. DryvIQ recommends using Integrated authentication wherever possible. Integrated authentication uses a series of encrypted messages to authenticate users in SQL Server. When SQL Server logins are used, when the Use specific credentials (SQL Authentication) mode is selected, SQL Server login names and encrypted passwords are passed across the network, which makes them less secure.

    If you select Use specific credentials, you will need to provide the username and password that need to be used to authenticate with the server. When using SQL Server Authentication, logins are created in SQL Server that are not based on Windows user accounts. Both the user name and the password are created using SQL Server and stored in SQL Server. Users connecting using SQL Server Authentication must provide their credentials (login and password) every time they connect. When using SQL Server Authentication, you must set strong passwords for all SQL Server accounts. The Use specific credentials (SQL Authentication) mode is most often utilized in scenarios such as connections that need to be made from non-Windows environments or untrusted domains.

  5. Select if you want to enable or disable native encryption for the database. Note that you can also manually enter the connection string for more complex database scenarios. See Configure Database Connection Strings for more information.

     

  6. Select Test Connection to validate your configuration.

  7. You will see a “Connection Successful” message if the database is detected. If the database is not detected, a warning message will display to indicate that it will be created.
    If the connection fails, refer to the DryvIQ Platform Installation Troubleshooting page for assistance.

  8. Select Next to continue.

     

  9. The database information displays for review. Ensure it is correct and select Create database to continue.

     

  10. DryvIQ will begin configuring the database. When it is done, you will be prompted to restart the DryvIQ service. Select Restart.

     

  11. Continue the installation process as outlined on the on the DryvIQ Platform Initial Installation page starting at step 16.

 

DryvIQ Migrate Version: 5.6.2.4175
Release Date: March 7, 2024