The preparatory work

Operating system: Windows Server 2019 Standard edition

Download the SQL Server 2016 installation file

Download SQL Managerment Studio

Start the installation

Double-click setup.ext to start the SQL Server installation center

Select Install, and then select a new SQL Server standalone installation or add functionality to an existing installation on the right

In the installation dialog box that is displayed, select the version you want to install. In this example, select Express

Click Next, check I accept the license terms and click Next

Check whether to use Microsoft Update to check for updates (recommended). Go to the next step

Go to the product update step, keep the default, and then click Next

Wait for setup file to complete installation

The Installation rules step will check some items, if not pass can not proceed to the next step, then click next

Feature selection

Select Database Engine Services -SQL Server Replication, Sharing Functions – Client tool Connection, SQL client connection SDK, keep the default directory, then click Next.

The instance configuration

Specify the name and instance ID of the SQL Server instance. The directory structure, registry structure, and service name all copy the instance name and the specific instance ID. The instance ID will become part of the installation path.

Enter the instance name in the named instance and the instance ID in the instance ID. Retain the default value. If there is an existing instance, do not duplicate the instance name.

Then click Next.

Go to server configuration and set service accounts and collation rules. Microsoft recommends that you use a separate account for each SQL Server service. Select SQL Server database engine and SQL Server Browser type bit automatically. You can choose the startup type of AQL Server Browser based on your requirements.

And then click next

Database Engine Configuration

Specify the authentication mode and administrator for the database engine

By default, the administrator name for MS SQL is SA

Select mixed authentication modes (SQL Server authentication and Windows authentication) and set a password

Click Add Current User in the specified SQL Server administrator area to add the current user to the SQL Server administrator

Then click Next, you can see an installation and configuration list. If you need to modify it, you can click the previous step to modify it, and click Install to install it after confirming it is correct.

Waiting for installation to complete

To complete the installation, click Close to exit the wizard

Enabling Port Listening

Open the SQL Server 2016 Configuration Manager

Open SQL Server Network Configuration –>SQLEXPRESS, right-click TCP/IP on the right, and select Properties

On the IP address TAB of the TCP/IP Properties dialog box, set the TCP Port Port to 1433, and then click Apply.

Then right-click to enable TCP/IP

Install and configure SQL Management Studio

Open the installation program for SQL Server Managerment Studio

Set the installation directory as required, then click Install

Waiting for installation to complete

When the installation is complete and the message is to restart, we click Restart

Start the SSMS tool

Enter administrator credentials to log in to SQL Server and click Connect

Right-click on the instance, then select Facets

In general, the aspect selects the Peripheral Application configurator, finds the XPCmdShellEnabled property, sets it to True, and clicks OK

A new user

Right-click on Security logins and select New Logins

Set the login name, set the password, set the database, and click OK

SQL clients connect to SQL Server

HeidiSQL is a free open source database management tool for MySQL and its offsprings, as well as Microsoft SQL Server and PostgreSQL.

Download address: www.heidisql.com/download.ph…

Open heidisQL and create a new connection

Select SQL Server TCP/IP, enter the Server IP address, user name, and password, and click Open


If the connection fails, run the powershell command on the server to release port 1433

New-NetFirewallRule -DisplayName "SQLServer default instance" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow
New-NetFirewallRule -DisplayName "SQLServer Browser service" -Direction Inbound -LocalPort 1434 -Protocol UDP -Action Allow
Copy the code
About Hetian Net Safety Laboratory

He Tian network security laboratory www.hetianlab.com- domestic leading practical network security online education platform

Real environment, online practical operation network security;

The experimental content covers: system security, software security, network security, Web security, mobile security, CTF, forensics analysis, penetration testing, network security awareness education and so on.