SQL 2019 Install from Scratch

Installing SQL Server 2019

1. Download and extract the SQL Server 2019 Installers.zip.  All needed executables will be include within.  
   1. Run the 01. WINDOWS 10 IIS INSTALL v 1.2.bat from the installer folder.
      1. Right Click on the batch file and Run As Admin.
2. Download the “en_sql_server_2019_standard_x64_dvd_814b57aa.iso” installer and copy it to the system you’re installing to.
3. Right click on the ISO installer and choose “Mount” from the context menu.
4. Double-click the “setup.exe” file.
   
5. Select “Installation” from the left sidebar, then select “New SQL Server stand-alone installation or add features to an existing installation“.
6. Product Key
   • Take defaults.
   • Click “Next”.
7. License Terms
   • Check the “I accept license terms” checkbox.
   • Click “Next”.
8. Microsoft Update
   • Check the “Use Microsoft Update to check for updates (recommended)”.
   • Click “Next”.
9. Install Rules
   • The installer will now copy necessary files for installation to the system and check for “Install Rules” making sure an installation is possible. Should pass 100% before continuing.
10. Feature Selection
    • Check the features in the screenshot…
    • Click “Next” when complete.
11. Instance Configuration
    • Select “Named instance”.
    • Type COACHINGSOLNS into the “Named Instance” field.
    • Click into the “Instance ID” field and it should be automatically changed to COACHINGSOLNS without having to type it.
    • Click “Next”.
12. Server Configuration
    • Take the defaults.
    • Click “Next”.
13. Database Engine Configuration
    • Select “Mixed Mode”.
    • Type “xostech” as the password.
    • In the “Specify SQL Server Administrators” section…
      1. Click “Add…”, in the “Enter the object names to select” textbox type System and then click “OK”.
      2. Click “Add…”, in the “Enter the object names to select” textbox type Administrator and then click “OK”.
      3. Click “Add…”, in the “Enter the object names to select” textbox type Administrators and then click “OK”.
    • Click “Next”.
14. Analysis Services Configuration
    • Select “Multidimensional and Data Mining Mode”.
    • In the “Specify which users have administrative permissions for Analysis Services” section…
      1. Click “Add…”, in the “Enter the object names to select” textbox type System and then click “OK”.
      2. Click “Add…”, in the “Enter the object names to select” textbox type Administrator and then click “OK”.
      3. Click “Add…”, in the “Enter the object names to select” textbox type Administrators and then click “OK”.
    • Click “Next”.
15. Ready to Install
    • Click “Install”.
16. Complete
    • After installation completes everything should’ve succeeded.
    • Click “Close”.
17. Restart the system.

Installing SQL Server 2019 Cumulative Update

1. Download the “SQLServer2019-KB5008996-x64.exe” installer from Google Drive and copy it to the system you’re installing to.
2. Double click on the installer to start the installation.
3. License Terms
   • Check the “I accept license terms” checkbox.
   • Click “Next”.
4. Select Features
   • The features should be automatically selected based on current install.  If they are not, Click “Select All”.
   • Click “Next”.
5. Check Files In Use
   • The installer checks for applications/services that are using files related to the installation.
   • To avoid having to restart the system, stop/close the listed application/services.
   • Note: The SSISTELEMETRY150 process is the “SQL Server Integration Services CEIP service 15.0” windows service.
   • Click “Refresh check” to verify the application/services are no longer in use.
   • Click “Next”.
6. Ready to update
   • Click “Update”.
7. Complete
   • After installation completes everything should’ve succeeded.
   • Click “Close”.
8. Start back any windows services that were stopped during installation ( i.e.  “SQL Server Integration Services CEIP service 15.0” ).

Configuring SQL Services

1. Go to Windows Start → Services.
2. Set the SQL Server (COACHINGSOLNS) service to use “Local System” for the “Log On” account.
   • Right-click on the SQL Server (COACHINGSOLNS) and stop the service.
   • Double-click on the service to bring up the Properties dialog; or right-click on the service and select “Properties” from the context menu.
   • Change to the “Log On” tab and select the “Local System account” radio button.
   • Click OK.
   • Right-click on the SQL Server (COACHINGSOLNS) and start the service.
3. Set the SQL Server Agent (COACHINGSOLNS) service to use “Local System” for the “Log On” account.
   • Right-click on the SQL Server Agent (COACHINGSOLNS) and stop the service (if running).
   • Double-click on the service to bring up the Properties dialog; or right-click on the service and select “Properties” from the context menu.
   • Change to the “Log On” tab and select the “Local System account” radio button.
   • Click OK.
   • Right-click on the SQL Server (COACHINGSOLNS) and start the service.
4. Set the SQL Server Analysis Services (COACHINGSOLNS) service to use “Local System” for the “Log On” account.
   • Right-click on the SQL Server Analysis Services (COACHINGSOLNS) service and stop the service.
   • Double-click on the service to bring up the Properties dialog; or right-click on the service and select “Properties” from the context menu.
   • Change to the “Log On” tab and select the “Local System account” radio button.
   • Click OK.
   • Right-click on the SQL Server (COACHINGSOLNS) and start the service.
5. Set the SQL Server Browser service to use “Local System” for the “Log On” account.
   • Right-click on the SQL Server Browser service and stop the service.
   • Double-click on the service to bring up the Properties dialog; or right-click on the service and select “Properties” from the context menu.
   • Change to the “Log On” tab and select the “Local System account” radio button.
   • Click OK.
   • Right-click on the SQL Server (COACHINGSOLNS) and start the service.
6. Verify the SQL Server VSS Writer service uses “Local System” for the “Log On” account.
   • Verify the “Log On As” is set to “Local System” and if not set it as such.
   • Verify the “Startup Type” is set to “Automatic” and if not set it as such.
7. Verify the SQL Server (COACHINGSOLNS) service settings…
   • Verify service is set to “Automatic”. If not then double-click it or right-click it and choose “Properties”, change the “Startup Type” dropdown to “Automatic”, click “Apply” then click “OK”.
   • If service is not running right-click the service and select “Start”.
8. Verify the SQL Server Agent (COACHINGSOLNS) service settings…
   • Verify service is set to “Automatic”. If not then double-click it or right-click it and choose “Properties”, change the “Startup Type” dropdown to “Automatic”, click “Apply” then click “OK”.
   • If service is not running right-click the service and select “Start”.
9. Verify the services are as illustrated below…

Configure with SQL Server Management Studio

1. Download the “SSMS-Setup-ENU - (18.11.1).exe“ installer and copy it to the machine you’re installing to and install it.
   • NOTE: SQL Server Management Studio is no longer included with SQL Server and has a separate installer.
2. Start “SQL Server Management Studio”.
3. Change the “Authentication” dropdown to “SQL Server Authentication” if necessary.
4. Log in with the following credentials…
   • Login: sa
   • Password: ask support if unknown
5. Verify “BUILTIN\Administrators” has sufficient permissions…
   • From the left sidebar open “Security” → “Logins”.
   • Right-click on “BUILTIN\Administrators” and select “Properties”.
   • Select “Server Roles” from the left sidebar.
   • Verify the “sysadmin” checkbox is checked. If not check it and click OK.
6. Verify “NT AUTHORITY\SYSTEM” has sufficient permissions…
   • From the left sidebar open “Security” → “Logins”.
   • Right-click on “NT AUTHORITY\SYSTEM” and select “Properties”.
   • Select “Server Roles” from the left sidebar.
   • Verify the “sysadmin” checkbox is checked. If not check it and click OK.
7. Close out of the application.
8. Verify you can log in using “Windows Authentication”.
   • Go to Windows Start → SQL Server Management Studio, then right-click on the application in the start menu and choose “Run as administrator”.
   • Change the “Authentication” dropdown to “Windows Authentication” if necessary.
   • Click “Connect” and verify you successfully logged in.

Ensure HTTP Activation is Enabled

1. Windows Start --> “Turn Windows features on or off”
2. Expand the .NET Framework 4.8 Advanced Services --> Expand WCF Services
3. Locate the “HTTP Activation” checkbox
4. Check the “HTTP Activation” checkbox and click OK
5.