Librarian Database Error... Follow

0
Avatar
Legacy Poster

Whenever I attempt to open the Librarian application or perform any function within, I receive the message "There was a problem connecting to the database." I am not sure what the issue is as I do not see anything being logged elsewhere. Is there something I can do to further troubleshoot this message?

4 comments

0
Avatar
Shotaro Ito
Moderator
Comment actions Permalink

Hi Jason,
You need to setup BarTender system database (or connect to remote system database).
From BarTender > Tools, run System database setup (you may need to install SQL server Express on the PC, or connect to a remote SQL Server)

To connect to remote SQL server and create BarTender system database, Windows service "BarTender System Service" must be log on by an account which have enough privilege to create database on the SQL server. (in case of Windows authentication.)

There's some online help about system database connection, from [Help] button on System database setup dialog.

Once system database setup has done, you should be able to connect to system database via History Explorer or Librarian.
0
Avatar
Legacy Poster
Comment actions Permalink

I'm receiving a similar error, only with the librarian.

 

"The database connection failed"

 

I've setup the BarTender System Service to run as a network user. The user account has required permissions on the SQL server (from what i can tell).

 

I do not receive the error when connecting under the user which installed bartender to the server (a domain admin account).

 

The database states that it is connected, and security changes made from the server are being applied to the client PC, so it seems the database is connected however the librarian will not connect.

 

EDIT> Does the librarian ignore the service account credentials..?? I've just added the locally logged on user to the SQL server logins, as an owner and the librarian now connects.. The Librarian seems to now be ignoring security centre settings (i can edit labels which is not permitted)..?

 

Something is wrong with librarian permissions.

0
Avatar
Domingo Rodriguez
Moderator
Comment actions Permalink

1. First of all, make sure (and confirm to us) if the System Database has been properly set up. The below training video will help you:

http://www.bartenderbarcodesoftware.com/label-software/training-video-(setting-up-a-system-database).aspx

 

Are you using Windows or SQL Server credentials when setting up the connect to the system database?

 

 

2. The below training video also explains how to configure the necesary permissions for the system database wizard to properly connect to the BarTender System database:

http://www.bartenderbarcodesoftware.com/label-software/training-video-(configuring-permissions-to-the-system-database).aspx

 

 

3. Could you send us as well a screenshot of the error message in Librarian?

 

4. If you open "History Explorer", are you able to view past print job information being logged by the system database?

 

5. If Security Center would be totally disabled on this computer, would you still receive the same "The database connection failed" error message from within Librarian while being logged under the user account?

0
Avatar
Legacy Poster
Comment actions Permalink

Ok great thanks, the permissions were not set correctly on the SQL Database. There are no connectivity issues now after adding domain users group as detailed in the second video.

 

Thank you!

Please sign in to leave a comment.