Step 1
| Mount the
Microsoft SQL Server 2008 ISO image to the virtual machine.
|
Step 2
| Run setup.exe.
|
Step 3
| Click
Installation on the left pane and then click
New installation or add features to an existing
installation.
The SQL
Server 2008 R2 Setup wizard opens.
|
Step 4
| On the Setup
Support Rules page, click
OK.
|
Step 5
| On the
Product Key page, enter the product key and click
Next.
|
Step 6
| Accept the
Licence Terms and click
Next.
|
Step 7
| On the
Setup Support Files page, click
Install.
|
Step 8
| On the Setup
Support Rules page, click
Next.
|
Step 9
| On the Setup
Role page, select
SQL Server Feature Installation, and click
Next.
|
Step 10
| On the Feature
Selection page, click
Select All, and click
Next.
|
Step 11
| On the
Installation Rules page, click
Next.
|
Step 12
| On the
Instance Configuration page, select
Default Instance. Click
Next.
|
Step 13
| On the Disk
Space Requirements page, click
Next.
|
Step 14
| On the Server
Configuration page, under
Service Accounts tab, perform the following:
- For
Service SQL Server Agent, select Account Name as
NT AUTHORITY\SYSTEM and Startup Type as
Automatic.
- For
Service SQL Server Database Engine, select Account Name as
NT AUTHORITY\SYSTEM.
- For
Service SQL Server Analysis Services, select Account Name as
NT AUTHORITY\SYSTEM.
- For
Service SQL Server Reporting Services, select Account Name as
NT AUTHORITY\SYSTEM.
|
Step 15
| On the
Server Configuration page, select
Collation tab, and click
Customize for Database Engine.
Note
| Skip
Step 16, for Unified WIM and EIM.
|
- Select
the
Windows Collation designator and sort order radio
button.
- Select
Collation designator as Latin1_General from the
drop-down and check the
Binary check-box.
- Click
OK. Click
Next on the Server Configuration page.
- Click
Next.
|
Step 16
| On the
Database Engine Configuration page, under
Account Provisioning tab, perform the following:
- For
Authentication Mode, select
Mixed Mode.
- Enter
your password and confirm by reentering it.
- Click
Add Current User.
- Click
Next.
|
Step 17
| On the
Analysis Services Configuration page, click
Add
current user, and click
Next.
|
Step 18
| On the
Reporting Services Configuration page, select the
Install, but do not configure the report server
radio button, and click
Next .
|
Step 19
| Click
Next on the
Error Reporting page.
|
Step 20
| Click
Next on the
Installation Configuration Rules page.
|
Step 21
| Click
Install on the
Ready to Install page.
|
Step 22
| Click
Close on the
Complete page.
|
Step 23
| Install SQL
Server 2008 R2 Service Pack 1 x64. Follow the Wizard and accept all defaults.
|
Step 24
| To enable
Named Pipes and set the sort order, perform the following:
- Navigate
to
.
- In the
left pane, expand SQL Native Client 10.0 Configuration (32bit), and select
Client Protocols.
- In the
right pane, right-click
Named
Pipes, and select
Order.
- In the
Client Protocols Properties window, select
Named Pipes, and click
Move Up or
Move Down to change the order of the protocols as
follows: Shared Memory, Named Pipes, TCP/IP, then click
OK.
- In the
left pane, expand SQL Server Network Configuration, and select
Protocols for MSSQLSERVER.
- In the
right pane, right-click
Named Pipes, and select
Enable, and click
OK.
- In the
right pane, right-click
TCP/IP, and select
Enable.
|
Step 25
| To enable
autogrow, perform the following:
- Navigate
to
.
- Click
Connect. In the left pane, expand
Databases > System Databases.
- Right-click tempdb and select
Properties.
- In the
left pane, select
Files. Ensure that
AutoGrowth is enabled for tempdev and templog with
Unrestricted File Growth.
- Set
initial size (MB) as
1400 for tempdev and
1024 for templog and click
OK.
|
Step 26
| Restart the
SQL Server service.
|