The purpose of this series of posts is to explore and use Workspace ONE AirLift into a Lab environment to migrate devices, applications, and policies (GPOs) from ConfigMgr and Active Directory Domain Services (ADDS) to Modern Management with Workspace ONE.

Table of Content:

Part 1 - AirLift Introduction and Diagram Overview. [Click here]
Part 2 - Servers and Computer Global Configuration. [Click here]
Part 3 - Active Directory Configuration and Domain Join. [Click here]
Part 4 - Hard Disks Configuration and prerequisite Sources Preparation. [Click here]
Part 5 - Roles and Features Installation. SPN Creation. [Click here]
Part 6 - SQL Server, SSRS and SSMS Installation. [You are Here]
Part 7 - WSUS Installation and Configuration. ADK And WinPE Installation. [Coming Soon !]
Part 8 - ConfigMgr prerequsisites: System Management Container creation, AD Schema Extension and Database Creation. [Coming Soon !]
Part 9 - Installation, Overview and Update of ConfigMgr. [Coming Soon !]
Part 10 - ConfigMgr Configuration: Discovery methods Activation, Boundaries creation, Software Center personalization, VLC app configuration. [Coming Soon !]
Part 11 - Airlift Installation, Configuration and Overview. [Coming Soon !]

1 - SQL Server Installation

The following manipulation have to be done on MOB-SRV-MECM-01 Server.

1. Open File Explorer.
2. Navigate to Sources folder.
3. Mount SQLServer2019-x64-ENU.iso file.
4. Execute setup.exe file.

On SQL Server Installation Center window:
5. Click on Installation menu.
6. Click on New SQL Server stand-alone installation or add features to an existing installation.

1.1 - Product Key Step

1. Leave default selection.
2. Click on Next >.

1.2 - License Terms Step

1. Check I accept the license terms and Privacy Statement.
2. Click on Next >.

1.3 - Microsoft Update Step

1. Check Use Microsoft update to check for updates (recommended).
2. Click on Next >.

1.4 - Install Rules Step

1. Verify that you have no operation generated a Fail.
2. Windows Firewall generated a Warning but no problem with that as we opened the appropriate ports to enable remote access.
3. Click on Next >.

1.5 - Feature Selection Step

1. Check Database Engine Services.
2. Click on Next >.

1.6 - Instance Configuration Step

1. Leave default values.
2. Click on Next >.

1.7 - Server Configuration Step

1. Modify the Account Name For SQL Server Agent Service.
2. Click on Account Name cell then select << Browse...>>.

3. Enter SVC_SQL User.
4. Validate by clicking on Check Names.
5. Click on OK.

6. On Password column, enter SVC_SQL Password.

7. On Startup Type column, select Automatic.

8. Proceed to the same modifications for SQL Server Database Engine Service.

9. Click on Collation tab.
10. Click on Customize...
11. Select SQL collation, used for backwards compatibility.
12. Select SQL_LATIN1_GENERAL_CP1_CI_AS.
13. Click on OK.

Why SQL_LATIN1_GENERAL_CP1_CI_AS as value for the SQL collation?
This is a Microsoft requirement:

14. Click on Next >.

1.8 - Database Engine Configuration Step

1. Under Server Configuration tab, click on Add Current User.

2. Click on Add...
3. Enter SVC_SQL.
4. Verify the User by clicking Check Names.
5. Click on OK.

6. Click on TempDB tab.
7. Click on Remove to remove the current Data Directory.

8. Add a new Data directory by clicking on Add...
9. Select MECM_TempDB (E:) Drive.
10. Select DB folder.
11. Click on OK.

12. Next to TempDB data files > Number of files, select 4.
13. Next to TempDB data files > Autogrowth (MB), select 256.
14. Next to TempDB log file > Autogrowth (MB), select 256.

The above values have been adapted regarding SQL recommendations for MECM - White Paper v2.6.pdf.

15. Click on Next >.

1.9 - Ready to Install Step

1. Click on Install.

1.10 - Complete Step

1. Once installion completed successfully, click on Close.

2. Close SQL Server Installation Center window.

2 - SQL Server Reporting Services (SSRS) Installation

The following manipulation have to be done on MOB-SRV-MECM-01 Server.

1. Open File Explorer.
2. Navigate to Sources folder.
3. Execute SQLServerReportingServices.exe.
4. Click on Install Reporting Services.

5. Select Choose a free edition.
6. Click on Next >.

7. Click I accept the license terms.
8. Click on Next >.

9. Leave default value.
10. Click on Next >.

11. Leave default Install Location.
12. Click on Install.

13. Once Setup completed, click on Close.
14. Restart MOB-SRV-MECM-01 Server.

3 - SQL Server Management Studio (SSMS) Installation

The following manipulation have to be done on MOB-SRV-MECM-01 Server.

1. Open File Explorer.
2. Navigate to Sources folder.
3. Execute SSMS-Setup-ENU.exe.
4. Leave default values.
5. click on Install.

6. Once Setup Completed, click on Close.
7. Restart MOB-SRV-MECM-01 Server.

8. Pin Microsoft SQL Server Management Studio to the Taskbar.

4 - SQL Server Update Memory Allocation

The following manipulation have to be done on MOB-SRV-MECM-01 Server.

1. Open SQL Server Management Studio.
2. From Connect to Server window, leave default values.
3. Click on Connect.

4. Under Object Explorer, right click on MOB-SRV-MECM-01
5. Click on Properties.

6. Select Memory page.
7. Under Server memory options > Maximum server memory (in MB) enter 3072 which is 3GB converted into MB.
8. Click on OK.

The above modification is part of Microsoft recommendation:

9. Close Microsoft SQL Server Management Studio window.

5 - Update Architecture Diagram

Regarding modifications, here is the updated Architecture Diagram:

6 - Conclusion

This is the end of the Part 6 for this series of posts. In this post we have done the following manipulations:

• Installation of SQL Server.
• Installation of SSRS.
• Installation of SSMS.

See you in Part 7 to continue the configuration.