SQL Server official website download
SQL Server official connection management tool
Since it is an installation package, it is basically the next step, and three main points are paid attention to:
1. Choose three installation paths yourself.
Required options for function selection during installation
SQL ServerCopy ✔1
Data Quality Client - Optional (It is recommended that the server add this to analyze data usage)
Client Tools Connection ✔2
Backward compatibility of client tools ✔3
Client Tools SDK ✔4
Management Tools-Basic (+Management Tools-Full) — Optional (SSMS、SQLCommand Line Tools(SQLCMD) etc. – If there is no SSMS installed independently under sqlserver2016, this must be selected)
SQL Client Connection SDK ✔5
Master Data Services - Optional (It is recommended that the server add this to analyze data usage)
3. Since the 2014 version, Microsoft SQL Server Management Studio has not been provided, so you need to download it yourself.
Replenish:
1. After some versions are installed, you can only use localhost, not 127.0.0.1. Open SQL server configuration manager and start TCP/IP.
2. The service startup can be set to manual and then turned on when needed. What services can be required to enable them.
SQL ServerDatabase Engine (MSSQLServer Service, data service cannot be provided without opening)
SQL Server Agent(SQLServerAgent service cannot be provided without opening it. It can be automatically run, timed jobs, or some maintenance plans, such as timed database backup and other operations)
SQL Server Reporting Services(MSSQLSERVER) is a report service and generally does not need to be enabled unless you make a report, through thisComponentsTo provide report services, you need to enable them.
SQL Server Analysis Services(MSSQLSERVER) is an analysis service and generally does not need to be enabled unless you do multiple analysis, andData Mining, only needs to be turned on.
SQL Full-text Filter Daemon Launcher(MSSQLSERVER) is a full-text search service. If you do not use full-text search technology, you do not need to enable it.
SQL Server VSS WriterProvided for passingWindowsVSS infrastructure backup/restore The interface of Microsoft SQL Server is used when backing up and restoring SQL Server databases using Windows' shadow replication. This function cannot be used for ordinary users.
SQL Server CEIP Services(MSSQLSERVER) service is a customer experience improvement program that sends telemetry data back to Microsoft and is generally not enabled.