Overview

Enterprise seats store their initial SQL connection and other information in the Windows registry. When Enterprise starts it will read the registry to get the SQL connection and other startup information. This information is missing when installing Enterprise seats.

Starting with Enterprise v4.5 this registry information can be populated during a Seat install. The installer will look for a file named defaultsettings.ini located one folder level up from the installer program. If this file is found the file settings will be read and used to configure the computer's registry. The installer will only set registry values that do not exist. Once the initial registry values are set the installer will never update them.

When the Site Update tool runs it will look for the defaultsettings.ini using the UNC path under the "PypeServer Staging" \\<File Share Name>\PypeServer Staging\Updates\Configuration\PypeServer. If the file is not found, then it is created.

When the Site Update tool creates the defaultsettings.ini file, it will add the following registry values from the registry key HKEY_LOCAL_MACHINE\SOFTWARE\PypeServer.

• Server

• SQLAuthMode

• Credentials

  • Note: If there are credentials for multiple sites, these other sites will also be available on new Seat installs.

Once this file is created the Site Update tool will never update it again. To reset the configuration, delete the file and run the Sute Update installer again.

Settings

The defaultsettings.ini file has two sections, SystemSettings and UserSettings. Values in the SystemSettings section will create new values under the registry key HKEY_LOCAL_MACHINE\SOFTWARE\PypeServer, while values in the UserSettings section will create new values under the registry key HKEY_CURRENT_USER\Software\PypeServer\UserSettings.

Note: Only settings specified here can be set by the installer. Setting other Enterprise registry values that are not listed here is not supported.

SystemSettings

• Server: Default Site SQL Server formatted as server\instance

• SQLAuthMode: Either SQL or Windows

• SQLCredentials: Encrypted credentials string

  • Configure using the SQL Connection button in the Site Update tool.

• TraceLog: Diagnostic file logging level

  • Defaults to Detail. Values are Info, Error, Detail, Debug.

UserSettings

• Environment

  • JSON string containing name/value pairs for Enterprise Seat Environment settings

  • Can be configured by copying the registry value from a configures Seat.

Sample File

[SystemSettings]
Server=pypeserverdemo.privatelink.database.windows.net
SQLAuthMode=SQL
SQLCredentials=EAAAAFmflZ3pCBZ27CUj2joq...BzN1bknYfXKmbbmkkDsG2aH4QoE5r0=
TraceLog=DEBUG

[UserSettings]
Environment=[{"Group":"Global","Name":"EnableAnalytics","Value":"True"},{"Group":"Global","Name":"UseWPFViewer","Value":"False"},{"Group":"Global","Name":"ModernLook","Value":"True"},{"Group":"Global","Name":"SkinName","Value":"Office 2019 Colorful"}]