Post reply

Automating SQL Server 2019 Setup and Configuration Across Multiple Servers

  • December 2, 2024 at 7:49 am

    #4491998

    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!

  • December 2, 2024 at 12:25 pm

    This was removed by the editor as SPAM

  • December 3, 2024 at 8:10 am

    #4492512

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • December 9, 2024 at 7:54 am

    #4495297

    What you are asking for is why I developed SQL FineBuild. If you want it can automatically set up SQL Server 2019 on a cluster complete with AG and distributed AG, along with SSAS and SSRS or PowerBI, all protected by SSL certificates. It can also do a plain SQL Express install to Windows 11, and anything in between. There is a good Wiki that covers what it can do, look for it on GitHub.

    However since I retired it has no support and (unless somebody steps up to the job) will not get enhanced for SQL 2022, SQL 2025 or Win25.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply