Building MS SQL for Lab

MSSQL-Feature-Image

The following is Network Diagram of the Lab:

If you does not know how to build AD DS, you can view this post “Building AD DS for Lab “.

We also need to create 3 domain account:
1. opr-MSSQL — Service Account for MSSQL
2. mssql-admin — MSSQL administrator account
3. mssql-operator — MSSQL operator account

Feature Selection
1. Database Engine Services
2. SQL Server Replication
3. Full-text and semantic extractions for search
4. Reporting Services-Native
5. Client Tools Connectivity
6. Master Data Services

How to install MSSQL:

Author: Joe Chan