Share via

SQL Server Deployment SCCM

Dominic Kribbenhold 21 Reputation points
2021-08-12T11:25:37.41+00:00

Hello everyone, I would like to deploy SQL Server. Which version doesn't matter because I have to do it for several. My question now is, with other programs with so many setting options, there is usually a way to create an administrative image. How does it work with SQL Server? Does anyone have a tutorial for me or instructions on how to do it? Does it run through an .xml? I find very little about this on the Internet.
I would like to deploy the whole thing via SCCM.
Many Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,364 questions
Accepted answer
  1. Seeya Xi-MSFT 16,461 Reputation points
    2021-08-19T03:14:25.687+00:00

    Hi @Dominic Kribbenhold ,

    Sorry for misunderstanding what you mean.
    PLease refer to these articles:
    https://www.mssqltips.com/sqlservertip/2511/standardize-sql-server-installations-with-configuration-files/

    ------------
    in this case, the version is too old. But it is very detailed.
    https://www.softlanding.ca/blog/using-a-configuration-file-to-make-sql-server-installation-easier-and-consistent/

    ------------
    in this case, the version is 2019.

    Finally, this is an example of official documentation. 

    ; Microsoft SQL Server Configuration file    
[OPTIONS]    
; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE.    
; This is a required parameter.    
ACTION="Install"    
; Specifies features to install, uninstall, or upgrade.    
; The list of top-level features include SQL, AS, RS, IS, and Tools.    
; The SQL feature will install the database engine, replication, and full-text.    
; The Tools feature will install Management Tools, Books online,     
; SQL Server Data Tools, and other shared components.    
FEATURES=SQL,Tools

    Best regards,
    Seeya

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,461 Reputation points
    2021-08-13T03:10:41.593+00:00

    Hi @Dominic Kribbenhold ,

    You can refer to this article:https://www.manishbangia.com/sql-server-2017-for-sccm-installation/
    Version: you can chose SQL Server 2019. It is worth noting that the latest cumulative update release is CU12.

    Best regards,
    Seeya

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.