The serverconfig.xml File

The serverconfig.xml file is located in the same directory as the Totalview3Server executable and contains the start-up settings for the Totalview server.

The file contains the location of the database and a list of hard coded users.

Change the location of the database

The connection string contains information about the SQL server and Totalview database in use. The location can be changed by setting the Catalog and Data source parameters.

The Password and User ID must also be changed to a user with access to the SQL server.

If you want to start the Totalview3Server service with a specific windows user instead of Local System account, you must replace “Password=xxxx;User ID=sa” in the serverconfig.xml with “Integrated Security=SSPI” and run the Totalview3Server service using the specific user.

Remember to assign the windows user necessary rights to the Totalview database.

Change the SQL provider to support TLS 1.2

The default SQL provider used by Totalview does not support TLS 1.2.

If TLS 1.2 is required then the MSOLEDBSQL provider should be used. The SQL provider can be downloaded here.

Change the connection string in the config file to use the MSOLEDBSQL provider.

The connection string should replace the Provider=SQLOLEDB.1; with Provider=MSOLEDBSQL;DataTypeCompatibility=80;

MSOLEDBSQL version 19 has Trusted connection as default. This is a breaking change and requires that “Use Encryption for Data=False” is added to the connection string when using version 19 or newer.

Example connection string:

<dbTotalView connectionstring="Provider=MSOLEDBSQL;DataTypeCompatibility=80;Use Encryption for Data=False;Password=******;User ID=sa;Initial Catalog=TotalviewDB;Data Source=localhost"/>

Change the hard coded user

The settings of the hard coded user can be changed by changing the user name and password parameters.

The hard coded user can be disabled by setting the parameter enabled=”no”.

IPv6

Set the ipv6 attribute to true to enable IPv6 support on the TotalviewServer service.

When set, the TotalviewServer service supports both IPv4 and IPv6 at the same time.

Using TLS secure communication

Set the usetls attribute to true to enable secure communication between the Totalview server and all clients.

The certificateSubject must point to a certificate with a private key.

Certificate search location precedence is:

1. Current User\Personal (My) Store

2. Local Machine\Personal (My) Store

Set the logging level

Set the log level attribute to control the logging level.

Possible values are Trace, Debug, Info, Warn, Error, Fatal and Off. Default is Info

The TotalviewServer will pick up any changes in the log level setting within 30 sec.

Notify

If you don’t want to be notified if a mail sent from the Switchboard fails you can set the tag

<SMTP RequestFailureNotify=”no” />

In the Serverconfig.xml under the TotalviewServerConfiguration

Example of serverconfig.xml:

<?xml version="1.0" encoding="UTF-8"?>
<TotalViewServerConfiguration>
    <SMTP RequestFailureNotify=”no” />
    <listener port="3333" ipv6="False" usetls="False" certificateSubject="TotalviewCertificate"/>
    <dbTotalView connectionstring="Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=Totalview3Test;Data Source=SQLSERVER"/>
    <loglevel level="Info"/>
    <HardcodedUsers>
        <user name="tvadmin" password="1234" enabled="yes"/>
    </HardcodedUsers>
    <AllowAdmins>
        <client address="TV3TEST" enabled="yes"/>
    </AllowAdmins>
</TotalViewServerConfiguration>