Hi everyone,
I’m looking to automate the installation and configuration of SQL Server 2019 on multiple servers in our environment. So far, I’ve been using tools like PowerShell scripting using scriptrunner, attune, pdqdeploy and dbatools for some tasks, but I’m curious if anyone has a full end-to-end solution they recommend.
My main goals are:
- Automating the SQL Server installation with consistent configurations (accounts, file paths, etc.)
- Setting up security settings and agent jobs automatically
- Deploying across multiple servers with minimal manual intervention
- Are there tools or frameworks that have worked well for you? I’ve heard about using dbatools for post-install configurations, but I’d love to know if there are other approaches or best practices the community recommends.
Any advice, scripts, or resources would be super helpful. Thanks in advance!