How to Install Microsoft SQL Server 2019 standard edition

Today, I am going to show you how to step by step to install Microsoft SQL Server 2019 standard edition.

1.Create two domain user accounts as service accounts as follow:

svc_sql2019

svc_sql2019agent

2.create disks as follow:

DB: 100GB NTFS 64K

TEMPDB:20GB NTFS 64K

DBLOGS:50GB NTFS 64K

DBBACKUP:50GB NTFS 50GB 64K

3.Mount the SQL Server installation media, double-click Setup.exe.

4.On the User Account Control page, click Yes.

5.On the SQL Server Installation Center page, select Installation.

6.On the Installation page, select New SQL Server standalone installation or add features to an existing installation.

7.On the Product Key page, select Enter the product key, enter your product key, click Next.

If you don’t have product key yet, select Evaluation.

8.On the License Terms page, select the I accept the license terms and privacy statement, click Next.

9.On the Global Rules page, make sure that there are no rule errors, click Next.

10.On the Microsoft Update page, select Use Microsoft Update to check for updates (recommended), click Next.

11.On the Install Rules page, Setup checks for potential problems that might occur while running Setup. If failures occur, select an item in the Status column for more information. Otherwise, select Next.

12. On the Feature Selection page, select the components for your installation. For example, to install a new instance of SQL Server Database Engine, select Database Engine Services.

13. On the Instance Configuration page, specify whether to install a default instance or a named instance.

14.On the Server Configuration page, select Service Accounts, enter those we created accounts previsouly, select Grant Perform Volume Maintenance Task privilege to SQL Server Database Engine Service.

15. On the Server Configuration page, select Collation, select SQL_Latin1_General_CP1_CI_AS as Database Engine, click Next.

16.On the Database Engine Configuration page, select Server Configuration, select Windows authentication mode as Authentication Mode, click Add Current User as SQL Server administrators, you also can use Add function to add more users as SQL Server administrators, click Next.

17. On the Database Engine Configuration page, select Data Directories, change those directories as follow:

Data root directory: D:\Program Files\Microsoft SQL Server

User database directory: E:\DB

User database log directory: G:\DBLOGS

Backup directory: H:\DBBACKUP

18. On the Database Engine Configuration page, select TempDB, change the Data directories and log directory to F:\TEMPDB.

19. On the Database Engine Configuration page, select MaxDB, this setting determines how many processors a single statement can use during execution. The recommended value is automatically calculated during installation.

20. On the Database Engine Configuration page, select Memory, select Recommended and enter the specify the min server memory and max server memory values that this instance of SQL Server will use after startup, in my case, Min server memory:0 Max server memory:16384. Select Click here to accept the recommended memory configurations for the SQL Server Database Engine.

21. On the Database Engine Configuration page, select Memory, select FILESTREAM, FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary (max) binary large object (BLOB) data as files in the file system. Transact-SQL statements can insert, update, query, search, and back up FILESTREAM data. Microsoft Win32 file-system interfaces provide streaming access to the data, in my case, I will keep the default settings, click Next.

22.On the Feature Configuration Rules page, Setup checks for potential problems that might occur while running Setup. If failures occur, select an item in the Status column for more information. Otherwise, select Next.