In this post, I will demonstrate the installation of SQL Server
2014 on a VMWare Workstation. We can learn how to configure and use the
features of SQL Server 2014.
1)
Make sure you run the setup as “ Run as Administrator “
2)
The SQL Server Installation Center window will display. Along the
left side of the window are the categories showing how the SQL Server
Installation Center is organized. On the right side of the window are different
actions the installer can take.
3)
Clicking on Installation on the left side will display the
different installation options. For this tip, we will click on "New SQL
Server stand-alone installation or add features to an existing
installation". This will launch the SQL Server 2014 Setup application.
4)
The SQL Server 2014 Setup application lists the steps it will
follow on the left side of the window. I am installing SQL Server 2014 Enterprise
edition here.
5)
Review the license terms, click on "I accept the license
terms", and then click "Next”
6)
The SQL Server 2014 Setup application will run multiple checks for
rules during the installation process. If a rule check fails, the setup
application will provide the corrective measures to take so installation may
proceed.
7)
The setup application will also search for product updates.
8)
Another rule check will be run to ensure everything is in place so
the setup will be successful. If a rule check fails, the setup application will
provide the corrective measures to take so installation may proceed. Click on
"Next" to continue.
9)
On the Setup Role screen, we will click on the SQL Server Feature
Installation radio button. This will allow us to install the database engine,
Analysis Services, Reporting Services, Integration Services and other features
of SQL Server 2014. Click on "Next " to continue.
10) The next step is the
feature selection. This allows the installer to pick and choose the features to
be installed. On the right side of the window, the disk space requirements are
displayed. At the bottom, the installer can choose the path for the instance
root and shared feature directories. Click on "Next" to continue.
11) Another rule check after
feature selection will be run to ensure everything is in place so the setup
will be successful. If a rule check fails, the setup application will provide
the corrective measures to take so installation may proceed. Click on
"Next" to continue
12) The Instance Configuration
screen allows the installer to specify the name of the instance and its ID.
This screen will also display other installed instances.
13) The
Server Configuration screen shows the services to be installed, the service
account name and the Startup Type.
14) On the collation Tab, If you want to change
the collation of the server select from the given option. Otherwise by default
it will take the collation settings.
15) On the Server
Configuration tab of the Database Engine Configuration screen, select your
preferred Authentication Mode and specify your SQL Server administrators.
16) On the Data Directories
tab of the Database Engine Configuration screen, specify your preferred
directories for the data root, system database, user database, user database
log, temp database, temp database log, and backup. Click on "Next".
17) On the File stream Tab, you can select enable File
stream option. I am not selecting the option as of now. We can choose this
option later on.
18) On the Server
Configuration tab of the Analysis Services Configuration screen, select your
preferred Server Mode and specify your Analysis Services administrators.
19) On the Data Directories
tab of the Analysis Services Configuration screen, specify your preferred
directories. Click on "Next".
20) On the Reporting Services
Configuration, select Install and configure. Click on "Next" to
continue.
21) We have to specify Administrator for the Distributed
Relay Controller Service.
22) Specify the Name and directories for DRC
Service.
23) Another rule check will be
run to ensure everything is in place so the setup will be successful. If a rule
check fails, the setup application will provide the corrective measures to take
so installation may proceed. Click on "Next" to continue.
24) The Ready to Install
screen displays all of the features and prerequisites to be installed. At this
point, the installer can still go back to make changes or quit the process.
Click on "Install" to begin the installation of the SQL Server 2014
components.
25) The installation progress
bar tracks the status of the installation.
26) Upon completion of the
installation, Check all the features are successfully installed and click on
"Close" to exit the SQL Server 2014 Setup.
27) After successful installation of SQL Server
2014, Check the Configuration Manager for features.
28) Open SQL Server Management Studio.
29) Expand the SQL Server and review all the
components.
If you get stuck with
the setup somewhere, please leave a comment here and I will be glad to help.
Have fun!
Have fun!
Microsoft SQL Server 2019 Standard provides all database features with analytics and reporting capabilities. It also includes basic availability features and disaster recovery. Microsoft SQL Server Standard can build rich content management applications.
ReplyDelete