Install/configure ASPstate2 database using DSC


I already have installed SQL server 2016 Via DSC but now need to configure/install SQL Server ASPState2 database. It can be configured using aspnet_regsql tool but how to incorporate in DSC.

If you know what command and parameters to run when using aspnet_regsql, you can create a custom DSC Resource so that it does what you need. It’ll be very similar to writing PowerShell function.

The doc is here: