FAQs

Database

You will receive an email containing your online hosting details for your new database that will contain the following items:

——————————————————————–

Hostname: This is the new database host address

Database: The name of the database

User ID:   The login name of the database

Password:  The database password

——————————————————————–

THE MOST IMPORTANT STEP IS THIS:

[1] Backup your CRS data and templates which can be found at:

C:\Users\[Your User]\Documents\CRS\

DO NOT PROCEED UNTIL STEP [1] IS COMPLETED!

[2] Backup your CRS database.  

For SQL backup

DO NOT PROCEED UNTIL STEP [2] IS COMPLETED!

Instructions to change to a new database

Option 1 – Via CRS Settings

Option 2 – Manual Method

Option 1  – Change Database location via CRS Settings

Start CRS and go to Settings->Database tab.  Next click the Database Connection button.

The Database Wizard page will open where you can specify the new values as per the email.

Please enter Hostname, Database, User ID and Password exatactly as you find them in the email.  Simply copy and paste these values.

Click the TEST CONNECTION [1] button and the connection should go GREEN

IMPORTANT: IF THIS IS A NEW DATABASE YOU WILL NEED TO SPECIFY THE DATABASE STRUCTURE BY CLICKING THE REMAINDER BUTTONS (3, 4 AND 5).  BUTTON 2 CAN BE INGNORED IF USING A ONLINE DATABASE AS THIS ONLY CHECKS YOUR LOCAL MACHINE FOR AN INSTALLED SQL SERVER INSTANCE.

Instructions to change to Online Database

[2] Open “database.xml” using notepad which is located at:

C:\Users\[Your User]\Documents\CRS\Database\database.xml

In order to start using your online database you need to make a change in your database.xml which can be found at:

Please delete the contents of the file and replace with the following:

============= COPY BETWEEN THIS LINE =============

Data Source=79.170.40.192;Initial Catalog=mssql0_LaptopGeek_1;Integrated Security=False;User ID=mssql0_LaptopGeek_1;Password=crs5%8>hTr;Pooling=True;Max Pool Size=200;Connect Timeout=30
================== AND THIS LINE ==================

If you have any questions regarding license renewal, please look at our FAQs or reply to this email.

Kind Regards

Paul
Computer Repair Shop Software,

Category: Database

There are several methods to backup your database:

Method 1 – Copying the physical database files

Method 2 – 3rd Party Software

THE MOST IMPORTANT STEP IS THIS:

[1] Backup your CRS data and templates which can be found at:

C:\Users\[Your User]\Documents\CRS\

DO NOT PROCEED UNTIL STEP [1] IS COMPLETED!

[2] Backup your CRS database.  

For SQL backup

DO NOT PROCEED UNTIL STEP [2] IS COMPLETED!

You can manually make copies of your database files by stopping the SQL Server (CRS) service (Run->services.msc) then go to “C:\Program Files\Microsoft SQL Server\MSSQL11.CRS\MSSQL\DATA” and physically copy CRS and CRS_log files. Once copied, restart the CRS service again.

Please also ensure you backup your c:\User\Documents\CRS\ folder which contains your database connection file, license file and templates.

We also recommend the following SQL Backup software which is free: sqlbackupandftp.com [1] but unable to offer support for this software.

Category: Database

License

All license keys are manually processed and can take up to 24 hours (usually within an hour or two) and you will receive an email with your license key.  During non-business days and holidays, this may take a bit longer or will be the next working day.

Category: License

The latest version CRS uses an activation license key which is used to unlock features and add users easily.  To update your license please contact us or create a new subscription on this website.

Category: License

With a monthly subscription you can spread the costs of the annual license which is a much better way to manage your cash flow.  By subscribing you are entitled to the very latest CRS releases as soon as it they are released including the latest beta releases plus you get our premium support with help and questions answered as priority.    As a subscriber your suggestions for new ideas and features are also implemented faster.

Subscribing also ensures we can meet our operational and development costs and keep new features being implemented.

Category: License

If you get this error when trying to activate your license this is most likely due to your security software blocking the WMI calls which your license activation needs to identify your machine and activate your license. Comodo Internet Security has been known to cause this and I recommend disabling or uninstalling your antivirus or internet security software if you see this error.

Category: License

Setup and Installation

If you are using CRS for the first time, the default code is “1234”.  Please make sure you change it after you have logged in.

If you have forgotten your access code or would like to reset the admin user code please contact us for advice.