Step 1 |
Mount the Microsoft SQL Server 2008 ISO image to the virtual machine. |
Step 2 |
Run setup.exe. |
Step 3 |
Select Installation on the left pane and then click New installation or add features to an existing installation and then click OK. |
Step 4 |
On the Setup Support Rules page, click Ok. |
Step 5 |
On the Setup Support page , click install. |
Step 6 |
On the Product Key page, enter the product key and click Next. |
Step 7 |
Accept the Licence Terms and click Next. |
Step 8 |
on the Setup Support Rules page click Next. |
Step 9 |
On the Feature Selection page, click Select All and then click Next. |
Step 10 |
On the Installation Rules page, click Next. |
Step 11 |
On the Instance Configuration page, select Default Instance . Click Next. |
Step 12 |
On the Disk Space Requirements page, click Next. |
Step 13 |
On Server Configuration page, click the Services Account tab.
-
For Service SQL Server Agent, select Account Name NT AUTHORITY\SYSTEM and Startup Type Automatic.
-
For Service SQL Server Database Engine. select Account Name NT AUTHORITY\SYSTEM.
-
For Service SQL Server Analysis Services, select Account Name NT AUTHORITY\SYSTEM.
-
For Service SQL Server Reporting Services, select Account Name NT AUTHORITY\SYSTEM.
|
Step 14 |
Remain on the Server Configuration page and click the Collation tab.
-
Click Customize.
-
Click the radio button Windows Collation designator and sort order.
-
Select Collation designator as Latin1_General. and check Binary.
-
Click OK. Click Next. on the Server Configuration page.
-
Click Next.
|
Step 15 |
On the Database Engine Configuration page:
-
Check Mixed Mode.
-
Enter your password and confirm it by reentering it.
-
Click Add Current User.
-
Click Next.
|
Step 16 |
On the Analysis Services configuration page, click Add current user and then click Next. |
Step 17 |
On the Reporting Server configuration, check the radio button for Install but do not configure the report |
Step 18 |
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 at the Complete page. |
Step 23 |
Install SQL Server 2008 R2 Service Pack 1 x64. Follow the Wizard and accept all defaults. |
Step 24 |
Enable Named Pipes and set the sort order as follows:
-
Open the SQL Server Configuration Manager.
-
In the left pane, choose the SQL Native Client 10.0 Configuration (32bit) > 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, choose SQL Server Network Configuration > Protocols for MSSQLSERVER.
-
In the right pane, right-click Named Pipes and select Enable.
-
In the right pane,right-click TCP/IP and select Enable.
|
Step 25 |
Enable autogrow as follows:
-
Choose Start > All Programs > Microsoft SQL Server 2008R2 > SQL Server Management Studio.
-
Click Connect > Databases. Then expand System Databases.
-
Right-click tempdb and select Properties.
-
Check Enable Autogrowth. Set In Percent to 10. Click OK.
|
Step 26 |
Restart the SQL Server service.. |