How to Install Microsoft SQL Server 2019 standard edition

      Comments Off on 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

121821 2116 HowtoInstal1 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal2 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal3 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal4 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal5 - How to Install Microsoft SQL Server 2019 standard edition

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.

121821 2116 HowtoInstal6 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal7 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal8 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal9 - How to Install Microsoft SQL Server 2019 standard edition

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.

121821 2116 HowtoInstal10 - How to Install Microsoft SQL Server 2019 standard edition

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.

121821 2116 HowtoInstal11 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal12 - How to Install Microsoft SQL Server 2019 standard edition

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.

121821 2116 HowtoInstal13 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal14 - How to Install Microsoft SQL Server 2019 standard edition

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.

121821 2116 HowtoInstal15 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal16 - How to Install Microsoft SQL Server 2019 standard edition

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

121821 2116 HowtoInstal17 - How to Install Microsoft SQL Server 2019 standard edition

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.

121821 2116 HowtoInstal18 - How to Install Microsoft SQL Server 2019 standard edition

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.

121821 2116 HowtoInstal19 - How to Install Microsoft SQL Server 2019 standard edition

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.

121821 2116 HowtoInstal20 - How to Install Microsoft SQL Server 2019 standard edition

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.

121821 2116 HowtoInstal21 - How to Install Microsoft SQL Server 2019 standard edition

23.On the Ready to Install page, click Install after review settings.

121821 2116 HowtoInstal22 - How to Install Microsoft SQL Server 2019 standard edition

24. After installation, the Complete page provides a link to the summary log file for the installation and other important notes, click Close.

121821 2116 HowtoInstal23 - How to Install Microsoft SQL Server 2019 standard edition

Hope you enjoy this post.

Cary Sun

Twitter: @SifuSun

Web Site: carysun.com

Blog Site: checkyourlogs.net

Blog Site: gooddealmart.com

ca16fbd3199de5f66b829b87082fb970?s=80&d=retro&r=g - How to Install Microsoft SQL Server 2019 standard edition

Author: Cary Sun

Cary Sun is an Principal Consultant, He has a strong background specializing in datacenter and deployment solutions, and has spent over 20 years in the planning, design, and implementation of network technologies and Management and system integration.He hold CISCO CERTIFIED INTERNETWORK EXPERT (CCIE No.4531) from 1997.Cary is also a Microsoft Most Valuable Professional (MVP) and Cisco Champion, He is a published author with serveral titles, include blogs on Checkyourlogs.net, author for many books. Specialties: CCIE /CCNA / MCSE / MCITP / MCTS / MCSA / Solution Expert / CCA
Blog:
http://www.carysun.com http://www.checkyourlogs.net
Twitter:@SifuSun