Liberty Consignment Unable to Connect to Database

liberty consignment unable to connect to database

Liberty Consignment unable to connect to database is a common issue with Liberty.

Sometimes, simply rebooting can fix this.  That might not always work — sometimes you might have to reboot twice.  Reboot twice!?  Yes, reboot twice.  Microsoft SQL Server is a Microsoft product, so Windows Updates can impact it.  If updates have impacted it, rebooting doesn’t mean everything’s done — that’s when updates actually install.  Then, there’s post-update processing when you first log-in.  Once this has finished, reboot again, and you’re back to *normal*.

There can also be times when rebooting isn’t going to help:

  • You have three computers, but the main/server computer, is powered-off, has become disconnected from the network, etc.
  • A new change to your systems — e.g. installing firewall/security software — is blocking incoming connections to MS SQL Server.

For Peeps’ customers and the systems we monitor, knowing if our stores’ systems can connect to MS SQL Server and if Liberty will be up and running for them when they open, is critical.

Peeps’ Liberty Connection Checker

For customers on Peeps’ Support, we’ve learned over the years, that you can check all you want @ making sure MS SQL Server is up and running — that does NOT mean Liberty (or anything) is actually able to connect to the database.

So after having stores call-in and report they’re unable to open Liberty — even though we monitor to see if MS SQL Server is running — we wrote our own, redundant monitoring software that actually tries to connect to the database — Peeps’ Liberty Connection Checker:

This guarantees us that our stores on Liberty, will be able to run Liberty when they get in.  If it can’t connect, we’re alerted, as is the store:

liberty consignment unable to connect to database
Click to Enlarge

Liberty isn’t perfect and Liberty doesn’t check these things for you.  Two simple things Liberty could do to minimize your support costs:

  • At the very least, suggest you reboot the computer.
  • Automatically try to Stop/Start the MS SQL Server service for you.

I am a consignment software specialist, System Administrator for hundreds of consignment workstations across North America, and developer of Peeps' Software! I've been helping consignment & resale store-owners since 2003. I started The Computer Peeps in February of 2010. After 18+ years of working with consignment stores, I understand the unique challenges consignment & resale store-owners face. From electrical issues in old building or strip malls, to advocating for them when their consignment software keeps crashing. I now manage hundreds of computer systems, servers & websites for store-owners all across North America and I am the developer/programmer of Peeps' Software -- the only software written FOR consignment & resale stores specifically.

Leave a Comment

Your email address will not be published. Required fields are marked *


Back To Top