Ms SQL Server
Installing
Ms SQL Server 2012
Lecturer: Heng Bora Page 1
Ms SQL Server
I. Introduction
Microsoft SQL Server is a relational database management system developed by Microsoft Inc.. As
a database, it is a software product whose primary function is to store and retrieve data as requested by other
software applications, be it those on the same computer or those running on another computer across a
network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed
at different audiences and for different workloads (ranging from small applications that store and retrieve
data on the same computer, to millions of users and computers that access huge amounts of data from the
Internet at the same time). Its primary query languages are T-SQL and ANSI SQL.
II. Introduction
Microsoft® SQL Server® 2012 Express is a powerful and reliable free data management system that
delivers a rich and reliable data store for lightweight Web Sites and desktop applications
System Requirement
Supported Operating System
Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista
Service Pack 2
• 32-bit systems
• Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is
recommended.)
• 64-bit systems
• 1.4 GHz or faster processor
• Minimum of 512 MB of RAM (2 GB or more is recommended.)
• 2.2 GB of available hard disk space
Lecturer: Heng Bora Page 2
Ms SQL Server
Practical Learning: Installing Microsoft SQL Server
1. Start the computer
2. Insert the DVD in the drive. You may (should) receive a dialog box with a Run SETUP.EXE link:
If so, click Run SETUP.EXE. Otherwise, click Open Folder, then double-click Default.htm, click the
version you want to install, and double-click setup
3. The installation will start:
In the left section, click Installation
Lecturer: Heng Bora Page 3
Ms SQL Server
4. If you are only interested in studying database design and development in Microsoft SQL Server, on
the right side, click New SQL Server Stand-Alone Installation or Add Features to an Existing
Installation.
The installation would start:
Lecturer: Heng Bora Page 4
Ms SQL Server
5. Click OK
6. The next page of the wizard asks you to enter a product key. Type it and click Next
7. The License Terms page is presented to you. Read it. If you don't agree with the license, click
Cancel:
Lecturer: Heng Bora Page 5
Ms SQL Server
Otherwise, click the I Accept check box:
8. Click Next
9. Read the messages and click Install
10. You may receive a warning message about the firewall:
Lecturer: Heng Bora Page 6
Ms SQL Server
For now, ignore it (there is no true justfication in trying to disable the firewall, the installation will proceed
fine).
Click Next
Lecturer: Heng Bora Page 7
Ms SQL Server
11. The next page of the wizard is for the setup rolect. After making your selecti0n, click Next
12. The next page allows you to specify what you want to install and what would be left out. Make your
selections:
Lecturer: Heng Bora Page 8
Ms SQL Server
The eventual location of Microsoft SQL Server is specified in the bottom text box
13. After making your selections, click Next
14. The next page runs and checks the rules of the installation.
Check Next
15. The next page allows you to name the instance of Microsoft SQL Server (and to specify where the
server would be installed). In most cases, you should accept the suggested name of the instance as
MSSQLSERVER:
Lecturer: Heng Bora Page 9
Ms SQL Server
After making your selections, click Next
16. The next page mostly allows you to check and confirm the disk space:
After checking it, click Next
Lecturer: Heng Bora Page 10
Ms SQL Server
17. The next page presents a summary of the server configuration:
After checking it, click Next
18. In the next page, specify the account used as the administrator. To do this, you can click Add Current
User:
Lecturer: Heng Bora Page 11
Ms SQL Server
19. Click Next
20. The next step allows you to specify an account for the analysis services. Click Add Current User
Lecturer: Heng Bora Page 12
Ms SQL Server
21. Click Next.
The Reporting Services Configuration page displays
22. Click Next. If the Distributed Replay Controller page displays, click Add Current User
Lecturer: Heng Bora Page 13
Ms SQL Server
Click Next
23. The Installation Configuration Reules oage may come up:
Click Nex
Lecturer: Heng Bora Page 14
Ms SQL Server
24. The next page presents the Distributed Replay Client
Click Next
25. The next page presents the error reporting
Click Next
26. We get back to the Installation configuration Rules.
Click Next
Lecturer: Heng Bora Page 15
Ms SQL Server
27. The next page gives you a summary of tests that were performed before the installation:
To start the installation, click Install
28. The installation would start and a progress bar would indicate the evolution. This can take a while
29. When this phase is over, the next page will let you know that the installation is over
Lecturer: Heng Bora Page 16
Ms SQL Server
After reading the message, click Close
30. Restart the computer
Lecturer: Heng Bora Page 17
