Shulou(Shulou.com)05/31 Report--

This article is about the sample analysis of download, installation, and configuration in SQL Server 2017 Developer. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

download

Download Portal: SQL Server download

It may take a little longer to get into the page. If there is no FQ, please wait a while. After loading the page, find the Developer above and download it immediately, and then wait for the installation package to download.

Installation

① finds the SQLServer2017-SSEI-Dev.exe file that has just been downloaded and click run. After a while, the following interface appears, and you can choose [basic] as the installation type.

② language selection [Chinese (simplified)]

③ chooses the right location that he wants to install

④ then begins the somewhat lengthy process of downloading and installing packages.

⑤ successfully completed installation! Don't rush to shut down at this time, click [install SSMS] to download SQL Server Management Studio (SSMS) 1 on the official website.

Don't be idle when downloading ⑥ in SSMS. Let's configure the newly installed SQL Server 2017, find the newly installed [Microsoft SQL Server 2017], and open [SQL Server 2017 configuration Manager].

⑦ will enable [TCP/IP]

⑧ runs the downloaded SSMS-Setup-CHS.exe installation (this installation process is relatively routine, so there is no need to introduce ~) when you come to the interface of the following figure, click "restart". After the computer is rebooted, the SSMS installation is completed.

Modify server authentication

① finds [Microsoft SQL Server Tools 18] and opens [Microsoft SQL Server Management Studio 18]

② select "Database engine" as shown in the figure, and select your own computer name for the server name. The verification method is [Windows Authentication].

③ right-click the root directory and select [Properties]

④, click the left side to select the page "Security", change the server authentication to "SQL Server and Windows Authentication modes", then click "Connect" on the left, check "allow remote connection to this server", and click "OK" to save the changes.

Note: you need to restart the settings just set by SQL Server to take effect (this affects whether you can log in normally with the sa user name later) to open the [SQL Server 2017 configuration Manager], as shown in the following figure, restart SQL Server, and then reopen SSMS to log in and do the following.

Change login configuration

Expand ① to the left directory [Security]-> [Login name], right-click [sa], and click "Properties"

Set the password you want to set in the ② selection page "General", then select "status", select "Grant" to connect to the database engine, select "enable" for login name, and click "OK" to save the settings.

Then you can connect to the database with the login name sa. When you connect to the database remotely, enter the IP address of the database (that is, you can use either the computer name or IP address of the computer on which the database is installed), select [SQL Server Authentication], enter the login name sa, fill in the login name you just set, sa login password, and bingo~.

Ahem, if you log in to the local database server, the server name can be filled in: computer name, IP, localhost, English symbol a dot. (if you log in locally, it is recommended to enter a point to log in, which is very convenient.)

Thank you for reading! This is the end of this article on "sample analysis of download, installation and configuration in SQL Server 2017 Developer". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

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.