[latest and detailed] SQL Server 2019 installation tutorial

Introduction: today, we are working on a new computer environment, which is very important for me Net programmer, it must be inseparable from the installation of SQL server. I didn’t find a very detailed tutorial on the Internet, so I decided to write another one myself. Let’s go directly to the topic.

Download SQL server engine at: https://www.microsoft.com/en-us/sql-server/sql-server-downloads , clickdownload

Just download the developer version.
When the download is complete, double-click to open it.
Select basic to install.
Click accept.
You can reselect “installation location” and click “installation”. (I’m here)C:\Program Files\Microsoft SQL ServerInstallation address (for example)
After the installation of ssei is completed, click “install SSMS” and download the sqlserver 2019 management tool first. After the installation of ssei, you need to install SSMS.
Download SSMS.
findC:\Program Files\Microsoft SQL Server\Developer_CHSDirectorySETUP.exe, double-click run.
(this path is the installation directory of ssei. If you need to change the installation address, open it according to the installation address)
After opening, select “Install” and click “new SQL server independent installation or add functions to existing installation”.
Click next.
Click “next”, (the windows firewall warning here has no effect).
Select “execute a new installation of SQL Server 2019” and click “next”.
Click next.
Check “I accept the license terms and (a)” and continue to click “next”.
Check the following options and click “next”.
[Database Engine Service]
[SQL Server Replication]
[client connection tool]
【Integration Services】
[client tool SDK]
[SQL client connection SDK]
You can use the default instance or name the instance yourself. Click next.
Click “next” directly.
After following the steps in the picture, click “next”.
1 use mixed mode.
2 enter the password, which is the password of the user SA.
3 add the current user.
Finally, click “Install”.
When this information is displayed, it means that the installation is completed. Click “close”. Next, install the SSMS management tool.
Open in advance7Step download the installation package and double-click to run it.
Click Install. (you can change the installation location or use the default installation location)

Wait for the installation to complete.
After installation, click “close”.
Double click to open SQL Server management tools.

Log in using Windows authentication first. (the password of SA user can be modified after logging in)
Extension problem: login failure, prompt “the system cannot find the specified file”。
Open the service list and openWIN+R, enterservices.mscEnter the service list.
Found SQL Server (MSSqlServer).
Right click “start”, wait until the start is completed, and return to the SQL Server management tool to log in.
Complete the login and you’re done.

The abstractmethoderror reported by springcloud Alibaba is caused by a version compatibility problem

When integrating Nacos, when using feignclient to request the interface, it will report abstractmethoderror. The first reaction is that this must be a version compatibility problem, but it also took a long time to solve the version compatibility. Try various versions The error is as follows: Caused by: java.lang.AbstractMethodError: org.springframework.cloud.netflix.ribbon.RibbonLoadBalancerClient.choose(Ljava/lang/String;Lorg/springframework/cloud/client/loadbalancer/Request;)Lorg/springframework/cloud/client/ServiceInstance; at org.springframework.cloud.openfeign.loadbalancer.FeignBlockingLoadBalancerClient.execute(FeignBlockingLoadBalancerClient.java:88) ~[spring-cloud-openfeign-core-3.0.3.jar:3.0.3] at feign.SynchronousMethodHandler.executeAndDecode(SynchronousMethodHandler.java:119) […]

[latest and detailed] SQL Server 2019 installation tutorial

[latest and detailed] SQL Server 2019 installation tutorial

Recommended Today

The abstractmethoderror reported by springcloud Alibaba is caused by a version compatibility problem