Installing Microsoft SQL Server 2019
Follow these steps to install Microsoft SQL Server 2019:
1. Insert the Microsoft SQL Server 2019 disc into the CD/DVD drive.
2. Begin the installation by double-clicking Setup.exe from the root of the install disc. The SQL Server Installation Center screen is displayed.
3. Click the Installation tab from the navigation menu and select
New SQL Server standalone installation...
4. Click OK on the Setup Support Rules display to start the install pre-configuration.
5. Click the
Enter the product key radio button and enter a valid product key. Click Next.
6. Check the box beside
I accept the license terms. Click Next.
7. Leave the check-box checked for
Include SQL Server product updates.
An internet connection is required to download the updates.
8. Click Next. The product update files will begin downloading.
9. Once the files have downloaded, click Next to continue to the Setup Support Rules page. The support rules verify the SQL installation is safe to run.
10. Please note any warnings displayed. Click Next.
11. Select the
SQL Server Feature Installation radio button. Click Next.
12. Select the following features to be installed:
Database Engine Services
Client Tools Connectivity
Client Tools Backwards Compatibility
Management Tools – Basic
Management Tools – Complete
13. Click Next to continue. The Installation Rules page appears.
14. Click Next to continue to the Instance Configuration screen.
15. Leave the selected radio button as
Default instance. Click Next.
16. Verify the server meets the disk space requirements. Click Next.
<<Browse...>> below the
Account Name drop-list for the SQL Server Agent.
18. Enter the account used by the SQL instance. AMI recommends that you use the Network Service unless instructed otherwise by the facility Network Administrator. Click
19. The user is auto-filled in the field. Click OK.
20. Enter the password for the user in the appropriate
Password field if the user is on a domain.
21. Click the
Startup Type drop-list for the SQL Server Agent and select Automatic.
22. Repeat Steps 17 through 21 for the SQL Server Database Engine service.
23. Click the
Startup Type drop-list for the SQL Server Browser and select Disabled.
24. Click Next if the Server Configuration screen looks similar to the image shown at right.
25. Select Mixed Mode authentication and enter a password for the sa user in the
Enter password and
Confirm password fields. Record the password in a safe place for future use.
26. After the passwords have been entered, click the Add… button.
27. Type in AMIAdmin in the
Enter the object names field. Click Check Names.
28. The AMIAdmin user is auto-completed in the field. Click OK.
29. Click Next to continue to the Error Reporting screen.
30. Verify the
Send Windows and SQL Server Error Reports… checkbox is unchecked. Click Next.
31. Note any warnings displayed on the Installation Configuration Rules screen. Click Next.
32. Review the install summary and click Install to begin the SQL Server software installation.
33. Click Close on the Complete window when the installation is successful.
This SQL software installation process may take up to 60 minutes, depending on server configuration.
Enabling Named Pipes and TCP/IP
1. Click the Windows Start icon and press the
Down Arrow icon to expand All Programs.
2. Click SQL Server Configuration Manager.
3. Click the
Expand icon beside
SQL Server Network Configuration and click Protocols for MSSQLSERVER.
4. Right-click protocol Named Pipes/TCP/IP and click Enable.
5. A pop-up information box alerts you that the changes will not take effect until the service is stopped and restarted. Click OK.
6. Close the window and restart the SQL Server.