Dell POWEREDGE DL385 - Manual (Page 14)

14 Principled Technologies, Inc.: Initial investment payback analysis: Dell PowerEdge R710
solution with VMware ESX vs. HP ProLiant DL385 solution
22. On the Instance configuration screen, leave the default selection of default instance, and click Next.
23. On the Disk space requirements screen, click Next.
24. On the Server configuration screen, choose NT AUTHORITY\SYSTEM for SQL Server Agent, and
choose NT AUTHORITY\SYSTEM for SQL Server Database Engine. Click Next.
25. On the Database Engine Configuration screen, select Mixed Mode.
26. Enter a password for the system administrator account.
27. Click Add Current user. This may take several seconds.
28. Click Next.
29. On the Error and usage-reporting screen, click Next.
30. On the Installation rules screen, click Next.
31. On the Ready to Install screen, click Next.
32. After installation completes, click Start, All Programs, Microsoft SQL Server 2008, Configuration Tools,
SQL Server Configuration Manager.
33. Expand the Network Configuration node, and select the relevant instance.
34. In the right pane, right-click TCP/IP, and choose Enable.
35. In the left pane, click SQL Server Services.
36. In the right pane, right-click the SQL Server service, and select Restart.
37. Click Start, Administrative Tools, and Local Security Policy.
38. Double-click Perform Volume Maintenance Tasks, and add the System account.
39. Double-click Lock Pages in Memory, and add the System account.
40. Create a SQL Server login for the ds2user (see the DVD Store setup section below for the specific script
to use).
41. Place the DVD Store backup file you prepared in the default location for SQL Server: C:\Program
Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup.
Installing SQL Server 2008 SP1
Service Pack 1 is available for download from
http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-
ccc6a4f9dc19&displaylang=en
.
1. Run SQLServer2008SP1-KB968369-x64-ENU.exe.
2. On the Welcome screen, click Next
3. On the License terms screen, accept the license terms, and click Next.
4. On the Features screen, select available features, and click Next.
5. On the Check files in use screen, click Next.
6. On the Update screen, click Next.
7. When the update completes, click Next, and click Close.
Adding an additional virtual drive to the VM via vSphere for SQL Server transaction logs
1. Power off the VM, right-click and choose Edit Settings.
2. Click
Add.
3. Choose Hard Disk, and click Next.
4. Choose Create a new virtual disk, and click Next.
5. Choose 5GB for the size and select Specify a datastore. Click Browse.
6. Select the internal volume SQL Server log datastore. Click OK.
7. Click
Next.
8. Click Next.
9. Click Finish.
10. Click OK.
Adding two additional drives to the VM for SQL Server data via the iSCSI initiator
1. Power on the VM, and open the console.
2. Click Start, Control Panel, and double-click iSCSI Initiator.
3. Click the Discovery tab.
4. Click Add Portal…
5. Add the IP address of the Dell EqualLogic storage group.