Installing SQL Server 2014 Step by Step Tutorial

Introduction

This article provides a step-by-step procedure for installing a new instance of SQL Server 2014, using the SQL Server setup installation wizard. The SQL Server Installation Center provides a single feature tree for installation of all SQL Server components, so that you do not have to install them individually.

Preparation

For local installations, you must run Setup as an administrator. If you install SQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share.

It is best to install the server from a DVD or from a mounted ISO file which behaves as a CD/DVD. In this case, once you double click the DISK icon the autorun.inf file is used by the AutoRun and AutoPlay components of Microsoft Windows operating systems. This will start the installation using the configuration in the autorun.inf file. If  AutoRun is disabled on your server, you may double click setup.exe to start the installation. To install from a network share, locate the proper folder on the share, and then double-click setup.exe.

Follow the below steps in order to install SQL Server 2014.

Step 1: Run SQL Server 2014 setup.

Installing SQL Server 2014 Step by Step Tutorial

Installing SQL Server 2014 Step by Step Tutorial

Step 2: On the screen above, make a click on the “Installation” hyperlink in the left side of the screen.

This screen shows the types of installation available.  Let’s select the first type available “New SQL Server stand-alone installation or add features to an existing installation”.

Installing SQL Server 2014 Step by Step Tutorial

Step 3: On the page above, specify the edition of SQL Server to install, if you are choosing to install a free edition of SQL Server 2014 or an Evaluation Edition of SQL Server 2014.

You should also provide a product key, if you are installing a licensed edition of SQL Server. Sometimes the product key is included in the media (the product key is pre-pidded).

Installing SQL Server 2014 Step by Step Tutorial

Step 4: The above is the License Terms page.  Read the license agreement and if you agree with it, check the “I accept the license terms” check box, and then click the Next button.

Installing SQL Server 2014 Step by Step Tutorial

Step 5: On this page SQL Server 2014 setup is trying to get updates from Microsoft Update, and for this reason is important to have Internet access when installing SQL Server as mentioned at the beginning of this article. Make a click on the checkbox to get the updates, if the computer has Internet access, then click on the Next button.

Installing SQL Server 2014 Step by Step Tutorial

Step 6: The above screens belong to the second set of Setup Support Rules. To have detailed information about the cause of errors and warnings you may receive click on the blue hyperlinks associated with each warning/error.

Installing SQL Server 2014 Step by Step Tutorial

Step 7: About the Windows Firewall warning, you can go ahead with the installation of SQL Server, but when it finishes configure your Windows Firewall to allow SQL Server access or disable it. Click here to know how to configure Windows Firewall for SQL Server access.

Alternatively, you can opt to turn off Windows Firewall if you are installing SQL Server for personal issues. You can go to Control Panel and turn it off as shown below:

Installing SQL Server 2014 Step by Step Tutorial

Step 8: If you receive the Microsoft .NET Application Security warning is because Setup Support Rules verifies Internet connectivity and triggers a warning if there is no Internet connection. The reason to check for Internet connection is “because .NET always tries to connect to CRL.MICROSOFT.COM on startup to check signature validation.”.

In general, warnings won’t prevent you from install SQL Server server.

If you performed adjustments in your PC, as explained on the paragraphs above, you may want to run again the rules and verify if you can leave behind the warnings. Please click on the “Re-run” button, and click on the Next button if the computer now passes all the rules, as shown below.

Installing SQL Server 2014 Step by Step Tutorial

Installing SQL Server 2014 Step by Step Tutorial

Step 9: On the SQL Server Setup page shown above, you can decide to install specific features of SQL Server or decide to install SQL Server using a setup role. For more information about this page, please click here.

Installing SQL Server 2014 Step by Step Tutorial

Step 10: On the Feature Selection page, please select the features you would like to install. A description of each feature will appear on the “Feature description” area when you click on a feature. For a detailed description of each feature, please click here.

Installing SQL Server 2014 Step by Step Tutorial

Step 11: Once you have selected the features to install, please click on the “Next” button.

Installing SQL Server 2014 Step by Step Tutorial

Step 12: On the Instance Configuration page, select a default or named instance for your installation. SQL Server supports multiple installations on the same computer, each installation receives the name of “instance”. The default instance gets the name of the computer, but the named instances, receive the name of the computer plus the name provided by the user on this setup page. To access a default instance once it is installed, using SQL Server Management Studio or any other program, you just need provide the computer name. To access a named instance, you will need to provide the name opf the instance in the forma of computername\nameoftheinstance.

Installing SQL Server 2014 Step by Step Tutorial

Step 13: On this screen you need to provide the service accounts that SQL Server services will use. As you can notice, SQL Server setup provides virtual accounts by default, they are auto-managed, they can access the network on a domain environment by using the credentials of the computer account.

However, I still recommended to create a local user or use a domain user account to start SQLServer services.

If the computer is not part of a domain, use a local user account without Windows administrator permissions. You can create this account using Control Panel -> User Accounts. Please provide a strong password to this account since SQL Server setup will required it on this “Server Configuration” page.

Use a Domain User Account if the service must interact with network services or access domain resources. This account should be pre-created by a domain administration in your environment.

Whether you create a local user or a domain user account, the password you use to create the account must be a strong password since SQL Server setup will required it on this “Server Configuration” page.

You can also use built-in accounts (the Network Service account, Local Service, Local System) as service accounts. However, I would not recommend to use Local Service Account for SQL Server (MSSQLSERVER). Use Local System if you need a very high-privileged account, or you are having issues installing SQL Server using virtual accounts as service accounts. It has extensive privileges on the local system.

Microsoft recommends you to specify an individual account for each service. The service accounts used for this configuration must have a strong password as mentioned above, otherwise you will get the error “Invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent service”.  A strong password  is one that has a combination of letters in uppercase, lowercase, numbers and special characters.

To provide a local Windows account or a domain account as service account, please follow the steps shown in the images below.

Installing SQL Server 2014 Step by Step Tutorial

Step 14: Change the location to Active Directory if you would like to provide a domain account as service account. Click on the “Locations” button to change the focus of the search to the Active Directory. Once you provide an account, please validate the account by making a click on the “Check Names”. If the validation fails, remove the user you typed, then click on the “Advanced” button, and click on Find to get a list of Windows users and select one.

Installing SQL Server 2014 Step by Step Tutorial

Step 15: On the “Server Configuration” page you can also select how you want to start this service on the computer (Startup Type). On my laptops I usually set the services to start manually, to allow the computer to startup faster. However, on a server production environment, probably automatic should be the recommended startup type.

Installing SQL Server 2014 Step by Step Tutorial

Step 16: If you receive the below error message (“There are validations errors on this page”), probably you did not provide a strong password, the password does not match with password the account has on Windows or on Active Directory. If you cannot get rid of this message, change the service account specified at the bottom of the page (with the red balloon) to Local System my work.

Installing SQL Server 2014 Step by Step Tutorial

Installing SQL Server 2014 Step by Step Tutorial

Step 17: On the Database Engine Configuration page (see above), choose the authentication mode to use for your SQL Server installation.  If you select Mixed Mode, Setup creates an sa account.

Enter and confirm the password for the (sa) login when you choose Mixed Mode Authentication.

You will get the error “Missing system administrator account. To continue, provide at least one Windows account to provision …”, if you fail to provide SQL Server administrators and try to continue with the next page of Setup.  The error message “There are validation errors on this page …” will also appear. Click the buttons “AddCurrent User” or “Add …” to provide at least one account that will have unrestricted access to the SQL Server instance.

Installing SQL Server 2014 Step by Step Tutorial

Step 18: Click on the “Data Directories” tab (above image), to change the location of SQL Server default directories. For information about default location of files on SQL Server instances, please click here.

Installing SQL Server 2014 Step by Step Tutorial

Step 19: Use this page to enable FileStream on this instance. To enable it, select “Enable FILESTREAM for Transact-SQL access”.

Select “Enable FILESTREAM for file I/O streaming access” to enable Win32 streaming access for FileStream.

On the “Windows share name” text box, to enter the name of the Windows share in which the FileStream data will be stored.

Select “Allow remote clients to have streaming access to FILESTREAM data” to allow remote clients to access this FileStream data on this server.

Installing SQL Server 2014 Step by Step Tutorial

Step 20: On the “Analysis Services Configuration Page”, please select “Install Analysis Services in Multidimensional and Data Mining Mode” to install Analysis Services with support for online analytical processing databases and data mining models.

Select “Tabular Mode” to install Analysis Services with support for tabular models.

Each mode is exclusive of the other.

Please provide also a user account that will be an Analysis Services administrator.

Installing SQL Server 2014 Step by Step Tutorial

Step 21: On the Reporting Services Configuration page (above), choose to install Reporting Services on Native Mode or SharePoint Integrated Mode.

Installing SQL Server 2014 Step by Step Tutorial

Step 22: On the Ready to Install page, review the summary of features and components for your SQL Server installation. To proceed, click Install.

Installing SQL Server 2014 Step by Step Tutorial

Step 23: On the “Complete” page (above image), you can view the Setup summary log by clicking the blue link provided on the bootom this page. To exit the SQL Server Installation Wizard, click Close.

Installing SQL Server 2014 Step by Step Tutorial


<<Click here to see all posts>>

Leave a Reply

Your email address will not be published. Required fields are marked *

Prove You Are Human Time limit is exhausted. Please reload CAPTCHA.