In this how-to guide, we learn how to download and install SQL vps 2019 step by step. We will download the SQL hệ thống developer edition / SQL hệ thống Express edition & show you how to install it. The guide uses the Windows 10 OS. But you can install it in other editions of windows. The các mục of Supported OS, Hardware and software requirements are listed below


Table of Contents

Hardware và Software RequirementsInstall SQL hệ thống 2019SQL vps Installation CenterFeatures SelectionDatabase Engine Configuration

Download SQL hệ thống 2019

SQL server 2019 is available in five different editions.

Bạn đang xem: Hướng Dẫn Tải Sql Server 2019 Cực Kì Đơn Giản Và Chi Tiết

Developer EditionExpress EditionEnterprise EditionStandard EditionWeb Edition

If you are a developer và intended to lớn use it to lớn learn/develop/test a database application, then you should use the developer edition.

If you are an end-user và intended to use the SQL hệ thống in a production environment and size of your database is less than 10GB, then you can use the express edition.

For all other scenarios, you can use the Trial Version of Enterprise/Standard. To download the trial version, you need khổng lồ provide your name, address và company details, etc

Click on tải về link to download the files

EditionDownload LinkRemarks
SQL server 2019 Enterprise/StandardDownloadRegistration Required
SQL hệ thống 2019 Developer EditionDownload
SQL server 2019 Express EditionDownload

You can also tải về from the from the links https://www.microsoft.com/en-us/sql-server/sql-server-downloads and scroll down lớn select developer or express edition.


*
Download SQL vps 2019

Hardware và Software Requirements

Before downloading, you should know the software/hardware/OS requirement of the SQL hệ thống 2019

Hardware

Hard disk space: Minimum 6 GB of available hard-disk space.Monitor: Super-VGA 800X600 ResolutionMemory: 1 GBProcessor Speed: x64 Processor: 2.0 GHzProcessor Type: x64 Processor, AMD Athlon 64, hãng intel Xeon EM64TT, Pentium 4 with EM64T

Software

NET Framework 4.6 download link

OS Supported

Developer/Express/Standard Edition: Windows 10 Home/Professional/Enterprise, Windows Server năm 2016 / 2019 DataCenter, Standard & EssentialsEnterprise/Web Edition: Windows Server năm 2016 / 2019 DataCenter, Standard và Essentials

Install SQL hệ thống 2019

Download the SQL server from the above link. The following files are downloaded. We choose the developer edition for this tutorial.

SQL2019-SSEI-Expr.exe: Express EditionSQL2019-SSEI-Dev.exe: Developer Edition

Double click on the downloaded tệp tin to start installing SQL vps 2019.

Select an Installation Type

Here, you have three choices.

BasicCustomDownload Media

Basic option installs only the essential features of SQL Server. It only asks for the License agreement and installation path

Download truyền thông allows you to tải về all the installation to a local folder. You can then unzip and run the cài đặt and install the SQL vps without needing an internet connection

The custom option allows you to lớn pick and choose the features we wish to install. For this tutorial, let us choose the custom option.

Double click on Custom


*
Select an Installation Type

Select the truyền thông media download target location. You can use the downloaded files khổng lồ install the SQL hệ thống later.


*
Specify SQL Server media download target location

This will download the install package. The install package automatically starts the SQL server installation center


*
Downloading Installation Package

SQL vps Installation Center

Select Installation & then click on “New SQL server standalone installation or features khổng lồ an existing instance” to lớn begin the installation


*
SQL hệ thống Installation Center

Global Rules

The next window identifies & displays the problems that may occur while installing the SQL server cài đặt support files.

If there is any issue those will be highlighted in red here. The installation will not continue & you will have khổng lồ take necessary action depending on the issue.

Click next khổng lồ continue


*
Installation Global Rules

Microsoft Update

Choose yes, if you wish to lớn the installer to kiểm tra Microsoft update site and download and install the latest updates. Else leave it


*
Microsoft Update

Install Rules

Next, the installer checks for the potential problems that may occur, while running the setup. If any of the rules fail, then you must correct them first. Otherwise, the installer will not continue.


*
Install Rules

Product Key

Enter the product Key, if you have one. You can choose the miễn phí Edition lượt thích Developer/Express or Evaluation.


*
SQL Server product Key

License Terms

Accept the License Terms.


*
License Terms

Features Selection

This window displays several features that you install along with the SQL Server.

Instance Features

Data Engine Services: This is the core database engine or database itself. This must be selected

SQL hệ thống Replication: The SQL vps Replication includes a mix of technologies for creating an exact replica of the database from one database lớn another. It also synchronizes the database for consistency.

Machine Learning Services (In-Database) ( R và Python): Includes extensions that enable integration with R & Python languages using standard T-SQL statements.

Full Text and semantic Extractions for search: Includes a tìm kiếm engine that supports Full-Text Extraction for fast text search as well as Semantic Extraction for keyphrases (likely tags) & similarity tìm kiếm on nội dung stored in SQL Server.

Data quality Services: Includes Data chất lượng database objects.

Polybase Query Service for external data: Includes PolyBase giải pháp công nghệ that enables truly integrated querying across Hadoop non-relational data and SQL server relational data using standard T-SQL statements.

if you select khổng lồ install PolyBase, the thiết lập will ask for the Oracle JRE. You can obtain the JRE installer from https://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html

Analysis Services: Includes Analysis Services and tools used to tư vấn online analytical processing (OLAP) and data mining. Only Database Engine Services & Analysis Services can be clustered.

Shared Features

Machine Learning vps (Standalone) R và python: Includes Microsoft Machine Learning hệ thống for Windows that provides parallelized big data analysis, transformation, modeling & operationalization capabilities.

Xem thêm: Top 5 Phần Mềm Theo Dõi Máy Tính Người Khác, Top 12 Phần Mềm Theo Dõi Máy Tính Tốt Nhất 2022

Data quality Client: Includes Data chất lượng client objects.

Client Tools Connectivity: Includes components for communication between clients và servers.

Integration Services: Includes the designer, runtime, và utilities that enable Integration Services khổng lồ move, integrate, và transform data between data stores.

Client Tools backward compatibility: Client Tools for Backwards Compatibility for older versions

Client Tools SDK: Includes the software development kit containing resources for programmers.

Distributed trả lời controller: Includes the Distributed trả lời Controller which orchestrates the actions of the distributed replay clients.

Distributed trả lời client: Includes the Distributed replay Client. Multiple Distributed replay Clients work together khổng lồ simulate a workload against an instance of SQL Server.

SQL Client Connectivity SDK: SQL Client Connectivity SDK will install SQL hệ thống OLEDB and ODBC connectors that can be used lớn connect lớn SQL server using.NET, Java, PHP or other programming languages. Includes SQL hệ thống Native Client (ODBC / OLE DB) SDK for database application development.

Master Data Services: Includes Master Data Services, the platform for integrating data from disparate systems across an organization into a single source of master data for accuracy and auditing purposes. Installs the Master Data Services Configuration Manager, assemblies, PowerShell snap-in, và folders và files for web applications & services.

Select the following

Database Engine ServicesClient Tools ConnectivityClient Tools for backward compatibility SQL Client Connectivity SDKClient Tools SDK
*

Instance Configuration

You can have multiple instances of the SQL hệ thống running in the system. Each must have its own instance name

You can have one default instance. The default instance name is MSSQLSERVER. If you choose this, then you can then use your computer name (or IP address) to connect to lớn that instance

All other instances must be named. You can then use name / to lớn connect khổng lồ that instance.

Choose the mặc định instance.


*
Instance Configuration – default Instance
*
Instance Configuration – Named Instance

Read More: What is an SQL vps Instance

Server Configuration

The Next window các mục the various services, which you can configure. This các mục of services displayed here depends on the Features selected.

Here, you need khổng lồ specify the trương mục Name, Password & startup type for each service.

Keep the defaults and click on Next


*
Server Configuration

Database Engine Configuration

Here you are asked to configure the database by providing the authentication mode và password for the SA user.

Under Authentication Mode, you have two options.

Windows Authentication

In this mode, the windows user is automatically recognized by SQL Server. The Windows security identifier (SID) is passed from Windows lớn SQL Server. The SQL vps does not store any user information & trusts the Windows user. The SA user gets disabled when you use this

Mixed Mode ( Windows Authentication and SQL server authentication Mode)

In this mode, along with the Windows Users, the SQL hệ thống also stores the user name và password in the database. In this scenario, you can connect to SQL vps either using the Windows account & using the user name/password stored in SQL server itself

Choose Mixed Mode.

You have lớn enter the SA user password.

Also, click on add Current User to showroom the Current Logged in User to SQL Server


*
Database Engine Configuration Authentication Mode

Other Configuration

Depending on the Features that you have selected, you will be presented with the configuration option for each feature.

Ready lớn Install

Finally, once all the configurations are done, you will be presented with a summary of the configuration you have selected. If you wish lớn change any of the configuration, you can click the back button và update.

Click on Install lớn begin the installation


Installation Progress

The installation will take some time.

*
SQL hệ thống 2019 Installation Progress

Installation Complete

Once the installation is complete, you will see the following window.

If there are any errors in installation, you can xuất hiện the installation log tệp tin to find out what went wrong.

Click on close to continue. Close the SQL server Installation Center also

You may be asked to lớn restart the computer.

*
Sql hệ thống 2019 Installation Complete

Next Steps

You need lớn install SQL server Management Studio to lớn access & manage the SQL hệ thống Installation. It is available as a separate package