Step-by-Step Installation of Microsoft SQL Server 2014:

Prerequisites for installing SQL Server 2014:

1. 32- bit computers not allowed

2. The minimum operating system requirements for the SQL Server 2014 are one of the following:

–>Windows Server 2012

–> Windows 8 RTM

–> Windows Vista SP2

–> Windows Server 2008 SP2

–> Windows 7 SP1

–> Windows Server 2008 R2 SP1

3. .NET Framework 3.5 is required.

Listed below are the steps to be followed to install SQL Server 2014:

1. Download SQL Server 2014 SP1 from the below mentioned link

https://technet.microsoft.com/en-in/evalcenter/dn205290.aspx

2. Once you’re done downloading the ISO file, please extract it to your preferred drive location and
keep it ready for installation.
3. Run the SQL Server 2014 setup as shown below .Make sure that you’re running it with elevated
permissions as shown in the image below.
4. Please select “installation” from the list of options given in this screen.

5. This screen shows the types of installation available. Let’s select the first type i.e. “New SQL
Server stand-alone installation” as shown in the image below.
6. Click on “Run” in the next screen.

7. Since I’m running an evaluation version, I’m going to keep the option as evaluation in this
screen.
8. If you want to participate in the CEIP program, then put a checkmark in the box highlighted in
the image below .If not just accept the license agreement and click next.
9. The “rule check” is in progress as shown in the screen below.
10. Now if you want you’re SQL server installation wizard to look for any new updates, please
put a checkmark in the box shown in the image below. The most preferred and suggested
practice is to not check that box as it’s good to have a look at those updates in the Microsoft
website and then run them manually . Hence I’m not checking that checkbox here.
11 . You might get an error as shown below . That’s a common error which you would get since
I didn’t check the “Check for updates” checkbox .I’m just going to ignore it and proceed further
with the installation by clicking next.
12. The set-up files are getting installed as shown in the image below.
13. Now you can see the below mentioned screen displaying warnings about the domain
controller, .NET Application Security & Windows Firewall .Now if you’re performing this
installation in a test lab its ok to ignore these errors and proceed further.However,if you’re
performing this installation in a production server its mandatory that you fix these issues . Since
I’m performing this installation in a test lab I’m just going to ignore this error and proceed
further with this installation by clicking next.
14. The next screen gives you an option to choose which feature components to install, please
click on “SQL Server Feature Installation” and click next.
15. Please select the evaluation features for this instance by checking the appropriate check box.
Now how this works is if you want this instance to just have the “Database Engine
Services” running, then please check the check box for “Database engine services” alone .
Similarly if you want “Analysis Services” as well as “Reporting Services” running in the same
instance, then check those check boxes as well.
16. Once you’re done choosing the required features for this instance the installation wizard will
calculate the required disk space and will display it and shown in the above image.
17. Once you’re done choosing all the necessary features make sure that you check the “client
connectivity tools” and “management tools” (SSMS) check box and click on next. These tools
are mandatory to manage SQL Server.

18. You will see the next window where the operation proceeds further as shown in the image
below.
19. Now once that’s complete and the operation is successful you will be taken to a window
where you’re supposed to make the “Instance Configuration” . Now in SQL Server its very
important that you understand the two different types of instances

a) Default Instance –>Choosing the “default instance” will pick up the server name/PC name in
which you’re performing the installation and will proceed further with the installation.

b) Named instance–>Choosing the “Named instance” option will ask you to name the instance
and the same name will be assigned to the “Instance ID” as well.

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 of the instance in the form of “Computername\nameoftheinstance”

It’s always preferable to go with “Named instance “option so that you would be able to
differentiate between instances if many instances are installed in the same SQL server.
20. Once that’s done the next screen (shown below) will ask you to specify the service account details for
all the features that has been chosen , please specify the appropriate username and password as
required . Now ,since this is my test lab, I’m going to stick to the defaults. It also gives you the option
to choose the “startup type” .It can be either “Automatic” or “Manual”.
However there are couple of things to notice here, 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 service or access domain
resources. This account should be pre-created by a domain administrator in AD.

21. Make sure that you’re providing the credentials correctly or else you would end up getting
a “validation error” as shown below.
22. Once that’s done the next screen will ask you to specify your “authentication mode”. You have two
authentication modes in SQL Server namely 1. Windows Authentication and 2. Mixed mode
(Windows + SQL) authentication. If you choose Windows Authentication then users who are created
within SQL server won’t be able to access SQL, so the best and recommended practice is to go with
“mixed mode authentication”.
23) Once you’re done specifying the “authentication mode” please click on “Add current user”
button as shown in the image below and this will make the current user who is running this
wizard as the SA (i.e SQL Server Admin).
24) You can also add few more users to the “SQL Server Administrators” group by clicking on
the “Add” button next to “Add current user” as shown in the above image.

25) Once that’s done , please click next and this will take you to the ‘Analysis Services
Configuration “ wizard , please specify the “ Analysis Services administrator “ detail as shown
in the image below and click next .
26) The next screen would give you the path for the “Data Directories”, you can change this path
if required.
27) The next screen would be for “Reporting Services Configuration”, I strongly recommend to
go with the second option (i.e. Install Only) as once the installation is complete you can
configure “Reporting services” later using the “Reporting Services Configuration Wizard”.
28) Finally, On the Ready to Install page, review the summary of features and components for
your SQL Server installation. To proceed, click Install…
You would also notice the “Configuration file path” which has the “configurationfile.ini” and
this file can be used later if you want to create a different instance of SQL Server with the
same configuration.This file basically holds all the configuration information for this instance of
SQL installation.

29) Once you’re done reviewing the summary of features, please click on Install as shown
below and you would notice the installation proceeding further.
30) Finally you would get a window as shown below which displays the status of our installation
and if everything ran well you would notice a bunch of green tick marks. You can view
the “summary log “ file if you want which will give you the complete information of the
installation.
31) Now that brings us to the end of the SQ Server 2014 installation and you can open “SQL
Server Management Studio” to access it.
 2. Install DevExpress
After installing DevExpress

Replace DevExpress.Data.v19.2.dll in these folders:

C:\Windows\Microsoft.NET\assembly\GAC_MSIL\DevExpress.Data.v19.2\[v....]\

C:\Program Files (x86)\DevExpress 19.2\Components\Bin\Framework\

3. Configure IIS
To enable IIS and the required IIS components on Windows 10, do the following:
 1. Open Control Panel and click Programs and Features > Turn Windows features on or off.
2. Enable Internet Information Services.
3. Expand the Internet Information Services feature and verify that the web server
components listed in Required IIS components are enabled.
4. Click OK.

Required IIS components

The IIS components listed below satisfy the minimum requirements to run the Web Adaptor. If
other IIS components are enabled, they do not need to be removed.

 Web Management Tools

o IIS 6 Management Compatibility
 IIS Metabase and IIS 6 configuration compatibility
o IIS Management Console
o IIS Management Scripts and Tools
o IIS Management Service

 World Wide Web Services

o Application Development Features
 .NET Extensibility 4.5
 ASP.NET 4.5
 ISAPI Extensions
 ISAPI Filters
 WebSocket Protocol
o Common HTTP Features
 Default Document
 Static Content
o Security
 Basic Authentication
 Request Filtering
 Windows Authentication

Deploying asp.net application to root directory in IIS

To deploy your application on Windows 10, do the following:

1. Open C:\inetpub\wwwroot
2. Paste your application folder in wwwroot
3. Open Internet Information Services (IIS) manager
4. Expand Sites > Default Web Site
5. Right click on your application folder > Convert to Application
6. Double Click Connection Strings from the Detail pane
7. Edit the data source (Computer Name), Initial Catalog (your database) and your sa
password (SQL super administrator’s password)
 Data Source=XXXXX; Initial Catalog=XX; Integrated Security=false; UID=sa;
Password=XXXXX

Data Base Location

 SQL Server 2014 — C:\Program Files\Microsoft SQL Server\
MSSQL12.MSSQLSERVER\MSSQL\DATA\

Deploy Database

Go to SQL serverRight click on Database Restore

DatabaseDeviceselect the path…

To get application source

http://icsmis.ecsc.gov.et/FederalFields/training/

Download and extract the app sources

Create a folder which is:-Training. Inside this folder put all extract app sources in the above

 Hr
 HrStudy
 Letters
 portalCS