[latest and detailed] SQL Server 2019 installation tutorial

Time:2022-5-3

[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.

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

    Just download the developer version.
    [latest and detailed] SQL Server 2019 installation tutorial

  2. When the download is complete, double-click to open it.
    [latest and detailed] SQL Server 2019 installation tutorial

  3. Select basic to install.
    [latest and detailed] SQL Server 2019 installation tutorial

  4. Click accept.
    [latest and detailed] SQL Server 2019 installation tutorial

  5. You can reselect “installation location” and click “installation”. (I’m here)C:\Program Files\Microsoft SQL ServerInstallation address (for example)
    [latest and detailed] SQL Server 2019 installation tutorial

  6. 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.
    [latest and detailed] SQL Server 2019 installation tutorial

  7. Download SSMS.
    [latest and detailed] SQL Server 2019 installation tutorial

  8. 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)
    [latest and detailed] SQL Server 2019 installation tutorial

  9. After opening, select “Install” and click “new SQL server independent installation or add functions to existing installation”.
    [latest and detailed] SQL Server 2019 installation tutorial

  10. Click next.
    [latest and detailed] SQL Server 2019 installation tutorial

  11. Click “next”, (the windows firewall warning here has no effect).
    [latest and detailed] SQL Server 2019 installation tutorial

  12. Select “execute a new installation of SQL Server 2019” and click “next”.
    [latest and detailed] SQL Server 2019 installation tutorial

  13. Click next.
    [latest and detailed] SQL Server 2019 installation tutorial

  14. Check “I accept the license terms and (a)” and continue to click “next”.
    [latest and detailed] SQL Server 2019 installation tutorial

  15. 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]
    [latest and detailed] SQL Server 2019 installation tutorial

  16. You can use the default instance or name the instance yourself. Click next.
    [latest and detailed] SQL Server 2019 installation tutorial

  17. Click “next” directly.
    [latest and detailed] SQL Server 2019 installation tutorial

  18. 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.
    [latest and detailed] SQL Server 2019 installation tutorial

  19. Finally, click “Install”.
    [latest and detailed] SQL Server 2019 installation tutorial

  20. When this information is displayed, it means that the installation is completed. Click “close”. Next, install the SSMS management tool.
    [latest and detailed] SQL Server 2019 installation tutorial

  21. Open in advance7Step download the installation package and double-click to run it.
    [latest and detailed] SQL Server 2019 installation tutorial

  22. Click Install. (you can change the installation location or use the default installation location)
    [latest and detailed] SQL Server 2019 installation tutorial
    Wait for the installation to complete.
    [latest and detailed] SQL Server 2019 installation tutorial

  23. After installation, click “close”.
    [latest and detailed] SQL Server 2019 installation tutorial

  24. Double click to open SQL Server management tools.
    [latest and detailed] SQL Server 2019 installation tutorial
    Log in using Windows authentication first. (the password of SA user can be modified after logging in)
    [latest and detailed] SQL Server 2019 installation tutorial

  25. Extension problem: login failure, prompt “the system cannot find the specified file”
    [latest and detailed] SQL Server 2019 installation tutorial

  26. Open the service list and openWIN+R, enterservices.mscEnter the service list.
    [latest and detailed] SQL Server 2019 installation tutorial

  27. Found SQL Server (MSSqlServer).
    [latest and detailed] SQL Server 2019 installation tutorial

  28. Right click “start”, wait until the start is completed, and return to the SQL Server management tool to log in.
    [latest and detailed] SQL Server 2019 installation tutorial

  29. Complete the login and you’re done.
    [latest and detailed] SQL Server 2019 installation tutorial

Recommended Today

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) […]