Options for configuring BarTender System Database permissions Follow
By default, the BarTender System Database is configured to use Windows Authentication, and the Windows user who runs the BarTender installer package is the one who gets authorization. If multiple users on the same machine are using BarTender, additional database permissions must be configured to prevent unexpected behavior such as app crashes and reprinting failures.
There are several ways to grant database permission to multiple users. Choosing one will depend on which BarTender features and apps are in use, as well as the IT policies of your organization. They will also require administrator access to implement, so you may need to contact your IT team for assistance with these procedures.
Here are three possible methods:
- Enable SQL Authentication and create a login. The advantage of this method is that it uses a single username and password, so any user with those login credentials can access the database. However, it may not be ideal for environments where individual user activity must be tracked.
- Continue using the default Windows Authentication and manually add permissions for users or groups. This allows automatic sign-in and activity logging of specific Windows users, but it requires a bit more expertise to set up and manage.
- Configure the BarTender System Service to run as an administrator account that has access to the System Database. This process is required for connecting to a remote System Database, and it can be a relatively easy shortcut for configuring a local one.
A fourth solution is also worth mentioning: you could bypass the issue entirely by skipping the installation of the BarTender System Database if it is not required in your environment. For more information about this decision, please see the support article "Do I have to install SQL Server Express for BarTender to work?"
All supported versions and editions of BarTender with a local System Database installed
Click on a method to expand it and show the steps to implement.
Configuring SQL Authentication in three steps
Configuring Windows Authentication in four steps
Setting an account on the BarTender System Service
- BarTender Services and Permissions
- Configuring permissions to a System Database (Video - 5:45)
- Do I have to install SQL Server Express for BarTender to work?
- How do you uninstall the BarTender SQL Server instance?
Internal only information
Regarding the comment about error 1053:
- If BSS takes an unusually long time to start, or fails to start entirely with an error 1053, this is often a sign that something is wrong with the user credentials. Either the password is incorrect, or they don't have the necessary permissions (local administrator with domain access). Verify the permissions for the user account, re-enter the credentials in the BSS Properties, and try to Start it again.
Our article about error 1053 describes a different solution, but I have encountered the error in BarTender 2019 and 2021 under different conditions than those described in the article. I have yet to reliably reproduce the issue, but verifying the credentials and permissions has been helpful in the instances I've encountered it.