U2000V100R006C02SPC301 Installation Introduction_Part 2

2023年 4月 13日
Posted by Thunder-linkadmin

In U2000V100R006C02SPC301 Installation Introduction _Part 1, we mainly introduced the SQL Server 2008 installation. In this article, we will introduce how to install the SQL 2008 SP1 and U2000.

1. Install SP1 patches

1.1 Reason for installation: assume the database installed above, can’t meet the requirement of U2000, then need to install a specified version.

After installation completed, the database version is 10.0.5500.0.

U2000 required the database version is 10.0.2531, you need to download the following patches from the Internet.

The installation process does not require specific settings, just click Next and select all options.

When the SP1 patches are installed, the version information is as follows:

Tips?

The Chinese SQL 2008 must install Chinese version SP1.

The English SQL 2008 must install English version SP1.

1.2. Check whether the database is successfully installed

The U2000 won’t be installed normally, if the database does not run normally, or the password doesn’t meet the demands, or the version is wrong.

Inspection method: Use SA to check if the database server can be login normally, and check whether the service is enabled, at the same time, if there is responds from the port 1433 of system.

As shown in the figure, after installation, use the tcping command to detect the 1433 port, there will be no response. When the 1433 port problem is solved, port open will appear.

Reasons for the problem:

a. By default, all services are not enabled.

b. Port 1433 is not enabled

c. The IP address of the network card cannot be changed and needs to be fixed.

After the IP address is fixed, if port 1433 cannot be enabled, proceed as follows:

Enter SQL Server Configure Manager, select SQL Server Services, and confirm the services on the right side (except Browser) are in the Running state.

Also confirm that the TCP/IP protocol under Protocols for MSSQLSERVER is enabled.

In the TCP/IP Properties-IP Addresses, please confirm the parameter of IP Address and TCP Port are set correctly. The IP address needs to be set according to the actual situation.

After the setting is completed, you will be asked to restart the service. After restarting the service, check if the 1433 port is enabled and able to respond to the data status.

1.3 Uninstall SQL Server 2008 when in abnormal state

Uninstall SQL Server 2008:

(1) Click “Start” > Control Panel > Uninstall Program”, then display “Uninstall or Change the Program” page.

(2) Right-click “Microsoft SQL Server 2008 (64-bit)”, and select “delete”

Tips:

During uninstall, the status of restarting the computer may show as failed, please delete “PendingFileRenameOperations”

(3) Complete rest of the operations according to the prompt message.

(4) After uninstalling “Microsoft SQL Server 2008 (64-bit)”, return to the “Uninstall or Change the Program” page, refresh, then delete the remaining SQL Server program.

Tips:

Please check if the following installation directory and registry information have been automatically deleted. If it still exists, please refer to the following steps

(5) Deleted the “MSSQL2008”, “MSSQL2005X”, “MSSQL2008T” and “MSDATA’, which is under the database installation directory

(6) Deleted the “Microsoft SQL Server” under the “Program files”.

(7) Deleted the “Microsoft SQL Server’ and “Microsoft SQL Server Compact Edition” under the “Program files?x86)”.

(8) Click “Start” > “All procedure” to confirm the “Microsoft SQL Server 2008” has been deleted, otherwise, you must right-click the “Microsoft SQL Server 2008” to delete.

(9) Click “Start” > “Movement”, type in regedit command, and delete the following registry information in the registry editor.

a. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

b. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

c. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2005 Redist

d. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server 2008 Redist

e. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Native Client 10.0

f. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services \MSSQLSERVER

g. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\SQLSERVERAGENT

h. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLServerADHelper

i. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLServerADHelper100

j. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations

k. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSDTC

l. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents

m. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\setup.exe\RunAsOnNonAdminInstall

n. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\setup.exe\BlockOnTSNonInstallMode

o. HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INT\DBSVR

2.Install U2000 Software

2.1 Software preparation

Decompress all installation packages into the same directory.

2.2 Installation and configuration process

(1) Double-click the install.bat file in the installation package path.

(2) Enter the installation process

(3) License Agreement

(4) Select operation language of U2000 software

(5) Set installation Scheme

(6) Set installation Mode

(7) Select component

(8) Configure Server

NOTE:

You need to modify the installed IP Address, and set the IP address of installation database. After installation, you cannot modify during operation.

(9) Confirm to create the catalog

(10) Select deployment parameters

(11) Select the location-appropriate software style

(12) Version slot mode

(13) Verify the database

The following table lists parameters for the database U2000 user and the database server.

Parameter	Settings
Database Installation Path	The default installation path of the database is C:\MSSQL2008. NOTE: The default installation path is C:\MSSQL2000 in the Windows 2003.
Data File Path	Specifies the path for storing data files. The default installation path is D:\data. CAUTION: Please click Browse and change the data file save path. To meet space requirements for long-term running, changing this path to a path on another partition (especially the partition with the largest remaining space) by referring to the disk partition planning before installation is recommended. Ensure that the disk for saving data files is not a compact disk. If the disk is a compact disk, creating a instance database will fail.
DB Super Password	The database superuser password must meet the following requirements: The password contains a minimum of eight characters and a maximum of 30 characters. The password must contain at least four of the following combinations: At least one lower-case letter At least one upper-case letter At least one digit At least one special character ~@#^*()-_+\|[{}]:./? The special characters that are not supported include at least <>&`!$\”%’=;,space. Do not include these special characters in passwords. The password cannot be the same as the user name written in either the forward or backward format. The default value is Changeme_123. CAUTION: If the database has been installed, enter the password for user sa that is set during database installation. If you forget the password or the password for user sa does not meet the requirements, change the password.
Confirm DB Super Password	Confirms the password for user sa. If the database has been installed, you do not need to enter the password again.
DB User Password	The NMS database user password must contain the following requirements: The password contains a minimum of eight characters and a maximum of 30 characters. The password must contain at least four of the following combinations: At least one lower-case letter At least one upper-case letter At least one digit At least one special character ~@#^*()-_+\|[{}]:./? The special characters that are not supported include at least <>&`!$\”%’=;,space. Do not include these special characters in passwords. The password cannot be the same as the user name written in either the forward or backward format. The default value is Changeme_123.
Confirm DB User Password	Confirms the DB user password.

(14) Installation process

In the installation process, the progress of each child process and the total process will be displayed.

NOTE:

The process will take a long time.

(15) Installation complete

NOTE:

a. Note the combination of the U2000V100R006 software and other software

b. Pay attention to the installation order of each software

c. When deleting the SQL database, delete it cleanly.

Through articles U2000V100R006C02SPC301 Installation Introduction_Part 1 and U2000V100R006C02SPC301 Installation Introduction_Part 2, I hope you can master how to install U2000. Regarding U2000V100R006C02SPC301 acquisition and more questions, please contact us at Sales@Thunder-link.com