Print Portal cannot access global data fields: permissions error with system database and accounts
Symptom
You have a label that uses global data fields. This works fine in BarTender designer but when working with Print Portal, the system database cannot be accessed and you cannot open the label file.
During this process, you may see one or more of the following errors:
ERROR: BarTenderSystemDatabaseContext [database name]: Failed to access system database: Exception occurred: An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct. The provider did not return a ProviderManifestToken string. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
ErrorController FatalError: A fatal error occurred: Unable to access the BarTender System Database. Please ensure that the user account configured to run the Application Pool has sufficient access rights to the BarTender System Database. The following error message was returned: The provider did not return a ProviderManifestToken string. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
AdminSettingsFactory GetAdminSettingsFromDatabase: Error getting initial settings values from the database.: Exception occurred: An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct. The provider did not return a ProviderManifestToken string. Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Environment
BarTender 2016 and later
Print Portal
Fix/Answer
Change the BarTender Print Scheduler service to log on with an account that has permissions to access to the System Database. In this specific case, the authentication is failing when the Print Scheduler opens up BT as a service and tries to access the System Database for the label data.
Please see Troubleshooting guides: BarTender Print Portal for more information on setting permissions and which ones to use.