CMS Installation & Setup Manual

CMS Software Installation and Setup Manual

1. To run CMS software properly, at least two computers connected with
LAN are needed to be prepared with Microsoft Windows 7 or Windows 10
(32-bit or 64-bit) installed.
2. Set a password for Win 7 /Win 10 built-in administrator account and log in
as administrator. Note that the log-in passwords for all computers running
CMS system must be the same.
3. Windows Firewall must be turned off in all of the computers:

1
 CMS Installation & Setup Manual

4. Follow the steps below to install SQL Server 2008 R2 database in one of
the computers (so the computer with database installed can work as CMS
server):
Double click “setup” in SQL Server 2008 R2 installation package:

2
 CMS Installation & Setup Manual

Click“Installation”at the top left of the window:

Click “New SQL Server stand-alone installation or add features to an

existing installation”:

3
 CMS Installation & Setup Manual

Click “OK” to continue:

Click “Next”:

4
 CMS Installation & Setup Manual

Check “I accept the license terms” and click “Next”:

Click “Install”:

5
 CMS Installation & Setup Manual

Click “Next”:

It is not necessary to select all the features in the list to install but only
tick the ones as shown above. And then click “next”:

6
 CMS Installation & Setup Manual

Keep the defaults and click “Next”:

Click “Next”:

7
 CMS Installation & Setup Manual

Click “Use the same account for all SQL Server services” to open a setting
window:

Select “NT
NT AUTHORITY
AUTHORITY\SYSTEM” in the dropdown list as the Account
Name, and leave Password empty. Click “Next”:

8
 CMS Installation & Setup Manual

Select “Mixed Mode (SQL Server authentication and Windows

authentication)”, enter and confirm a password (for example, sk88), and
then click “Add Current User” to add administrator account into the list.

In “Data Directories” tab, the “Data root directory” and “User database
directory” are the location where the database data files are saved. It is
possible to change this default path to a non-system drive instead of C
drive if necessary, but normally we can keep the default path. Click “Next”:

9
 CMS Installation & Setup Manual

Click “Next”:

10
 CMS Installation & Setup Manual

Click “Next”:

Click “Install” to start installation process, it will take a few minutes:

11
 CMS Installation & Setup Manual

Up to now the setup procedures complete as shown above. Click “Next”:

Click “Close” to finish the installation.

5. Configure SQL Server database in order to allow CMS programs remote
access from CMS DAQ computers (workstations):

12
 CMS Installation & Setup Manual

 From “Start”  “All programs”  “Microsoft SQL Server 2008”  “SQL

Server Configuration Manger” to open the configuration window:

13
 CMS Installation & Setup Manual

 Click “SQL
SQL Server Network Configuration
Configuration”  “Protocols
Protocols for
MSSQLSERVER”, four protocol names are listed in the right side :

By default, “Named
Named Pipes
Pipes” and “TCP/IP” status are “Disabled
Disabled” after
installation. Wee need to enable them by right click on them and select
“Enable”:

14
 CMS Installation & Setup Manual

Click “Ok”. The final settings look like as below:

 Click “SQL Server Services” in the top left:

Right click on “SQL Server (MSSQLSERVER)“ and select “Restart” to

restart the database service in order to make the new settings take

15
 CMS Installation & Setup Manual

effective, as shown below:

When the process is completed, close the setting window.

16
 CMS Installation & Setup Manual

Note:
 In case you want to change CMS Server’s computer name, it strongly suggests you to
change it before installation of SQL Server 2008.
 Follow the steps above to install SQL Server 2008 in Sub-server computer as spare. So
in case the main server computer has hardware or OS problem, it is possible to
quickly change over to Sub-server.
 Microsoft .Net Framework 3.5 is necessary to be installed first if installation of SQL
Server 2008 is preceded under Windows 10. Please refer to the appendix for
installation of Microsoft .Net Framework 3.5.

6. Installation of CMS Software

CMS software shall be installed in all of the computers. Double click on CMS
installation package to install CMS system:

If it is the first time to install CMS under Windows 7, Microsoft .net

Framework 4.6 incorporated in the installation package will be installed first
(because one of CMS programs called RT-Client needs it to be supported for
running) as shown below. But If Microsoft .net Framework 4.6 was already
installed or CMS installation was under Windows 10, it will be skipped by
CMS installation program.

17
 CMS Installation & Setup Manual

Click “Install” to start installation of Microsoft .net Framework 4.6. It will take
a few minutes to complete:

After completion, CMS installation window comes up:

Click “Next”:

18
 CMS Installation & Setup Manual

Enter any User Name and Organization name, click “Next”:

By default the program will be installed in the system drive C: as the path
shown in the window above. You can keep the default path to install CMS but
for CMS server, it is recommended to change it to non-system drives (For
example, D:\Creative Mudlogging System) because there will be binary data
files .RRD created and saved daily in the installation folder when CMS is
19
 CMS Installation & Setup Manual

running during mudlogging, and the size of each .RRD data file is more than
15MB. So to avoid the system drive C: in CMS server is taken with full space,
we can install CMS in one of the non-system drives in CMS server.
Click “Next” with either keeping the default path or changing the path:

Click “Install” to start the installation until a completion window comes up:

20
 CMS Installation & Setup Manual

Click “Finish” to exit the window. There are two shortcuts generated on
desktop after completion of CMS installation as shown below:

21
 CMS Installation & Setup Manual

And the CMS installation folders will look like as below:

7. Creation of CMS Database

A CMS database is necessary to be created in CMS server at first if it is the
first time to install CMS. Run CMSSetting tool by double clicking its shortcut
on Desktop (you can also find it from Start All Programs  Creative
Mudlogging System):

 In “Server” text box, enter the IP address of CMS server computer and

22
 CMS Installation & Setup Manual

click on “Test Connection” button to test the connection with SQL Server
database. If it is connected successfully, click “OK”:

 Click “Maintenance” tab:

Click on “Connect” to connect the database. If it is the first time to create

CMS database, only “Create Database” button is available:

23
 CMS Installation & Setup Manual

 Click on “Create Database”, “Backup Database” and “Restore Database”

buttons become available:

 Click on “Restore Database”, a warning window will pop out:

Click OK. Select the original CMS database template which is located in the

24
 CMS Installation & Setup Manual

CMS installation directory (\Create Mudlogging System\Database):

Click Yes to start restoring CMS database process. A prompt window appears
when completion of restoring:

Click “OK” to finish the creation of CMS database.

The “Backup Database” function is used to backup CMS database whenever

necessary during mud logging jobs. For example, after you make complete
configurations in DAQ program, or when you need to back up your
mudlogging data in case CMS server crashes.
To back up CMS database, click “Backup Database” button, set the path
where the backup is to be saved, and give a backup file name:
25
 CMS Installation & Setup Manual

Click on “Open” to start backup process :

A prompt window appears when completion of the backup as shown above.

Note: It is strongly suggested that users backup the database in the following cases, so
that the DB backup files can be used to restore CMS database for the sake of either CMS
database crash or for next new well to avoid an extra-large database:
 The first time when completion of unit settings and configurations in CMS DAQ
programs (devices, channels, calibrations …)
 After completion of the first well initialization prior to commence of mudlogging job
for this well
 Routine backups during mudlogging operations

8. Installation of the driver for CMS dongle, CAN Bus adapter card and
PCIS-DUSK card:
 Install CMS dongle driver in CMS server computer:
The driver can be found in CMS installation directory .\Creative

26
 CMS Installation & Setup Manual

Mudlogging System\Driver\HASP. Double click [Link] to

open the following installation Wizard：

Click “Next” button:

27
 CMS Installation & Setup Manual

Select “I accept the license agreement”, click “Next” button to start

installation:

A completion window will pop out, click “Finish” to end up the installation:

28
 CMS Installation & Setup Manual

 Install the driver for CAN Bus adapter card in DAQ computer: make sure
the CAN Bus adapter card is secured inside DAQ computer. The driver can
be found in CMS installation directory .\Creative Mudlogging
System\Driver\ PCI7841.
Double click PCI-7841_x86_v2.0.7.0 For Win7 to run the driver installation
program and follow the wizard steps to finish the procedures. You can see
“NuDAQ Boards” and “PCI7841 Device“ in Windows device manager as
shown below, indicting the device is installed correctly:

 Install the driver for PCIS-DUSK card in DAQ computer: PCIS-DUSK card
may be used for external alarms. The driver can be found in CMS installation
directory .\Creative Mudlogging System\Driver\ ADLink7250.
Double click [Link] to run the driver installation program and follow
the wizard steps to finish the procedures. After installation a window pop out
to request rebooting the system, click Yes and restart the computer to finish
the installation:

29
 CMS Installation & Setup Manual

9. Run CMS software

 Run CMS in CMS Server computer: now you can run CMS software by
double clicking the shortcut of “CMS_Console” icon in the desktop. Note
that you have to run CMS_Console in the Server computer first:

The first time when you run CMS in the Server computer, it may be
showing “CMS has not linked the server, system will link again
automatically” on the top bar of the window (see above). In this case,
click “File” in the menu bar and choose “IP Address Setup(I)” item to open
the following window:

30
 CMS Installation & Setup Manual

Check the box of “Assign this computer as server”, the IP address of the
Server computer will be present in the IP box automatically. Click “OK”
button, the main interface of CMS_Console will be changed as below,
indicating CMS has been connected to its database and is ready to work:

 Run CMS in the DAQ computer (i.e. another computer which may be
working as a Data Acquisition machine): double click the shortcut of
CMSSetting on desktop (or “Start”  “All Programs” “Creative
Mudlogging System”  “CMSSetting”) to open the window:

31
 CMS Installation & Setup Manual

In Server text box, enter the IP address of CMS Server computer and click
on “Test Connection” button, if the following window appears, it means
CMS in DAQ computer is connected to the Server successfully:

Now you can double click the shortcut of “CMS_Console” icon in the
desktop to run the program as follows:

10. Basic operations with CMS programs

Here below are the normal operational procedures to launch CMS
programs in order to carry out mudlogging jobs:
 Boot and login the computers systems of Main Server, Main DAQ, Sub

32
 CMS Installation & Setup Manual

Server and Sub DAQ in turns, then CMS Console programs shall be
running automatically in each of the computers
 In CMS_Console running in any of the computers, click “System” program
group  “Initialize” to run the program to create a new well and enter
the necessary basic data for the well. If it was already been done before,
skip this step.
 For Canet type acquisition system, run SKCannetDaq program in any of
the four computers:

Make configurations in “Daq Setup” and set the IP in “Comm” (please

refer to《SKCanetDaq User's Manual》) in order to allow CMS DAQ
program to connect to it.
 In CMS_Console running in DAQ computer, click “Data Acquisition”
program group  “DAQ” to run the program. If all the sensors are
installed and connected, click Settings in the menu bar, configure
SK-Wireless in Device, and set channels for it (see the window below and
also please refer to《SKCanetDaq User's Manual》for the details).
 Make sure DAQ program connects to SKCanetDaq program properly, click
button, the program starts collecting data within 5 seconds, and all
the collecting data will be showing in the main screen of DAQ program.

33
 CMS Installation & Setup Manual

34
 CMS Installation & Setup Manual

 In CMS_Console running in Server computer, click “Monitor” program

group  “Calculator” to run the program, it would minimize into the
right corner of the Task bar:

Note:
 Only one copy of DAQ and Calculator programs are possible to run within CMS
local network system.
 Although Calculator program can be running in any of the four computers, but it is
suggested to run it in CMS Server computer.
 In CMS Console running in any of the computers, click “Monitor”
program group  “MonitorLogic” to run the program as shown below.
Only the acquisition data should now be displaying on the window, and
DRILLSTAT shall be displaying “Suspend”:

35
 CMS Installation & Setup Manual

 Click Startup in the menu and select “Drilling”. Enter the necessary initial
values (Measured Depth, Bit Depth, and Current WOB) in the opened
window and click “Apply” to start tracking of the status:

36
 CMS Installation & Setup Manual

Note that with MonitorLogic program being operated during drilling, it is

necessary to check and set proper logic threshholds for different drill status
according to the real situation at rigsite, track and adjust drillpipe stands
when necessary, and reset depth/bit depth and WOB, zero total pump

37
 CMS Installation & Setup Manual

strokes…etc.
 In CMS Console running in Server computer, click “Data Output” program
group  “Data Logger” to run the program, it starts saving data into all
the CMS database tables according to the default storage settings:

 Run RT-Client programs for monitoring in any of the computers

respectively. The startup screen of RT-Client program is shown as below:

If it is the first time to run this program, click properties in startup window

38
 CMS Installation & Setup Manual

(the smaller one) to open the following “Define Server” window:

This window is used for defining the server and active well & hole: enter the
server IP and press Select…buttons to choose the active well & hole
respectively. Click “OK” to start linking to CMS database and receiving /
displaying realtime data. If this step was done before, you can click OK
directly in startup window to access to the monitoring screen:

 The following CMS programs can be run in any of the computers

39
 CMS Installation & Setup Manual

whenever necessary during mud-logging jobs:

 CDA Setup: to view parameters’ current values and unit types,
change parameters’ alias or its group
 Unit: to convert parameters’ units or add new units
 Alarm: to set up alarming conditions for the parameters
 Initialize: to enter or modify annulus, BHA & drillstring, mud
properties and pumps & pits data…etc.
 Cuttings: to view the mud return queues in the annulus
 Remote Transfer: to set up and send WITS data to third parties
 Database Manager: to query / edit / export realtime data…etc.

40
 CMS Installation & Setup Manual

Appendix:
Install Microsoft .Net Framework 3.5 in Windows 10

1. Why do we need to install Microsoft .Net Framework 3.5 in Windows 10?

 The installation of SQL Server 2008 in Windows 10 needs to be
supported by Microsoft .Net Framework 3.5. But Windows 10 itself is
not incorporated with Microsoft .Net Framework 3.5.
 The running of CMSSetting program also needs Microsoft .Net
Framework 3.5 to support. Without Microsoft .Net Framework 3.5,
CMSSetting program is not able to be running in Windows 10 system.
2. How to install Microsoft .Net Framework 3.5 in Windows 10?
We can use an installation-free program named Dism Tool

to install Microsoft .Net Framework 3.5 in Windows 10:

Double click program to open the following window:

Click “Apps and Features” in the left side and then select “Features” tab:

41
 CMS Installation & Setup Manual

Scroll down till you find “.Net Framework 3.5” in the features’ list:

Check the boxes of .Net Framework 3.5 as shown above and then click
“Apply”, it starts installation process:

42
 CMS Installation & Setup Manual

Once the process completes, close the window.

To check if .Net Framework 3.5 is installed properly, open “Control Panel” 

“Programs”  “Turn Windows Features on or off”:

43
 CMS Installation & Setup Manual

If “Microsoft .NET Framework 3.5” in Windows Feature window has been

ticked as shown above, that means it is installed properly.

44