In the previous article, we have seen how to install the SQL Server database engine using Powershell DSC with multiple configurations. We have covered setting up service account credentials, custom installation directories, configuring TempDB and backup locations, defining user database paths, and more. We have also seen the installation of other SQL Server-related services like Integration Services, Analysis Services, and Reporting Services. This was all done using the simplicity and power of PowerShell DSC. In this article, we cover the installation of SQL Server Management Studio (SSMS) using Powershell DSC.
For the demo part, we use the server,