Installing SQL Server 2019
- Download and extract the SQL Server 2019 Installers.zip. All needed executables will be include within.
- Run the 01. WINDOWS 10 IIS INSTALL v 1.2.bat from the installer folder.
- Right Click on the batch file and Run As Admin.
- Run the 01. WINDOWS 10 IIS INSTALL v 1.2.bat from the installer folder.
- Download the “en_sql_server_2019_standard_x64_dvd_814b57aa.iso” installer and copy it to the system you’re installing to.
- Right click on the ISO installer and choose “Mount” from the context menu.
- Double-click the “setup.exe” file.
- Select “Installation” from the left sidebar, then select “New SQL Server stand-alone installation or add features to an existing installation“.
- Product Key
- Take defaults.
- Click “Next”.
- License Terms
- Check the “I accept license terms” checkbox.
- Click “Next”.
- Microsoft Update
- Check the “Use Microsoft Update to check for updates (recommended)”.
- Click “Next”.
- 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.
- Feature Selection
- Check the features in the screenshot…
- Click “Next” when complete.
- 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”.
- Server Configuration
- Take the defaults.
- Click “Next”.
- Database Engine Configuration
- Select “Mixed Mode”.
- Type “xostech” as the password.
- In the “Specify SQL Server Administrators” section…
- Click “Add…”, in the “Enter the object names to select” textbox type System and then click “OK”.
- Click “Add…”, in the “Enter the object names to select” textbox type Administrator and then click “OK”.
- Click “Add…”, in the “Enter the object names to select” textbox type Administrators and then click “OK”.
- Click “Next”.
- Analysis Services Configuration
- Select “Multidimensional and Data Mining Mode”.
- In the “Specify which users have administrative permissions for Analysis Services” section…
- Click “Add…”, in the “Enter the object names to select” textbox type System and then click “OK”.
- Click “Add…”, in the “Enter the object names to select” textbox type Administrator and then click “OK”.
- Click “Add…”, in the “Enter the object names to select” textbox type Administrators and then click “OK”.
- Click “Next”.
- Ready to Install
- Click “Install”.
- Complete
- After installation completes everything should’ve succeeded.
- Click “Close”.
- Restart the system.
Installing SQL Server 2019 Cumulative Update
- Download the “SQLServer2019-KB5008996-x64.exe” installer from Google Drive and copy it to the system you’re installing to.
- Double click on the installer to start the installation.
- License Terms
- Check the “I accept license terms” checkbox.
- Click “Next”.
- Select Features
- The features should be automatically selected based on current install. If they are not, Click “Select All”.
- Click “Next”.
- 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”.
- Ready to update
- Click “Update”.
- Complete
- After installation completes everything should’ve succeeded.
- Click “Close”.
- Start back any windows services that were stopped during installation ( i.e. “SQL Server Integration Services CEIP service 15.0” ).
Configuring SQL Services
- Go to Windows Start → Services.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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”.
- 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”.
- Verify the services are as illustrated below…
Configure with SQL Server Management Studio
- 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.
- Start “SQL Server Management Studio”.
- Change the “Authentication” dropdown to “SQL Server Authentication” if necessary.
- Log in with the following credentials…
- Login: sa
- Password: ask support if unknown
- 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.
- 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.
- Close out of the application.
- 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
- Windows Start --> “Turn Windows features on or off”
- Expand the .NET Framework 4.8 Advanced Services --> Expand WCF Services
- Locate the “HTTP Activation” checkbox
- Check the “HTTP Activation” checkbox and click OK
Comments
0 comments
Please sign in to leave a comment.