Installing the master with an SQL Server database and ODBC connection

To install the master with an SQL Server Express or SQL Server database with an ODBC connection proceed as follows:

Related topics

Installing-the-master-with-an-SQL-server-with-an-existing-user

Installing-the-master-with-an-Oracle-database

  1. At step 18, SQL Server Database Settings check the option ODBC Connection.
  2. Select one of the two possible authentication types:
    1. DSN with SQL Server Authentication:
      • To install with the default values leave all prepopulated boxes as they are.

      • To use an already created DSN name enter the name in the System DSN Name box.

        Note

        You can only use this option with a previously created database and user. For more information, see Setting-up-MS-SQL-Server-with-ODBC-connection-for-installation.

        odbc.png

    2. DSN with Windows Authentication:
      • To install with the default values leave all prepopulated boxes as they are.
      • To use an already created DSN name enter the name in the following System DSN Name.
      • Enter the login and password of the Windows account to be used for connecting to the DSN.
        odbc_win.png
  3. Click Next to continue with step 19 of the general procedure.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*