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.

Installing SQL Server

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

Click on the Setup exe file to install SQL Server 1

SQL Server Installation Center: Once you click on the setup.exe, a new installation wizard called 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 the 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 that pre-requested software, then you have to install them before proceeding to the next step.

Check Hardware and Software Requirements 2

Go to the Installation tab and select either one or four:

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

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

Specify the Edition - We choose Evaluation to install SQL Server 4

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

Accept License Terms 5

Check for Available 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 Server Install Rules: Next, it will enter into Install Rules window. And here, the setup will automatically advance and perform the operations. It has to pass all the rules present in this window, but you can leave this Windows Firewall warning. If you want to give the firewall, please disable the Windows firewall from your Windows settings (control panel).

Run the Rules 6

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

  • Database Engine Services: To work with the 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 Reporting Services tutorials.
  • Integration Services: It helps you to Extract, Load, and Transform data. Please SSIS page to understand the Integration Services tutorials.
Choose the Setup Role as the SQL Server Feature Installation 7

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

Select the required Features to Install along with SQL Server 8

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

If you are upgrading, 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), select the named instance and give a unique name.

Configure the Instance to Default or Named 9

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

Server Configuration such as Service Accounts 10

Collation Tab: Leave the Collation section to default settings while installing SQL Server.

Install SQL Server 11

The Database Engine Configuration: Once you click the Next button, it will enter 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 Mixed Mode, you have to specify the strong password you will use to enter the database engine. Next, add the Users to access the database, and here we are adding the current user.

Configure Database Engine Authentication Mode to Mixed or Windows 12

Data Directories Tab: Leave the data directories to default.

Check or Change Data Directories 13

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

Checkmark Enable FILESTREAM for Transact-SQL access 14

Analysis Services Configuration: Once you click the Next button, it will enter into the SQL Server Analysis Services Configuration page to install. Here you have to configure the Server and 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 the Remove button to remove the added users.

Add User to Analysis Services Configuration while installing SQL Server 15

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

Check or Change the Analysis Services Data Directories  16

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 the Sql Server reporting service and also to configure it to native mode.

Configure Reporting Services Native Mode and SharePoint Integrated Mode while installing sql server 17

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

Add User to Distributed Replay Controller 18

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 a reply client.

Assign Controller Name for Distributed Replay Client 19

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

Verify the Configuration File Path or Change the Location 20

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

Wait till the Progress Completes 21

Complete Installation: Before closing the 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

I hope you understood the steps that are required to install SQL Server along with Analysis Services and Reporting Services.

Categories SQL

Comments are closed.