discovering sql all rights reserved (c) 2010 agilitator.com installing ms sql server 2008 r2 express...
TRANSCRIPT
![Page 1: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/1.jpg)
Discovering SQL
all rights reserved (c) 2010 agilitator.com
INSTALLING INSTALLING
MS SQL Server 2008 R2MS SQL Server 2008 R2
Express Edition Express Edition
![Page 2: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/2.jpg)
all rights reserved (c) 2010 agilitator.com
Download MS SQL Server 2008 R2 from the Microsoft official site:
http://www.microsoft.com/express/database/
32-bit
Double click on the SQLEXPRWT_x86_ENU.exe icon
![Page 3: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/3.jpg)
3all rights reserved (c) 2010 agilitator.com
![Page 4: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/4.jpg)
4all rights reserved (c) 2010 agilitator.com
Allow installation to proceed by clicking [Yes] button
![Page 5: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/5.jpg)
5all rights reserved (c) 2010 agilitator.com
![Page 6: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/6.jpg)
6all rights reserved (c) 2010 agilitator.com
Click [New installation or add featured to an existing installation] link to start the installation
![Page 7: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/7.jpg)
7all rights reserved (c) 2010 agilitator.com
![Page 8: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/8.jpg)
8all rights reserved (c) 2010 agilitator.com
![Page 9: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/9.jpg)
9all rights reserved (c) 2010 agilitator.com
![Page 10: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/10.jpg)
10all rights reserved (c) 2010 agilitator.com
Accept the License AgreementClick [Next] button
![Page 11: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/11.jpg)
11all rights reserved (c) 2010 agilitator.com
![Page 12: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/12.jpg)
12all rights reserved (c) 2010 agilitator.com
![Page 13: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/13.jpg)
13all rights reserved (c) 2010 agilitator.com
![Page 14: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/14.jpg)
14all rights reserved (c) 2010 agilitator.com
Select the Database Engine Services and Management Tools - Basic options and click [Next] button
![Page 15: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/15.jpg)
15all rights reserved (c) 2010 agilitator.com
Select the Default Instance optionClick [Next] button
![Page 16: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/16.jpg)
16all rights reserved (c) 2010 agilitator.com
Select the [Collation] tab
![Page 17: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/17.jpg)
17all rights reserved (c) 2010 agilitator.com
Select the SQL_Latin1_General_CP1_CI_AS option; this defines how your data will be searched and compared.
Click [Next] button
![Page 18: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/18.jpg)
18all rights reserved (c) 2010 agilitator.com
Select the Windows Authentication Mode option to use your Windows account to connect to database; alternatively you may specify Mixed
Mode, and supply User ID and Passwordand then select the Data Directories tab.
Click [Next] button
![Page 19: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/19.jpg)
19all rights reserved (c) 2010 agilitator.com
Unless you understand ramifications, it is recommended that accept all defaults for the Discovering SQL purposes
Click [Next] button
![Page 20: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/20.jpg)
20all rights reserved (c) 2010 agilitator.com
Click [Next] button
![Page 21: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/21.jpg)
21all rights reserved (c) 2010 agilitator.com
The installation could take some time dependingon your computer’s hardware configuration
![Page 22: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/22.jpg)
22all rights reserved (c) 2010 agilitator.com
Click [Close] button
![Page 23: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/23.jpg)
23all rights reserved (c) 2010 agilitator.com
This screen shows the MS SQL Server 2008 R2 Express database service running on your Windows
machine (the console is accessible from the Administrative Tools menu).
![Page 24: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/24.jpg)
all rights reserved (c) 2010 agilitator.com
MS SQL Server 2008 Express R2Limitations
• 1GB of addressable RAM (computer memory), • will only use single CPU• only one database can be installed for the instance• the size of the database is limited to 10GB
![Page 25: Discovering SQL all rights reserved (c) 2010 agilitator.com INSTALLING MS SQL Server 2008 R2 Express Edition](https://reader035.vdocuments.us/reader035/viewer/2022062314/56649c7d5503460f94931fac/html5/thumbnails/25.jpg)
all rights reserved (c) 2010 agilitator.com
Screenshots for this presentation were prepared by Dzmitry Aliaksandrau, CCNA®