Configuring permissions to a System Database (Video - 5:45) Follow

Avatar

BarTender Content Team


 
Important note: The default name of the system database is different depending on the version of BarTender you're using. Please see the following list for the default names
- BarTender 2016 and earlier: "BarTender"
- BarTender 2019 and later: "Datastore"

Minimum permissions needed to use System Database

There are two different user authentication types that can be used with a BarTender System Database:

  • Windows authentication
  • SQL Server authentication

Windows authentication connects to the BarTender database using the Windows user account that is currently logged in.  In this method, SQL does not ask for a password; authentication is handled by Windows alone. You can use an active directory users or groups for easier management.

SQL Server authentication uses logins that are created directly on the SQL server.  These logins are not based on Windows user credentials.

There are minimum permissions required to connect to a BarTender System Database (additional permissions will be required for administration):

  • CONNECT
  • DELETE
  • EXECUTE
  • INSERT
  • SELECT
  • UPDATE
Note: You may need to set a domain account for the BarTender System Service in the Windows services list to allow appropriate permissions to connect to a remote BarTender database.

For more information, refer to the Administration Console white paper or Options for configuring BarTender System Database permissions.

 

Additional resources

When working with a system database, there are a number of moving parts both within SQL and in the BarTender Suite. The following resources can help determine which type of authentication is right for you and what extra permissions you might need with administration.

Authentication

Administration

 

Do you have feedback or questions on this article? We encourage you to post them on our Community Forums