45. Secure (HTTPS) DSC Pull Server with SQL Database using a Group Managed Service Account (gMSA)
🔑 Setting Up a Secure Pull Server: Detailed steps to configure a secure DSC pull server using HTTPS and SQL authentication.
📋 Prerequisites for Setup: Explains essential components, including Active Directory, certificate services, DNS records, and SQL server configurations.
🛠️ Configuring gMSA: Demonstrates creating and managing a Group Managed Service Account (gMSA) for enhanced security.
🔒 Securing IIS with Certificates: Walkthrough on installing and binding certificates for IIS to enable HTTPS.
📦 Installing DSC Modules: Guides on acquiring necessary DSC resources from the PowerShell gallery to enable desired configurations.
🎛️ SQL Integration for DSC: Configuring SQL server to work with gMSA for storing DSC data and ensuring secure authentication.
Spoiler alert it's not as easy as I thought it was going to be.
:48 - Prerequisites
3:00 - Security group configuration
4:35 - Install gMSA on SQL and Pull Servers
8:33 - Add gMSA to SQL Security
9:56 - Install SQL DB Driver on Pull Server
10:50 - Install DSC Resources
13:30 - Install IIS
14:55 - Request a Domain Certificate
18:04 - Pull Server configuration explanation
25:35 - Build the Pull Server
SQL DB Download Link: https://www.microsoft.com/en-us/downl...
Download the code: https://www.cyberautomate.io/posts/20...
Website: https://www.cyberautomate.io
BlueSky: https://bsky.app/profile/cyberautomat...
LinkedIn: / david-hall10
Github: https://github.com/cyberautomate
#PowerShell #PowerShellTraining #CyberAutomate #LearnPowerShell #PowerShellAutomation