Shulou(Shulou.com)06/01 Report--

In today's life, there is data everywhere. A small APP software on our mobile phone may be supported by dozens of servers behind him. There is data on the server, and each software has a background database.

Several commonly used databases are:

SQL server this database is developed by Microsoft and can only be used on the Windows side. It is simple and easy to use.

Developed by oracle Oracle, it is secure and perfect for all mainstream platforms, but its operation is complex.

Developed by DB2 IBM, for all mainstream platforms, suitable for large enterprise environment, safe and perfect

MySQL (Mariadb), acquired by Oracle, is open source, small, fast and stable

SQL server database is divided into two types: system database and user database, among which there are four system databases:

Hardware requirements for deploying a SOL server database:

We need to pay attention to the following points when deploying:

1. Enhance physical security (such as fire prevention and waterproofing, etc., cannot be directly connected to intenet)

2. Use firewall ASA

3. Isolation service (it is best not to install it on a server with DC, it is no problem to join a domain and become a domain member)

4. Disable unnecessary protocols, such as NetBios, SMB and other server message blocks

Needless to say, we started to deploy the SQL server database.

Https://pan.baidu.com/s/1tOhc-L-YX0eE7VNkC57mqQ

Extraction code: aduy

This is the development version of SQL CD that I use.

Https://pan.baidu.com/s/1X2nyd5R12clMTknMsqr4Kw

Extraction code: 0rna

The second is the package installation package of the SQL server management tool SSMS

First, we insert the SQL server database installation CD, open it and click execute.

This area is the experimental environment, so I don't choose to update it.

You can choose the functions you need in the function interface.

Configure the password complexity policy to be enabled by default when entering the password of a sa user, so it needs to be a little more complicated.

Just wait for the installation to finish.

After installing the database, we need to install an administrative tool. Here I install SSMS.

After installing the management tools, open the configuration panel. We need to register the server. The function of the registration server is to save the instance connection information, which makes it easier to connect and manage.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.