Install SQL Server for SurveilStar

Currently, SurveilStar Employee Monitoring Software needs to work with Microsoft SQL Server, either free express edition or paid enterprise edition will be OK. So far, SurveilStar can work with free SQL servers including Microsoft SQL Server 2000 Desktop Engine (MSDE 2000), SQL Server 2005 Express Edition and SQL Server 2008 (or R2) Express Edition as well as work with professional SQL Servers including SQL Server 2000 SP4, SQL Server 2005 SP1 or above and SQL Server 2008 (or R2) or above.

Please choose one of the SQL servers appropriate for you. Please note:
1. MSDE 2000 SP4 is included in SurveilStar setup file, so you don't need to download.
2. If you use SQL Server 2005 Express SP1 or SQL Server 2008 (or R2) Express, you can download it from Microsoft's official website.

Summary

1. Installing SQL Server 2000 Desktop Engine (MSDE 2000)

2. Installing SQL Server 2005 Express SP1 or above (Watch Video Tutorial)

3. Installing SQL Server 2008 (R2) Express or above

4. Installing SQL Server Enterprise Edition

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

1. Installing SQL Server 2000 Desktop Engine (MSDE 2000)

Since the MSDE 2000 is included in SurveilStar setup file, simply download SurveilStar setup file and double click to launch setup. Go straight and you will see a step like following picture. Please make sure Microsoft SQL Server 2000 Desktop Engine(MSDE) is checked. Otherwise, SurveilStar won't work properly.

Please note that SQL Server 2000 Desktop Engine can only store 2GB data and it's not compatible with Vista, 7 or 2008 server. If you intend to use Vista, Windows 7 or Server 2008 as Surveilstar server, please use SQL Server 2005 Express or SQl Server 2008 (R2) instead.

--------------------------------------------------------------------------------------------------------------------------------------------------

2. Installing SQL Server 2005 Express SP1 or above

Before installing SQL Server 2005 Express, please make sure you have installed following components, otherwise, the system won't allow you to install SQL Server 2005 Express.

1. Download and install Microsoft .Net Framework 2.0 SP1(Minimum) or Microsoft .Net Framework 3.5 SP1 (or newer)

2. Download and install Windows Installer 3.1 or Windows Installer 4.5

3. Download and install Windows PowerShell 1.0 or Windows PowerShell 2.0

SQL Server 2005 Express is available on Microsoft's official webiste. You can download it from HERE. Installing SQL Server 2005 Express SP1 or above, your computer should meet the following system requirements according to Microsoft's introduction.

System Requirement:

OS: Windows 2000 Service Pack 4, Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Windows Vista, Windows XP

CPU: Computer with Intel or compatible Pentium III 500 MHz or faster processor (1 GHz or faster is recommended.)

Memory: Minimum of 512 MB of RAM (1 GB or more is recommended.)

Hard Disk Space: 600 MB or more

Installation Steps

Installing Microsoft SQL Server 2005 or higher version should be carried out before installing Surveilstar Server. There are some configurations you need to pay attention to, otherwise, the SurveilStar server may not work correctly. Please follow the steps below.

Note: Video tutorial of installing SQL Server 2005 Express is also available. Watch video tutorial now.

1. Download Microsoft SQL Server 2005 SP1 or higher version and double-click to launch the installation.

2.After extracting files, check “I accept licensing terms and conditions” and click “Next”, click “Install”, and then click “Next” in the wizard dialog, after “system configuration check”, you will go to the step as the picture below.

3. Enter your Name and Company information, uncheck “Hide advanced configuration options”, and click Next button.

4. Unfold Client Components, and install “Management Studio Express”. After select “Management Studio Express Will be installed on local hard drive”, click Next button.

5. Please set “Instance Name” to “Default instance”, click Next button.

6. In the Service Account, please set “Use the built-in system account” to “Local System”, and click Next button.

7. In the following steps, you can use default settings to go forward to the end.

Note: You don’t need to check “Microsoft SQL Server 2000 Desktop Engine (MSDE)” any more when installing SurveilStar Server.

--------------------------------------------------------------------------------------------------------------------------------------------------

3. Installing SQL Server 2008 (R2) Express or above

Before installing SQL Server 2008 (R2) Express, please make sure you have installed following components, otherwise, the system won't allow you to install SQL Server 2008 (R2) Express. After installing the componets below, please restart your computer at first, then you can go on installing SQL Server 2008 (R2) Express.

1. Download and install Microsoft .Net Framework 3.5 SP1 or newer version.

2. Download and install Windows Installer 4.5

3. Download and install Windows PowerShell 1.0 or Windows PowerShell 2.0

SQL Server 2008 R2 Express is available on Microsoft's official webiste. You can download it from HERE. Installing SQL Server 2008 R2 Express or above, your computer should meet the following system requirements according to Microsoft's introduction.

System Requirement:

OS: Windows 7, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2

CPU: Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended.) for 32-bit systems, 1.4 GHz or faster processor for 64-bit systems.

Memory: Minimum of 512 MB of RAM (2 GB or more is recommended.)

Hard Disk Space: 2.2 GB or more.

Installation Steps

Installing Microsoft SQL Server 2008 R2 or higher version should be carried out before installing Surveilstar Server. There are some configurations you need to pay attention to, otherwise, the SurveilStar server may not work correctly. Please follow the steps below.

1. Download SQL Server 2008 R2 Express and double-click to launch the installation.

2. After extracting files, you will go to License Terms dialog. Check "I accept the license terms.".

3. Setup Support Files: The support files are required to setup or update SQL server.

4. Setup Support Rules: Make sure there is no failed items. Failures must be corrected before setup can continue.

5. Feature Selection: By default, all the features are selected. It's OK.

6. Instance Configuration: If you select Default Instance, please set Instance ID to SQLEXPRESS. If you select Named Instance, please set Named Instance to MSSQLSERVER and set Instance ID to MSSQLSERVER.

7. Disk Space Requirement: Installing 2008 R2 Express requires 4558MB or more. Please make sure you have enough free space.

8. Server Configuration: Set SQL Server Database Engine and SQL Server Reporting Services to System.

9. Database Engine Configuration: Set Mixed Mode. In Specify SQL Server adminitrators dialog, we recommend you Add Current User as well as add System account.

10. Reporting Service Configuration: If you don't have special requirements, go next.

11. Error Reporting: Go next step directly or check the option you need.

12. Installation Configuration Rules: If there is no failure, go next.

13. Installation Progress: This may take a few minutes and please wait till it's done.

After SQL Server 2008 R2 is successfully installed, you can now go to install SurveilStar Server.

--------------------------------------------------------------------------------------------------------------------------------------------------

4. Installing SQL Server Enterprise Edition

Installing SQL Server Enterprise Edition is similar to installing SQL Server Express Edition. If you are using any paid SQL Server(Enterprise Edition), please make sure the special configurations mentioned in Express Edition above are done in the same way. Please refer to the instructions above respectively according to your SQL Server version.

--------------------------------------------------------------------------------------------------------------------------------------------------

Back to Index

Installing SurveilStar Server