Cannot Open Database 'redtill'

The Problem

Failed to connect. Cannot open database

On the main (or only) computer, you get the error message: Unable to connect to SQL server - Cannot open database 'redtill'. 

This usually means your database is corrupt. This can happen when the database files get damaged due to hardware issues. An example would be a powersurge after a power failure that causes corruption on the hard drive. 

Solution 1: Recreate the database

On your main comptuter (your server computer where the database is installed), start the ROBOTILL Database Setup Wizard directly. 'All Apps' > ROBOTIILL > 'ROBOTILL Database Setup'

When the wizard start click on 'Begin Setup >>'

Installing ROBOTILL Server

Select Main Computer and click Next.

Installed SQL Server Directly

Select 'I installed SQL Server Directly' (even if you didn't). Click Next and then just accept all the default settings for the rest.

Open ROBOTILL Back Office and log in with the default username (admin) and the default password (password). Go to Home > Database > Restore Database and do a database restore using your latest backup file.

Solution 2: Re-Install SQL Server

If solution 1 failed, then it means that it is probably the master database that was also corrupted or even the SQL server instance that has a problem You will then need to re-install SQL server.

  1. Uninstall SQL Server
  2. After restarting your computer, start the ROBOTILL Database Setup Wizard directly - go to All Programs > ROBOTILL > ROBOTILL Database Setup.
  3. Follow the main PC set up instructions
  4. Do a database restore using your latest backup file.