Home> Support> Technical Documents>

RG-SMP Implementation Cookbook(V1.2)

2017-05-17View: 123
11.x项目配置指南模板

      Daily Maintenance

Before getting started, verify that you install Microsoft SQL Server and RG-SMP, then start SMP Service correctly.

For Database and SMP installation, see RG-SMP Installation Guide and RG-SMP Database Installation and Maintenance Guide

1.1    Login Web UI

When you complete SMP installation and start SMP service successfully, visit SMP web UI at http://Server IP:8080/smp or https://Server IP:8443/smp , the default Username is “admin” and password is “111111111

 

Note: Use IE 8.0 and above version in compatibility mode. Firefox and chrome may have compatible issues.

It is recommended to change password when login. Click “Change Password” in the top right on WEB UI.

 

In this left side, it is the menu as shown, it includes three main components: Authentication & Authority, System Maintenance and Log Audit.

 

 

 

 

 

 

In the middle of the window, it is System Status

 

 

 

Under the system Information, it is the Online User Trend in 24 hours.

 

 

 

 

 

1.2    Check System Status

Click System Status in the up right corner, you can view Current System Status. Usually, it displays Normal as shown in below diagram which indicates SMP works properly.

 

If it displays Abnormal as shown in diagram, something must be wrong, click See Details to check.

1.3    Installing the SQL Server

The RG-SMP supports the Microsoft SQL Server 2005 or SQL Server 2008 as well as the SQL Server 2012 as the background database. The installation steps for the latter two are described as below.

1.3.1 Installing SQL Server 2008 Enterprise Edition

The operation of the RG-SMP system requires a background database. If you use the Microsoft SQL Server 2008, you must install the Microsoft SQL Server 2008 Enterprise Edition.

The SQL Server 2008 is a large database server of Microsoft. This section describes the software and hardware configuration requirements for installing the SQL Server 2008 Enterprise Edition, detailed installation steps and notes.

1)     Insert the CD of SQL Server 2008 Enterprise Edition, click setup.exe, and a message will be prompted asking whether to install the NET framework. Click OK.

 

2)     After automatic installation, the following interface is prompted.

 

3)     Click Installation >New Installation or add features to an existing installation.

 

4)     Click OK.

 

5)     Click Next.

 

6)     Tick I accept the license terms, and click Next.

 

7)     Click Install.

 

8)     Click Next.

9)     Click Next.

 

10)   Tick the components you need as shown in the following figure, and then click Next.

 

11)   Click Next.

 

12)   Choose Default instance, and then click Next.

 

13)   Click Next.

 

14)   Choose NT AUTHORITY/SYSTEM from the Account Name drop-down list.

15)   Choose NT AUTHORITY/SYSTEM for the three services as shown in the figure below.

16)   Choose the Collation tab.

17)   Configure collation. Make sure that the configuration is done exactly as shown in the following figure, or otherwise the SMP cannot run properly.

18)   Click Next.

19)   Configure a user account and a password.

20)   In the Data Directories tab, you can use the default configuration. If the default drive space is insufficient, choose another drive.

21)   In the FILESTREAM tab, configure as shown in the following figure. Click Next.

22)   Click Next.

23)   Click Next.

24)   Click Next.

25)   Click Next.

26)   The installation is complete. Click Close.

27)   Double click the SP1 patch, and click Next.

28)   Tick I accept the license terms, and click Next.

29)   Click Next.

30)   Click Next.

31)   Click Update.

32)   Click Next.

 

33)   The installation is complete. Click Close.

1.3.2 Installing SQL Server 2012 Enterprise Edition

1)     Double-click the setup.exe file, and the following interface is prompted.

 

2)      Click Installation >New SQL Server stand-alone installation or add features to an existing installation.

3)      Click OK.

4)      Click Next.

5)      Tick I accept the license terms, and click Next.

6)      Keep the default setting, and click Next.

7)      Click Next.

8)      Click Next.

9)      Tick the components you need as shown in the following figure, and then click Next.

10)    Click Next.

11)    Choose Default instance, and then click Next.

12)    Click Next.

13)    Choose Browse from the Account Name dropdown list.

14)    Click Advanced.

15)    Click Find Now, and then choose the Administrator user.

16)    Click OK.

17)    As shown in the following figure, choose Administrator for the five services, and input the system login password as the password.

18)    Choose the Collation tab.

19)    Configure collation. Make sure that the configuration is done exactly as shown in the following figure, or otherwise the SMP cannot run properly.

20)    Click Next.

21)    Configure a user account and a password.

22)    In the Data Directories tab, you may use the default configuration. If default drive space is insufficient, you may choose another drive.

23)    In the FILESTREAM tab, configure as shown in the following figure. Click Next.

24)    Click Next.

25)    Click Next.

26)    Click Next.

27)    Click Next.

28)    Click Next.

29)    Click Install.

30)    The installation is complete. Click Close.

31)    Double click the SP1 patch, and click Next.

32)    Tick I accept the license terms, and click Next.

33)    Click Next.

34)    Click Next.

35)    Click Update.

36)    Click Next.

37)    The installation is complete. Click Close.

 

 

1.4    Backup Database

In this section, you will learn how to backup database.

Go to System Maintenance >Database Maintenance, by default auto backup is enabled and the schedule is executed at 4:00 in the morning every day. You can set the removal period in which backup database will be removed automatically.

Click Backup Immediately to backup current database, then browse and save to local disk.

 

1.5    USB Dongle and License Management

SMP license is a red USB dongle which looks like USB drive. Plug in USB dongle in SMP Server before starting SMP service.  SMP detects USB dongle at first startup and every 30 minutes when started up. SMP service will stop if USB dongle is missing.

 

Click System Status in the top right on SMP WEB UI to display license status.

 

  • Sales Enquiry