CRS Setup and Database Setup

Note:  Please ensure you install this software as an Administrator.

First Time Users 

If you are a first time CRS user and have never installed CRS before, please ensure you download and install CRS-FULL.EXE.  This installer includes SQL Server.  You only need to download this the first time and for all your other workstations and for future updates to CRS you only need to download CRS.EXE (approx 30MB).

Install CRS Software For the first time

Watch Video – First Time User – Setup SQL Server

[1] Download and install CRS software.  Run CRS.

[2] You will first be prompted to configure the database.

If this is your first time using CRS you will also need to install SQL Server before continuing  You will be prompted to do this on starting CRS for the first time.

databasefirsttime1

databasefirsttime2

Wait for files to extract (nothing extracted?  Did you install CRS-FULL.EXE?).

databasefirsttime3

Now, you simply need to click the NEXT button for every step.  CRS has already completed the information in the pages.

CLICK NEXT

sql4

CLICK NEXT

sql1

CLICK NEXT

sql2

CLICK NEXT

sql3

CLICK NEXT to Install SQL Server.  This may take 5-10 mins to complete.

Congratulations – SQL INSTALLED.

[3] Go back to the CRS database wizard and confirm SQL Server is installed correctly.

Click Test Connection Button.

database3

Click Each button and confirm they turn GREEN.

Button 1 – Tests SQL Server is installed ok.

Button 2 – Tests to ensure database is available and has not been created previously.

Button 3 – This will CREATE A NEW DATABASE called CRS.

Button 4 – This will create all the tables for your database ready for CRS to use.

database4

[4] Finally, SAVE CRS DATABASE FILE.  This will save a database.xml file into Documents\CRS\Database.

database5

ALL DONE

[5] CRS will upgrade to the latest database version – please be patient, this may take a few mins to complete and is a one off upgrade.

[6] You will first be prompted for your license details. If you have a valid license please browse to it here.

[7] Once completed you will get the Login screen:

CRS Login

The default admin login passcode is 1234.

Please ensure you change the default passcode from the Configure Users page.

 

Enable Remote Connections for SQL Server

If you want to use CRS over your network so that you have several CRS workstations accessing the same database then you need to Enable Remote Connections on your SQL Server database machine (this is optional and can be done at a later date if you don’t need network access just yet):

[1] Run SQL Server Configuration Manager (Start->Programs->SQL Server 2012->Configuration Tools)

[2] Go to [SQL Server Network Configuration] and select [Protocols for CRS]

– Right Click TCP/IP and select Enabled

– Right-click on TCP/IP and select Properties

– Verify that, under IP2, the IP Address is set to the computer’s IP address on the local subnet

– Scroll down to IPAll

– Make sure that TCP Dynamic Ports is blank

– Make sure that TCP Port is set to 1433

[3] Go to [SQL Server Services] ensure SQL Browser service is set to automatic

[4] Restart SQL Server instance by right clicking SQL Server (CRS) and select Restart

Now you can test if remote connections is working by running CRS on a different machine on your network and follow instructions above for first time running.

CONFIGURE FIREWALL

If Steps [1] to [4] don’t work here are some things to check:

CONFIGURE FIREWALL – Open Ports 1433 (TCP) and 1434 (UDP)

To open a port in the Windows firewall for Port 1433 TCP access

  1. On the Start menu, click Run, type WF.msc, and then click OK.

  2. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.

  3. In the Rule Type dialog box, select Port, and then click Next.

  4. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1433 for the default instance. Click Next.

  5. In the Action dialog box, select Allow the connection, and then click Next.

  6. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.

  7. In the Name dialog box, type a name and description for this rule, and then click Finish.

To open a port in the Windows firewall for Port 1434 UDP access

  1. On the Start menu, click Run, type WF.msc, and then click OK.

  2. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane.

  3. In the Rule Type dialog box, select Port, and then click Next.

  4. In the Protocol and Ports dialog box, select UDP. Select Specific local ports, and then type the port number of the instance of the Database Engine, such as 1434 for the default instance. Click Next.

  5. In the Action dialog box, select Allow the connection, and then click Next.

  6. In the Profile dialog box, select any profiles that describe the computer connection environment when you want to connect to the Database Engine, and then click Next.

  7. In the Name dialog box, type a name and description for this rule, and then click Finish.

 

Online Resources:
Configure Remote Connections on port 1433:
http://support.webecs.com/KB/a375/how-do-i-configure-sql-server-express-to-allow-remote.aspx

Configure Firewall to allow SQL in Control Panel:

Note:  Allow ports 1433 TCP and 1434 UDP through your firewall.  

Anti-Virus and Firewall Could Be Blocking Connections

If you have problems connecting over a network, turn off or uninstall both your Anti-Virus software and the Windows Firewall on the machine the server is installed on to allow direct access.  

MOST REMOTE CONNECTION ISSUES ARE FIREWALL RELATED!!  YOUR ANTI-VIRUS SOFTWARE OR FIREWALL ARE BLOCKING SQL CONNECTION – TURN OFF BOTH AND TEST IF CRS CONNECTS.

TO CHECK IF YOUR SECURITY SOFTWARE IS CAUSING PROBLEMS, TURN OFF OR UNINSTALL AND TRY STEPS [1] TO [4] AGAIN.

IF THIS DOES RESOLVE THE REMOTE CONNECTION, YOU NEED TO GO INTO YOUR ANTI-VIRUS FIREWALL PROPERTIES AND CONFIGURE SQL TO BE ALLOWED THROUGH.

 

Database Troubleshooting

If you are experiencing difficulties in setting up your database or you are unable to make a connection please read the following:

[1] Have you installed SQL Server 2012 using the setup.cmd downloaded from CRS download page (sql32.zip or sql64.zip)? If Yes go to [2]

[2] Did SQL Server 2012 fully install without an error? If Yes go to [3]

[3] Please go to Start->Programs->SQL Server 2012->Configuration Tools and run SQL Server Configuration Manager. Please ensure SQL Server (CRS) is running. If it is not running right click it and choose “Start” from the context menu.