Insufficient database permissions when trying to update the BarTender System Database in BarTender from previous versions Follow

Avatar
Samantha Petro

Symptom

When connecting to a BarTender System Database (likely remote), the user account is able to log into the database but receives this message right after connecting: 

insufficient_db_permissions_upgrade.png

Environment

 BarTender 2019 and above

Solution

It is recommended to have a database administrator or IT admin follow the below solution steps.

BarTender 2019 and above requires that the BarTender System Database be upgraded from the older format / schema. To do this, the current user account that accesses the BarTender System Database must have specific permissions which can be configured within Microsoft SQL Server Management Studio. (Note the current user can be changed later. This is just required for the update)

1. The current user account must have the following roles:

  • Server role: dbcreator
  • Database role: db_owner

The specific action needed is RESTORE and that action is only available in these roles. If you are unsure how to modify this setting, please see Configuring permissions to a System Database.

2. Use the BarTender System Database Wizard to connect to the BarTender System Database using an account that meets these credentials to perform the update.

3. Once logged in with a user account that has sufficient permissions, it will be presented with these options:

upgrade_DB.png

You will need to choose the first option, else BarTender will not be able to use the current System Database. Choosing this option does not make the database unusable by BarTender 2016 and prior versions.

Once that update is complete, you can use the same wizard to modify the connection and change the logged-in user account if needed.

Internal only information

For more detailed information, please see this internal article: What are the minimum permissions to perform Administrative Tasks for the BT System Database in BT v2016?

Please sign in to leave a comment.