Installing SQL Server 2019 | |
Download the version of SQL Server that you plan to use on your server.
A database administrator should log on to the server with administrative privileges, right-click on the Setup.EXE file, and choose “Run as Administrator.”
|
|
You may choose a Basic or Custom installation type. (Custom is recommended.) |
|
Select the location where you would like to install SQL Server (using the "Browse" button) and click Install to continue.
The installer will download the packages needed for installation. This may take a few minutes to install.
|
|
In SQL Server’s Installation Center, choose the New SQL Server stand-alone installation or add features to an existing installation option. |
|
If you purchased a SQL Server other than the free Express edition, the Product Key screen will be presented before the License Terms screen. Enter your product key to proceed. | |
On the License Terms screen, review the license agreement and tick the checkbox at the bottom to agree to the terms.
Click Next to proceed. |
|
You can choose to receive automatic updates by checking the box on this screen. This is optional but is recommended by Microsoft.
Click Next to proceed.
|
|
The Install Rules tab will identify problems that might occur when you install SQL Server Setup support files.
If any issues are identified, they will need to be fixed before continuing with the installation.
To avoid a Windows Firewall error, disable the Windows Firewall before installation and enable it again after the installation is complete.
Click Next to proceed.
|
|
On the Feature Selection screen, you may choose the features you would like to install. Not all features here are required for use of SQL Server.
Visit the official Microsoft page to view more information about these individual features:
Click Next to proceed.
|
|
On the Instance Configuration screen, you may specify the name and instance ID for this instance of SQL Server. The instance ID is used to identify installation and registry keys for your instance of SQL Server.
Click Next to proceed.
|
|
If you selected to install Java on the features screen, proceed with installing it and click on Next to continue. |
|
On the Server Configuration screen, you can specify the Service Account and Collation. On the Service Accounts tab, you can specify which SQL Server Services should be running. Here you can also specify the startup type for each of the SQL Services (Manual, Automatic, Disabled, etc.).
Click Next to proceed.
|
|
On the Database Engine Configuration screen, you can specify the authentication mode and administrators for the database engine, data directories, and Filestream.
On the Server Configuration screen, specify an authentication mode. The best practice is to use Mixed Mode (SQL Server and Windows Authentication). You can specify the password for the SQL Server system administrator (SA) account and also specify SQL server administrators.
Click Next to proceed.
|
|
On the Data Directories tab, you can specify the path where user database data and log file will be stored.
You can also specify the path where the TempDB data and log file will be stored. It is always a good practice to store TempDB data and log files on a separate drive in order to improve performance.
On this screen, you can also specify the default directory used to back up your databases.
Click Next to proceed.
|
|
On the Filestream screen, the Filestream feature of SQL Server can be configured. The configuration options are:
2. Enable Filestream for file I/O streaming access.
3. Allow remote clients access to Filestream data.
Click Next to proceed
|
|
If you would like to install Microsoft R, click "Accept."
Click Next to proceed.
|
|
If you would like to install Python, click "Accept."
Click Next to proceed.
|
|
The installation will begin, with progress visible via the progress bar. This may take some time depending on the features you selected to install. |
|
The Complete screen will show all features installed with SQL server. At this point, the installation is complete.
Click "Close" to exit the window.
|
|
Installing SQL Server Management Studio | |
Once SQL Server installation has finished, return to the SQL Server Installation tab and select Install SQL Server Management Tools. |
|
Selecting this option will bring you to the official Microsoft page, where you can download the SQL Server Management Studio (SSMS).
Locate the latest version of SSMS and download it to your server. |
|
Locate the file that was downloaded on your server. The file should be called “SSMS-Setup.”
Right click on the file and select “Run As Administrator.” |
|
Follow the steps in the installation wizard to install SSMS.
You will first need to select where SSMS will be installed. If the default path is acceptable, you may leave it as is. Otherwise, click the "Change" button to change the path.
Click Install. The installation process could take some time. |
|
Once the installation is completed, you will see a "Setup Completed" screen.
SQL Server Management Studio has now been successfully installed on your server. |
|
On your server, locate the SQL Server Management Studio application and open it.
You will be prompted to log in to the SQL Server with the Windows or SQL Server authentication that you created during the installation process. |
|
SQL Server Management Studio is where you will be able to restore and interact with your SQL Server databases.
The installation process is now complete. |
|
