Install BarTender SQL Server Express Manually Follow

Avatar
Samantha Petro

All installations of BarTender 2019 require Microsoft SQL Server Express for internal application functions. This is required whether or not you use any application message logging or print logging.

The BarTender installation wizard attempts to install SQL Server Express silently during BarTender installation. In the vast majority of cases, this works flawlessly. However, there are some rare instances where the SQL Server installation fails and you must troubleshoot the installation and install it manually.

Starting with BarTender 2019 R3, you'll receive the following message if BarTender fails to install SQL Server:

This guide will walk you through the steps to figure out why the installation failed and install it manually. The process will consist of the following steps:

  1. Starting SQL Server installation
  2. Installing SQL Server
  3. Troubleshooting SQL Server errors
  4. Installing BarTender

Start SQL Server Installation


Once the files are extracted and ready, you must start the SQL Server Installation. You have two options for this:

It's fastest to simply start the installation manually, but the Command Line Interface allows you to preconfigure most of the options that need to be set during installation. We've provided instructions for both options.

Start SQL Server Manually

I have attempted to install BarTender

If you've already attempted to install BarTender, you can access the setup files from the following location:


              C:\Users\<USERNAME>\AppData\Local\Temp\SQLEXPR_x64_ENU
          

Make sure to replace <USERNAME> with your username.

  1. Navigate to the above directory
  2. Double click on SETUP.exe

At this point, you can proceed to Installing SQL Server.

I have not attempted to install BarTender

If you haven't run the BarTender installer, you can download the files from Microsoft and start the installation.

  1. Go to: https://www.microsoft.com/en-us/download/details.aspx?id=42299
  2. Select your language and press Download
  3. Choose the option that matches your OS Architecture:
    • Express 32BIT\SQLEXPR_x86_ENU.exe (for 32-bit)
    • Express 64BIT\SQLEXPR_x64_ENU.exe (for 64-bit)
  4. After the download is complete, double click the file to begin extraction
  5. Once the files have been extracted, the installation wizard will start automatically.

At this point, you can proceed to Installing SQL Server.

Using Windows Command Line Interface

I have attempted to install BarTender

If you have already attempted to install BarTender, you already have the SQL installation files and can run the following command:

    1. Go to the Windows Start menu
    2. Type CMD to open a Windows Command Prompt
    3. Enter following command:

                “C:\Users\<USERNAME>\AppData\Local\Temp\SQLEXPR_x64_ENU.exe” /q /ACTION=Install /FEATURES=SQLEngine,FullText /INSTANCENAME=BarTender /SQLSYSADMINACCOUNTS="Builtin\Administrators" "NT AUTHORITY\SYSTEM" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /ADDCURRENTUSERASSQLADMIN /TCPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS /HIDECONSOLE /SkipInstallerRunCheck /UpdateEnabled=0 /SKIPRULES=RebootRequiredCheck SetupCompatibilityCheck NoRebootPackage
              

Make sure that you replace <USERNAME> with your username.

At this point, you can proceed to Installing SQL Server.

I have not attempted to install BarTender

If you haven't tried to install BarTender, you'll need to run the same command, but you'll have to replace the first part with a path a SQL file that you can download from Microsoft.

    1. Go to: https://www.microsoft.com/en-us/download/details.aspx?id=42299
    2. Select your language and press Download
    3. Choose the option that matches your OS Architecture:
      • Express 32BIT\SQLEXPR_x86_ENU.exe (for 32-bit)
      • Express 64BIT\SQLEXPR_x64_ENU.exe (for 64-bit)
    4. After the download is complete, double click the file to begin extraction
    5. Once the files have been extracted, the installation wizard will start automitically. Close this window before running the command line.
    6. Go to the Windows Start menu
    7. Type CMD to open a Windows Command Prompt
    8. Enter following command:

                “<DOWNLOAD_LOCATION>\SQLEXPR_x64_ENU.exe” /q /ACTION=Install /FEATURES=SQLEngine,FullText /INSTANCENAME=BarTender /SQLSYSADMINACCOUNTS="Builtin\Administrators" "NT AUTHORITY\SYSTEM" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /ADDCURRENTUSERASSQLADMIN /TCPENABLED=1 /IACCEPTSQLSERVERLICENSETERMS /HIDECONSOLE /SkipInstallerRunCheck /UpdateEnabled=0 /SKIPRULES=RebootRequiredCheck SetupCompatibilityCheck NoRebootPackage
              

Make sure that you replace <DOWNLOAD_LOCATION> with the location that you downloaded the file to.

At this point, you can proceed to Installing SQL Server.

Going through SQL Server Installation


Once the installation has started, you'll need to go through the installation process. It is important to note that you will encounter an error at some point during the installation. You can troubleshoot some of these error by following the steps in Troubleshooting SQL Server.

License Terms

On the first page of the wizard, make sure to accept the license terms. Click Next.

Global Rules

The second page of the installation setup is the Global Rules. It is highly likely that you'll run into an error on this page. You'll neet to troublleshoot the error in order to continue. We've provided some basic troubleshooting steps here. You can also consult Microsoft's documentation.

Feature Selection

Once you get past the errors blocking installation, you'll want to click Next until you get to the Feature Selection page. Here you'll want to select Database Engine Services from the available options. Click Next.

Instance Configuration

On the Instance Configuration page, choose Named instance: and type in BARTENDER. Click Next.

Database Engine Configuration

Click Next until you get to Database Engine Configuration. You want to set the Server Configuration to Windows authentication mode. You should also add the following users:

  • Builtin\Administrators
  • NT AUTHORITY\SYSTEM
  • Your local users

Complete

Click Next until you reach the final screen. You should see a message saying that your SQL Server 2014 installation completed successfully. Click close.

Troubleshooting SQL Installation


Setup Account Privileges: Failed

SQL_setup.png

This failure means that something within the Windows Group Policy is preventing the current user from being able to do one or more of the following:

  • Back up and archive directories
  • Manage and audit security logs
  • Debug software

You'll need to log into an administrative account that has these privileges to continue. The dialog will not proceed until all these checks are green.

Please see Scenario #3 and the resolution on this help document from Microsoft for more information: SQL Server installation fails if the Setup account doesn't have certain user rights

The specified account already exists

During the SQL installation process, you may encounter an error like this:


            SQL Server Setup has encountered an err when running a Windows Installer File.
            Windows Installer error message: The specified account already exists.
          
SQL_setup2.png

This dialog is relatively unhelpful and means something different than what it appears to be. In short, do the following:

  • Uninstall the SQL 2012 Native Client
  • Click Retry

Installing BarTender


Once SQL Express 2014 confirms it has been successfully installed, run the BarTender 2019 installer as administrator.

You should now proceed past the SQL Server installation error. For additional help installing BarTender, see this video: Installing BarTender.

Was this article helpful?

Please sign in to leave a comment.