Installing the ObserveIT Databases

This topic describes how to attach the databases to the SQL server machine.

The DB install process can also be run directly on the SQL Server machine.

If unable to log in as the ObserveIT Service Account interactively, see Using PowerShell.

The diagram below shows the file server and the SQL database. The SQL database is installed after you configure the file server.

Prerequisites

Installing the Databases

  1. Connect to the computer where you downloaded and extracted the ObserveIT Setup files.

    See Downloading the Latest Version.

  2. Run the SQLPackage.exe file located in the DB folder which was created when you extracted the setup files from the archive.

    The Database Installer main window appears.

  3. Select the SQL Server on which to install the database. The details of the Server field are in the following format:

    <ServerFQDN>\<InstanceName>,<Port>

    For example:

    SQLsrv.test.lab\ObserveIT,1433

  4. If the account you are currently using is an SQL Server administrator, select Windows Authentication as the authentication method. Otherwise, select SQL Server Authentication and provide a user name and password with privileges to create databases and user accounts. If you select Windows Authentication, you will need to perform additional tasks.

  5. Click Run to begin the installation.

    If the connection is successful, the installation will proceed. If not, check the connectivity to the SQL server and make sure the connection string is correct.

    Hint: Check the Windows Firewall on the SQL Server and either turn it off, or add the relevant rules to allow SQL Server connectivity (TCP port 1433), check protocol bindings (TCP/IP must be enabled), and check the SQL Server listening port.

    See Configuring Windows Firewall for more information.

  6. Click OK to ignore the following message:

    Warning – Unable to create ObserveITUser (ObserveITUser Name: ObserveITUser)! (User does not have permission to perform this action.) Press OK if you wish to continue anyway.

    If you did not receive this error, it means that the ObserveIT service account has SYSADMIN permissions on the SQL Server. It is strongly suggested that you stop the installation at this phase, delete the resulting databases, change the ObserveIT service account permissions to DBCREATOR, and then re-execute the database installer program. While, by itself, this is not a problem, the result is that the ObserveIT database and the subsequent connection strings used by all the ObserveIT components will use the “ObserveITUser” account in SQL Server instead of the ObserveIT service account. To fix this issue you will need to manually change the connection strings and change the SQL Server database settings. Contact support for information on how to perform these changes.

    The message .ObserveIT database successfully installed appears.

  7. Acknowledge the message the message ObserveIT database successfully installed. When the 4 databases are created, the window closes.

Installing the Analytics Database

  1. Connect to the computer where you downloaded and extracted the ObserveIT Setup files.

  2. Run the SQLPackage.exe file located in the DB_Analytics folder which was created when you extracted the setup files from the archive.

  3. Select the SQL Server on which to install the database. The details of the Server field are in the following format:

    <ServerFQDN>\<InstanceName>,<Port>

    For example:

    SQLsrv.test.lab\ObserveIT,1433

  4. If the account you are currently using is an SQL Server administrator, select Windows Authentication as the authentication method. Otherwise, select SQL Server Authentication and provide a user name and password with privileges to create databases and user accounts. If you select Windows Authentication, you will need to perform additional tasks.

  5. From File Explorer, navigate and open the DB_Analytics folder and double-click the SQLPackage file.

  6. Click Run.

    If the connection is successful, the installation will proceed. If not, check the connectivity to the SQL server and make sure the connection string is correct.

    Hint: Check the Windows Firewall on the SQL Server and either turn it off, or add the relevant rules to allow SQL Server connectivity (TCP port 1433), check protocol bindings (TCP/IP must be enabled), and check the SQL Server listening port.

    See Configuring Windows Firewall for more information.

  7. Click OK to ignore the following message.

    Warning – Unable to create ObserveITUser (ObserveITUser Name: ObserveITUser)! (User does not have permission to perform this action.) Press OK if you wish to continue anyway.

    If you did not receive this error, it means that the ObserveIT service account has SYSADMIN permissions on the SQL Server. It is strongly suggested that you stop the installation at this phase, delete the resulting databases, change the ObserveIT service account permissions to DBCREATOR, and then re-execute the database installer program. While, by itself, this is not a problem, the result is that the ObserveIT database and the subsequent connection strings used by all the ObserveIT components will use the “ObserveITUser” account in SQL Server instead of the ObserveIT service account. To fix this issue you will need to manually change the connection strings and change the SQL Server database settings. Contact support for information on how to perform these changes.

    The message .ObserveIT database successfully installed appears.

  8. Acknowledge the success message ObserveIT database successfully installed.

Related Topics:

Configuring Location for Recorded Screenshots

Installing and Configuring Databases

Verifying Database Installation

Moving Database File to Drives

Setting Initial Database File Sizes

Installing Database Maintenance

** Go to Custom Installation Steps.