My 02D Cents
  • Welcome to my 02d cents
  • Multi-Language
    • Windows 10 Multi-Language ISO
      • Installing OSDBuilder
    • Office 365 Multi-Lang
      • Build - O365 Multi-Lang
      • Deploy - O365 Multi-Lang
  • General
    • Config Manager Install (manual) - WIP
      • Accounts / Groups
      • Prepare Server
        • Server - Drives
        • Install Services & Pre-Reqs
        • Registering ServicePrincipalNames for SQL
        • Open Server Ports for SQL
      • Install SQL
      • Install Power BI Report Server
      • Install SSMS
      • Configure SQL Memory Size
      • Install CU for SQL
      • Install WSUS
      • Install ADK & WinPE
      • Install MEMCM (TP) - Database
      • Install MEMCM
      • MEMCM - Resources / Downloads
    • Focused Sections
      • Applications
      • Reporting
      • MEMCM Client
  • Resources
    • Links
    • Scripts
      • MEMCM - Create Boundary & Collection
      • Task Scheduler - Auto Reboot
      • MEMCM - Boundaries Export
      • MSOL - Change AzureAD License
    • Tools
Powered by GitBook
On this page

Was this helpful?

  1. General
  2. Config Manager Install (manual) - WIP

Install SQL

PreviousOpen Server Ports for SQLNextInstall Power BI Report Server

Last updated 3 years ago

Was this helpful?

SQL Versions Supported

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

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