How to configure a shared local database and improve performance using SQL server across multiple brokers

How to configure a shared local database and improve performance using SQL server across multiple brokers

Product: Thinfinity Workspace
Version: 7 and above

Thinfinity Workspace uses a shared local database based on Absolute Database, a Delphi database engine. It is a compact, fast, robust and easy-to-use database engine designed to improve performance and manage multiple functionalities. Access and authentication profiles, enterprise logging, notifications, resource reservations, VDI management and identity provisioning are all centralized within this database. This setup ensures efficient data management and consistent operation across multiple brokers, optimizing user experience and system performance.
The purpose of this article is to guide users on how to configure a shared local database and improve performance across multiple primary brokers by detailing the configuration steps for SQL Server, Windows Firewall and Thinfinity Workspace.
For the purposes of this document, we will show the configuration using SQL Server, but you may use other database software.

I. Prerequisites

Before proceeding with the configuration, ensure you have:
  • Administrative access to all servers involved.
  • Thinfinity Workspace installed and accessible.
  • SQL Server installed and running.
  • SQL Server Management Studio installed.
  • New empty database created for use with Thinfinity Workspace.

II. Configuring SQL Server

Verify Remote Connections are Allowed

  • The first thing that you need to do is check that remote connections to the SQL Server are allowed. To do this, open SQL Server Management Studio (SSMS) by clicking START > Microsoft SQL Server > SQL Server Management Studio. Enter your password to connect.
  • Then right-click on the Server and select Properties.

  • The Server Properties window will now appear. Select the Connections page on the left side of the window.
  • In the right pane of the Server Properties window, ensure that the Allow remote connections to this server is selected. Then click OK.

SQL Server Browser

  • You will now start the SQL Server Configuration Manager. This can be found at the following location in the windows start menu Start > Microsoft SQL Server > SQL Server Configuration Manager.
  • SQL Server Configuration Manager will have several choices on the left pane of the main window. Select SQL Server Services.
  • You will then need to Start the service SQL Server Browser and check that the start mode is set to Automatic. This allows other computers to access the SQL server by IP or Server name.

SQL Server Network Configuration Protocols

  • You will now enable TCP/IP to allow computers to connect to SQL Server over IP. Right-click on TCP/IP and select Enable.
  • Similarly, enable Named Pipes to allow computers to connect to SQL Server using the server name.
Right-click Named Pipes and select Enable.
Note that any changes made will not take effect until the service is restarted.

  • Our SQL configuration is complete. You will now need to restart the SQL Server service. From the SQL Server Service on the SQL Server Configuration Manager, right-click the SQL Server. Select Restart.

III. Configuring Windows Firewall

Create a new firewall rule that adds a program exception for the SQL Server executable

  • From the start menu, type wf.msc and press Enter to open Windows Defender Firewall with Advanced Security.
  • In the left pane, select Inbound rules.
  • In the right pane, under Actions, select New ruleNew Inbound Rule Wizard will open.

  • On Rule type, select Program. Select Next.

  • Under Program, select This program path. Select Browse to locate your instance of SQL Server. The program is called sqlservr.exe. It's usually located at:
C:\Program Files\Microsoft SQL Server\MSSQL<InstanceName>\MSSQL\Binn\sqlservr.exe
  • Click Open, then Next.

  • Under Action, select Allow the connection. Then click Next.

  • In Profile, select the profiles that apply to your network configuration. Select Next.
Take into account that enabling the rule for the Public profile may expose your network to security risks and you may need to add other security measures that fit your needs.

  • In Name, type a name for the rule. Select Finish.

IV. Configuring Thinfinity Workspace

Set Up Database on Thinfinity Workspace

You will have to apply this configuration to each Thinfinity Workspace Primary Broker that you wish to connect to the SQL Database.
  • Open the Thinfinity Configuration Manager and navigate to the Database tab. Then, to the right of Database Connections select the + sign to add an SQL database connection and Name it. Then click OK.

  • Next, complete the following fields:
Server Name = SQL Server name\Instance name
Database Name = The name of the SQL DB you just created
User Name = SQL DB User name with admin privileges
Password = Password for the SQL DB admin user
  • When finished, click Test Connection and you will receive a Connection successful message.

  • Finally, select the System Components that will use either the Local or the SQL DB and click Apply.

You are now ready to share your Thinfinity Workspace configuration among multiple Primary Brokers and improve their performance.
This document provides comprehensive guidance on configuring a shared local database using SQL Server within Thinfinity Workspace. With this configuration, users can expect improved performance, enhanced security and consistent operation of their Thinfinity Workspace environment.
If you have any further inquiries or need additional support, please do not hesitate to reach out to us. Our team is always available to help address any questions or concerns you may have.

    • Related Articles

    • Thinfinity Secondary Brokers - A Technologically Advanced and Secure Alternative for Accessing OT Networks

      Executive Summary Operational Technology (OT) networks are integral to modern industrial operations. Traditional methods of accessing these networks, such as VPNs and jump servers, have become increasingly problematic due to security vulnerabilities ...
    • How to Configure VirtualUI Sessions

      Product: Thinfinity Workspace Versions: 7 and later Introduction Welcome to the VirtualUI Sessions configuration guide for Thinfinity Workspace. This concise guide provides the instructions to ensure the successful configuration of VirtualUI ...
    • How to Create your First RDP Connection using Thinfinity as a Jump Server

      1. Introduction Welcome to this comprehensive guide designed to facilitate the setup of your initial RDP connection using Thinfinity® Workspace. Within this guide, we'll provide a detailed walkthrough on configuring Thinfinity® as a jump server, ...
    • Configure Single Sign-On in using RADIUS

      Product: Thinfinity Workspace Version: 7 and above RADIUS (Remote Authentication Dial-In User Service) is a networking protocol used for centralized authentication, authorization, and accounting (AAA) for remote access services. It enables secure ...
    • How to Publish your First RemoteApp Connection to a Jump Server

      1. Introduction In this guide, you will learn how to configure your first RemoteApp assuming you have read the Getting Started Guide. This guide has been crafted for administrators like you, responsible for establishing and configuring Thinfinity® ...