question

DominicKribbenhold-8566 avatar image
0 Votes"
DominicKribbenhold-8566 asked SeeyaXi-msft answered

SQL Server Deployment SCCM

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-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DominicKribbenhold-8566 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

Hello, no that hasn't helped me so far.
I do not know if I am properly understood. The SCCM is fully set up and functional. I've already deployed several programs like Inventor, Solidworks, and Solidedge. Anyone in my company can install these programs through the Software Center. Most of the employees now also need at least one SQL server on their local system. In order not to have to carry out this installation manually every time, I would like to automate it via the Software Center. That with the help of the SCCM which is complete and functional.

I need instructions or a help step for setting up an administrative image from a SQL Server. Which one I don't care about, shouldn't differ much.

So this is my question

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @DominicKribbenhold-8566,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered SeeyaXi-msft commented

Hi @DominicKribbenhold-8566,

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.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SeeyaXi-msft,

it looks like the normal installation of the SQL Server. Do I just have to add the the Powershell commands and the folder structure created in the Configuration Center afterwards to make it available to everyone?

0 Votes 0 ·
SeeyaXi-msft avatar image SeeyaXi-msft DominicKribbenhold-8566 ·

Hi @DominicKribbenhold-8566,

https://www.prajwaldesai.com/sccm-1902-install-guide-using-baseline-media/
This article is more detailed, you can install it according to your own situation. Its process is similar to that of ordinary installation.

Best regards,
Seeya

0 Votes 0 ·