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 setup.exe File: Within the root folder, double-click on the setup.exe to install SQL Server.
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 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).
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 for the first time, or if you 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 the select this option.
Specify the Sql Server Edition to Install: Once you select an Option, a new wizard called Setup (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.
Installation License Terms: Checkmark both the checkboxes, and click the Next button.
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 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).
The Setup Roles: Once you click the Next button, it will enter into Setup page. Please select the first option i.e., Feature Installation as we 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.
Feature Selection: Within the Feature Selection page, you have to select the components that you want to work with. We use this Server for our transact queries, MDX, SSAS, SSRS, and SSIS tutorials. So, we are selecting all the available SQL Server components to install.
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, 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.
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 services. Please change as we shown below.
Collation Tab: Leave the Collation section to default settings.
The 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 database engine. Next, add the Users to access the database, and here we are adding the current user.
Data Directories Tab: Leave the data directories to default.
The FILESTREAM Tab: Checkmark the Enable FILESTREAM for Transact-SQL access.
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, 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.
Analysis Services Data Directories Tab: Leave the data directories to default.
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.
The Distributed Replay Controller: Under the Distributed Replay Controller page, we are adding the current user to access this service.
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.
Ready to Install: Under the Ready to Install page, please cross check the Configuration File path.
The 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%.
Complete 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.
Hope you understood the steps that are required to install SQL Server along with Analysis Services, Reporting Services.