Install SQL

SQL Versions Supported

LogoSupported SQL Server versions - Configuration Managerdocsmsft
LogoSQL Server Downloads | MicrosoftMSFT_Business

Execute Setup.exe from the SQL installation media, select New SQL server stand-alone installation

The firewall ports we opened earlier takes care of the warning shown here

Just need to select Database Engine Services and leave default location for the services to install

You can leave the default instance name

Replace the SQL Server Agent & SQL Server Database Engine Account with one you created earlier. Enter password and ensure both are set to automatic startup

Server Configuration - Add current User and also add the MEMCMSQLFull_Admins group we created earlier

Data Directories - Leave default

TempDB Directories - Will point to the folder under MEMCM_TEMP_DB we created earlier

TempDB Directories - Change the Autogrowth on DB and Logs to 256

Memory - Select Recommended

For versions of SQL that do not have this, reference PatchyPC - How to Install SCCM Current Branch Step-By-Step Guide

You can verify all the DB files created on the Temp Database drive

SQL Access

Add current user and MEMCM server to group MEMCM_SQL_Full_Admins that we created earlier

PreviousOpen Server Ports for SQLNextInstall Power BI Report Server

Last updated

Was this helpful?