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 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.
Dean
I am a Software Developer, System Administrator, and consignment software specialist. I currently manage hundreds of consignment workstations, point of sale systems, and database servers all across North America and I am the developer of Peeps' Software, Peeps2Go, and Peeps' Consignor Login for iOS and Android. I've been helping consignment & resale store-owners since 2003. I started The Computer Peeps in February of 2010. Peeps' Software launched in 2016 and is now on hundreds of systems all across North America. I have successfully converted dozens of stores from all of the major consignment software systems. After 20 years of working with consignment stores, I understand the unique challenges consignment & resale store-owners face. From electrical issues in old buildings or strip malls, to advocating for them when their old consignment software keeps crashing.