How to Install SQL Server

In this article, we show you step by step procedure to install SQL Server (irrespective of the version) with screenshots. If you have the installation CD / DVD, then insert the installation media into the drive to install SQL Server.

Installing SQL Server

Click Sql Server setup.exe File: Within the root folder, double-click on the setup.exe to install SQL Server.

Install SQL Server 1

SQL Server Installation Center: Once you click on the setup.exe, a new installation wizard called SQL Server Installation Center will be opened. Before you start installing the software, it is always recommended to check the Hardware and Software requirements that are required to install SQL server.

Hardware and Software Requirements: Click on the Hardware and Software Requirements hyperlink under the Planning tab. And, if you don’t have any of those pre-requested software then, you have to install them before installing Sql Server (proceeding to the next step).

Install SQL Server 2

Sql Server Installation tab: Go to Installation tab to install SQL Server, and select either one or four:

  • New SQL Server stand-alone installation or add features to an existing installation: If you are installing the SQL for the first time, or if you want to add additional features to the existing SQL Server instance, then please select this option.
  • Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012: If you want to upgrade from the previous versions the select this option.
Install SQL Server 3

Specify the Sql Server Edition to Install: Once you select an Option, a new wizard called SQL Server 2014 Setup (Version might be different for you) will be opened. On the first page, you have to enter the Product Key, or you can try the Evaluation period 6 months, by selecting Specify Free edition: Evaluation.

Install SQL Server 4

SQL Installation License Terms: Checkmark both the checkboxes, and click the Next button.

Install SQL Server 5

Check for Available Sql Server Updates: Once you click the Next button, it will check for the list of available updates for installing Sql Server. And if there are any then it will download, and install them. Since we downloaded the latest step up the file, we don’t have any updates.

SQL Install Rules: Next, it will enter into Install Rules window. And here, setup will automatically advance and perform the operations. Here, it has to pass all the rules present in this windows, but you can leave this Windows Firewall warning. If you want to pass the Firewall then please disable the windows firewall from your windows settings (control panel).

Install SQL Server 6

The SQL Setup Roles: Once you click the Next button, it will enter into Setup page. Please select the first option i.e., SQL Server Feature Installation as we shown below. It will install SQL Server

  • SQL Server Database Engine Services: To work with the SQL Server management studio
  • Analysis Services: To create Cubes, so that we can use MDX queries on this multidimensional data. Please refer SSAS page.
  • Reporting Services: It helps you to create Reports. Please SSRS page to understand the SQL Server Reporting Services tutorials
  • Integration Services: It helps you to Extract, Load, and Transform data. Please SSIS page to understand the SQL Server Integration Services tutorials.
Install SQL Server 7

SQL Feature Selection: Within the Feature Selection page, you have to select the components that you want to work with. We use this SQL Server for our SQL, MDX, SSAS, SSRS, and SSIS tutorials. So, we are selecting all the available SQL Server components to install.

Install SQL Server 8

SQL Instance Configuration: Once you click the Next button, it will enter into Instance Configuration page. Here you have to specify the instance name and the instance Id.

If you are upgrading the SQL Server then select the default instance so that it will Update the existing install. Or, if you are installing Sql Server second instance (a system already had one instance) then select the named instance, and give a unique name.

Install SQL Server 9

SQL Server Configuration: You can use the Service Accounts section under the Server Configuration Page to assign either local system, or a domain user account to the SQL Server services. Please change as we shown below.

Install SQL Server 10

SQL Collation Tab: Leave the Collation section to default settings.

Install SQL Server 11

The SQL Database Engine Configuration: Once you click the Next button, it will enter into the Database Engine Configuration page. Here you have to specify the authentication mode.

If you select the windows account then, step up will activate the sa account. Or, if you select the Mixed Mode then you have to specify the strong password that you will be used to enter the SQL Server database engine. Next, add the Users to access the database, and here we are adding the current user.

Install SQL Server 12

SQL Data Directories Tab: Leave the data directories to default.

Install SQL Server 13

The SQL FILESTREAM Tab: Checkmark the Enable FILESTREAM for Transact-SQL access.

Install SQL Server 14

SQL Analysis Services Configuration: Once you click the Next button, it will enter into Analysis Services Configuration page. Here you have to configure the Server, users to access the analysis services. Please select the Multidimensional and Data Mining Mode, and add the current user by clicking the Add Current User button. Use the Add.. button to add users to the service, and Remove button to remove the added users.

Install SQL Server 15

SQL Analysis Services Data Directories Tab: Leave the data directories to default.

Install SQL Server 16

SQL Reporting Services Configuration: Once you click the Next button, it will enter into Reporting Services Configuration page. Please select the Install and Configure option to install Sql Server reporting service, and also to configure it to native mode.

Install SQL Server 17

The SQL Distributed Replay Controller: Under the Distributed Replay Controller page, we are adding the current user to access this service.

Install SQL Server 18

SQL Distributed Replay Client: Within the Distributed Replay Client page, you have to specify the SQL Server Controller Machine name that you are going to use as reply client.

Install SQL Server 19

SQL Ready to Install: Under the Ready to Install page, please cross check the Configuration File path.

Install SQL Server 20

The SQL Installation Progress: Once you click on the Install button, Sql Server Installation Progress page will appear, and the installation process will be automatically advanced. Please wait until it installs 100%.

SQL Installation Progress  21

Complete SQL Installation: Before closing the SQL Server Setup or Installation Wizard, please check the status of each feature. If they are successful then you are good to go.

Install SQL Server 22

Hope you understood the steps that are required to install SQL Server along with Analysis Services, Reporting Services.

Comments are closed.