Skip to main content
Deutsch Español Français 日本語 简体中文 繁體中文

Search

Articles in this section

System Database Setup Wizard Fails to Pass Configuration String to BarTender System Service Connecting to Remote Database

Jasper Wen

BarTender Content Team

  • Updated

Symptom

When trying to connect to a remote BarTender System database, you may encounter the following error message:

The System Database Setup Wizard encountered an error while creating or connecting to the database.

inline-730174013.png

 inline1991218342.png

Applicable to

All BarTender versions

Solution 

Set a Domain Account for BarTender System Service

Set a domain account on the BarTender System Service with local administrator and domain permissions to access the BarTender System Database.

  1. Open Windows Services.
  2. Right click the BarTender System Service and select Properties

mceclip0.png

  1. Go to the Log on tab.
  2. Choose the option This account.

mceclip1.png

  1. Specify a domain account with local administrator and domain permissions to access the BarTender System Database.
  2. Restart the BarTender System Service.

Disable the Use FIPS Compliant Algorithms for Encryption Windows Group Policy

Please consult your IT department before changing this setting.

Via the Group Policy Editor

If your computer is joined to a domain and the group policy settings are centrally managed by your organization, you won’t be able to change them yourself. You should consult your IT or network administrator before making changes to any policy settings.

To change this setting in Local Group Policy:

  1. Press Windows Key+R to open the Run dialog.
  2. Type gpedit.msc into the Run dialog box and press Enter.
  3. In the Group Policy Editor, navigate to:
    Computer Configuration\Windows Settings\Security Settings\Local Policies\Security Options
  4. Locate the System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing setting in the right pane and double-click it.
  5. Set the setting to Disabled and click OK.
  6. Restart the computer.

Via the Registry

You can also enable or disable the FIPS setting via a registry setting. To check whether FIPS is enabled or disabled in the registry, follow these steps:

  1. Press Windows Key+R to open the Run dialog.
  2. Type regedit into the Run dialog box and press Enter.
  3. Navigate to: 
     HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Lsa\FipsAlgorithmPolicy\
  4. Look at the Enabled value in the right pane. If it’s set to 0, FIPS mode is disabled. If it’s set to 1, FIPS mode is enabled. To change the setting, double-click the Enabled value and change it accordingly.
  5. Restart the computer.

Use SQL Authentication for BarTender System Database

By using SQL credentials to connect to your BarTender System Database you can circumvent the issue. 

Follow the steps listed in this guide to configure your server and client machines to use SQL authentication:

Related articles