Installing a new SQL Server

Log into Windows as a user with administrative privileges. Make sure that no other programs are running; save your work and close any open applications.

The installation steps are generally the same for all supported SQL Servers. For illustration purposes, the images in the following steps are from the SQL Server 2014 Standard edition installation unless indicated otherwise.

1. Insert the SQL Server Installation DVD in your DVD drive or access the installation media on your system, then navigate to the root directory on the DVD and double-click setup.exe to open the SQL Server Installation Center.
2. Select Installation in the left pane and New SQL Server stand-alone installation or add features to an existing installation on the right.

3. Follow the steps provided by the installation wizard until you reach the Setup Role page, for SQL Server 2012 and 2014, or the Feature Selection page, for SQL Server 2016, 2017, and 2019.

   NOTE: Whenever a validation process occurs during installation, if validation is not successful, follow the instructions in the wizard to resolve the problem and click Re-run. Click Next when the validation is successful.

4. (For SQL Server 2012 and 2014) Setup Role page:

   Leave SQL Server Feature Installation selected, and click Next.

   

5. Feature Selection page:

   Under Instance Features, select Database Engine Services.

   (For SQL Server 2012 and 2014) Under Shared Features, select Management Tools - Basic and Management Tools - Complete.

   (For SQL Server 2016, 2017, and 2019) The Management Tools are installed in a separate Web-based process after completing the installation of SQL Server.

   Click Next.

   

6. Feature Rules page:

   This page identifies any errors related to the feature selection validation. If successful, the next page opens. If not successful, follow the instructions on the page and click Re-run. Click Next when the process completes successfully.

7. Instance Configuration page:

   Select Named instance and enter a name in the Instance Name field, for example ION. (Do not use an underscore character ( _ ) within the instance name.) Click in the Instance ID field to automatically add your Instance name entry. Click Next.

   

8. Server Configuration page:

   Change the Account Name for SQL Server Agent and SQL Server Database Engine to NT AUTHORITY\SYSTEM (your local system account). To do this, highlight the existing entries in the Account Name column and enter NT AUTHORITY\SYSTEM for the two services. (For SQL Server 2017 and 2019) Select Grant Perform Volume Maintenance Task privileges to SQL Server Database Engine Service. Click Next.

   NOTE:

   If you specify a Windows account other than the local system account, when you begin installing PME, the Check System page in the Installer indicates that the service account under which the SQL Server currently runs does not have the required system permissions. To resolve this situation, you need to do one of the following:

   • Temporarily change the SQL Server service to run under an account that has Write permissions to (1) the folder created for the product's databases (the default is the install location for ...\Power Monitoring Expert\), and (2), for the current logged-in user's Temp folder. (To find the full path to the Temp folder, click Start > Run, enter %Temp% and click OK.) The default local system account is an example of an account with these privileges.
   • Temporarily grant Write permission for the two folders mentioned above to the Windows account that the SQL Server service runs under. Use the Windows Services control panel to identify this account. (Click Start > Administrative Tools > Services, right-click SQL Server, click the Log On tab in the SQL Server Properties dialog.)

   Revert the temporary changes after the installation of PME completes.

   SQL Server 2014:

   

    

   SQL Server 2017 and 2019:

   

9. Database Engine Configuration page, on the Server Configuration tab:
   1. Select Mixed Mode.

      NOTE: If you are planning to install PME with Windows Integrated Authentication, then you can choose to configure the database engine either with Windows Authentication Mode or Mixed Mode. Mixed Mode authentication is also referred to as SQL Server authentication in this document.

   2. (For Mixed Mode) Type a password for the SQL Server system administrator (sa) account in the Enter password and Confirm password fields. (Keep a record of the password for future use.)

      warning

      potential compromise of System availability, integrity, and confidentiality

      Use cybersecurity best practices for password creation and management.

      Failure to follow these instructions can result in death, serious injury, equipment damage, or permanent loss of data.

      Cybersecurity policies that govern user accounts and access - such as least privilege, separation of duties - vary from site to site. Work with the facility IT System Administrator to ensure that user access adheres to the site-specific cybersecurity policies.

   3. Click Add Current User to add the SQL Server Administrator if it is not specified by default.

      

   4. (For SQL Server 2012 and 2014) Click the Data Directories tab. (For SQL Server 2016, 2017, and 2019) Click the TempDB tab.
   5. Specify a drive for the TempDB directories (Data and Log). If possible, locate these files on different drives than the database directories to improve performance. Click Next.

      NOTE: The specification of different drives is for performance reasons. If all of the files are located on the same drive, data that is being inserted, updated, or deleted can potentially result in slower write operations than if the Temp DB directories are located on a separate drive. The specification of different drives is dependent on your hardware configuration and may not be possible in all cases.

      SQL Server 2014:

      

      SQL Server 2017 and 2019:

      

10. Feature Configuration Rules page: 

    The rules are run automatically to validate that the installation can proceed. If validation is successful, the next page opens. This can be very quick and it might seem that the install wizard jumps directly to the next page. If validation is not successful, follow the instructions on the page and click Re-run. Click Next when the validation is successful.

    

11. Ready to Install page:

    The page shows the SQL Server features that are about to be installed. Click Install.

    

    The Installation Progress page provides a visual indication of the progress of the installation. When the installation finishes, the Complete page opens.

12. Complete page:

    Contains information about the Setup operations or possible next steps, as well as supplemental information related to your installation. Click Close to close the setup dialog.

    

13. (For SQL Server 2016, 2017 and 2019) In SQL Server Installation Center, click Install SQL Server Management Tools to launch the download page for the installation of SQL Server Management Studio. Follow the instructions to install SQL Server Management Studio. A system reboot is required after installing SQL Server Management Studio.

    NOTE: Internet access is required. If Internet access is not possible from this server, download the SQL Server Management Studio setup file on a different computer and copy it to the SQL Server computer for installation.

14. Go to the Maintenance page in the SQL Server Installation Center and click Launch Windows Update to search for product updates that you can install.
15. Close the SQL Server Installation Center.
16. (Recommended) Set the SQL Server memory options. See Setting SQL Server memory options for more information.