Install New Database

Before You Begin:

• Create a new Database from within SQL Server Management Studio.

• Copy the DatabaseScript.exe from the "\Products\DatabaseScripts" folder, and all of its contents, from the Installation media to a desired location on the SQL Server machine. For more information about Database script, see the topic Database script.

• We recommend you to use Force Protocol Encryption on the SQL Server. For more information, see the Microsoft documentation on configuring SQL Server Database Engine for encrypting connections.

Steps:

1. Launch the Database Scripts Installation Utility by double-clicking the ‘DatabaseScript.exe’.

2. On the Run Scripts tab, click the ellipsis button () in the Connection String field to display the Data Link Properties window.

3. In the Data Link Properties window, on the Provider tab, select Microsoft OLE DB Driver for SQL Server and then click Next.

   Note: If you have not installed the drivers, then download Microsoft OLE DB Driver 18 for SQL Server (x64) from the Microsoft website.

4. Select All tab and set the value of DataTypeCompatibility to 80.

5. On the Connection tab, enter the server, user, and database names as appropriate to SQL.

6. Check the box Allow saving password.

7. Click Test Connection and then click OK to close the Data Link Properties window.

   If the connection is successfully established, a confirmation message appears.

8. On the Run Scripts tab, from the Install Type section, select Install New Database.

9. Select the required language from the Language drop-down box (if not already selected).

10. Select the required timezone from the Time zone drop-down box.

11. To run the configured scripts, click the Execute button.

    If the scripts have run successfully, it will return the "Scripts ran successfully." message.

    Caution: Be sure to check the "Script Trace" tab after running any scripts to check for errors.