Project: Sharepoint 2010 +SQL Server 2008R2 on Poweredge 2850

From Evernote:

Project: Sharepoint 2010 +SQL Server 2008R2 on Poweredge 2850

Objective: To deploy Sharepoint 2010 and SQL Server 2008R2 on a production server [PE2850]
Date: 20110901
Hardware and Software Information:
Dell Poweredge 2850, 2.8GHz Xeon 8GB Memory
Drive0-73GB, c: mirror
Drive1-73GB, c: mirror
Drive2-73GB, v: mirror
Drive3-73GB, v: mirror
Drive4-150GB, y: backup
Drive5-150GB, f: sqldata

Software:
OS-Windows 2008R2 Data Center
Sharepoint 2010 Enterprise
SQL Server 2008 R2

Phase 1.0 OS Installation
1. Install Windows 2008 R2 OS
2. Activate Server
3. Run Windows Update
4. Add server to Active Directory
5. Copy Sharepoint 2010 to c:
6. Copy SQL2008 setup files to c:

Phase 2.0 SQL Server Installation
7. Run SQL Server 2008 R2 setup
8. Choose New Installation
9. Support Rules installation->Requirements all pass, 7 items ->Click OK
10. Enter Product Key
11. Accept the Terms-> Click Next
12. Install Setup Support Files
13. Review the warnings, 11 items – 1 yellow Windows Firewall -Click Next
14. SQL Server Feature Installation-Install all features, Pass-6, Failed-0 Warning-0, Skipped-18
15. Select Default Instance
16. Review Disk Space Requirments, 6109 GB Required, 48362 Available
17. Choose Service Accounts
SQL Service Agent, NT Authority\System, Manual
SQL Server Database Engine, NT Authority\System, Automatic
SQL Server Analysis Service, NT Authority\System, Automatic
SQL Server Reporting Service, NT Authority\System, Automatic
SQL Server Integration Service, NT Authority\System, Automatic
SQL Server Full Text Filter, NT Authority\Local Service, Manual
SQL Server Browsing, NT Authority\Local Service, Disabled
18. Choose DB Engine Configuration-Windows Authentication
19. Click Add Current User
20. In Data Directories, choose f: drive [sqldata]
21. In Analysis Service, Add current user
22. In Reporting Service, Select “Install the Sharepoint Integrated Mode”
23. In Error Reporting, Click Next
24. In Installation Configuration Rule, Pass-6, Failed-0, Warning-0, Skipped-2
25. In Summary, Click Install
26. Install SQL 2008 Updates and SP1

Phase 3.0 SQL Server Configuration
27. In Windows Firewall, Advanced Settings, Add an Inboud Rule SQL 2008 Port1433, TCP
28. Enable TCP/IP Protocol in SQL Configuration Manager

Phase 4.0 Sharepoint 2010 Installation
29. Install Sharepoint 2010-Install Prerequisite
30. Install Sharepoint 2010-Enter Key
31. Choose Server Farm [Do not install the Stand Alone, or SQL Server Express will be installed]
32. Select Server Type, Complete
33. Setup Complete
34. Run Windows Update and update everything
35. Install Sharepoint 2010 SP1
36. Run Windows Update again

Phase 5.0 Sharepoint 2010 Configuration
37. Run Sharepoint 2010 Product Configuration
38. Select Create a new server farm
39. Set Sonfiguration Database as:
DB Server=PE2850
DB name=WSS_Config
Username=vdomain\adminstrator
Passphrase=
40. Specify the Port – 7000 and choose NTLM
41. Review the Settings – http://pe2850:7000
42. Run Initial Farm Configuration Wizard
43. Complete the Wizard and http://pe2850:7000 Central Admin Site opens
44. In Customer Experience, Select No, I do not wish to participate
45. Run the Sharepoint Farm Wizard, Click Start Wizard
Service Account-vdomain\spadmin
Service – Select all but Lotus
46. Create a Top Level Site [Enterprise Wiki]
Title-Rigel Research International
URL-http://pe2850
Template-Enterprise Wiki
47. Test the new site
Phase 6.0 Firewall Configuration
48. Open Firewall Exception at Router, 192.168.1.5 Port 8000
49. Open Firewall Exception at Windows Firewall, 192.168.1.5 Port 8000
50. Open IIS Manager, Change Sharepoint-80 binding from Port from 80 to 8000

Phase 7.0 Old Sharepoint 2010 Migration of SQL Data
51. Verify new farm site functionality, http://pe2850
52. Open Central Admin->Manage Web Application->Confirm Site name-Sharepoint-80
53. In Central Admin, Click Manage Content Database and Check “Remove Database”
54. Copy the old WSS_Content.mdf and WSS_Content_Log.ldf to f:\SQLData Location
55. Open SQL Management Studio
56. Right Click WSS_Content database->Task->Detach->Click OK
57. Go to SQL Data Location->Rename the current WSS_Content.mdf to WSS_Contentx.mdf
58. Go to SQL Data Location->Rename the current WSS_Content_Log.ldf to WSS_Content_Logx.ldf
59. Rename the copied backup copy to WSS_Content.mdf and WSS_Content.ldf
60. In SQL Management Studio, Right Click Database->Attach->Add
61. Select WSS_Content.mdf [the old copy]
62. In SQL Management Studio-> Security-> Logins
63. Right Click vdomain\Administrator->Properties-User mapping->Set to dbo for WSS_Content
64. Right Click vdomain\spadmin->Properties-User mapping->Set to dbo for WSS_Content
65. In Central Admin, Click Manage Content Database->Add Database
66. Set Database Configuration
Database Server=PE2850
DB Name=WSS_Content
67. Select Windows Authentication
68. Open IE and test http://pe2850/sites/intranet
69. Confirm that Search Functionality is not working at this time

Phase 8.0 Sharepoint Search Server Configuration
70. In Central Admin, Click Notice from Health Analyzer->View these issues
71. Confirm no crital errors and no Certificate token errors
72. In Central Admin, Click Manage Service Application
73. Select Search Service Application and Click Manage Icon from the Ribbon Toolbar
74. Click Content Sources and Click Local Sharepoint Site
75. Set the following
a. Setup Full Crawl, Daily at 12am
b. Setup Incremental Crawl at 12pm
c. Check-Start Full Crawl Now
76. Click the Refresh Link to see the status
77. Open Task Manager and monitor CPU and Disk I/O of mssearch.exe
78. Open IE and confirm Sharepoint Search Functionality

Phase 9.0 Adobe iFilter Configuration
79. In Central Admin, General Security->Define Blocked Type and check if pdf is not list
80. In Central Admin, Manage Service Application->Search Service Application-Click Manage
81. In Left Pane, Click File Types->New File Type->Enter pdf and Click OK
82. Read and implement kb/2293357
83. Install Adobe iFilter Pack 9.0 x64
84. Download pdf icon and place to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES\ folder
85. Add Entry to docicon.xml located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML
<Mapping Key=”pdf” Value=”pdficon_small.gif”/>
86. Reboot Sharepoint Server
87. Execute Full Crawl again
88. Open IE and confirm Search Functionality with pdf icon showing.