SharePoint Installation Process Part 2

Once we have done through the installation of SQL Server 2008 R2, we will now need to follow the article KB 968872 to open the required ports on the server to connect to an instance of SQL Server.

Copy the text below, paste it in a notepad and name the file OpenSqlServerPort.bat. Run it as an Administrator in the command prompt.

@echo =========  SQL Server Ports  ===================
@echo Enabling SQLServer default instance port 1433
netsh firewall set portopening TCP 1433 "SQLServer" 
@echo Enabling Dedicated Admin Connection port 1434
netsh firewall set portopening TCP 1434 "SQL Admin Connection" 
@echo Enabling conventional SQL Server Service Broker port 4022  
netsh firewall set portopening TCP 4022 "SQL Service Broker" 
@echo Enabling Transact-SQL Debugger/RPC port 135 
netsh firewall set portopening TCP 135 "SQL Debugger/RPC" 
@echo =========  Analysis Services Ports  ==============
@echo Enabling SSAS Default Instance port 2383
netsh firewall set portopening TCP 2383 "Analysis Services" 
@echo Enabling SQL Server Browser Service port 2382
netsh firewall set portopening TCP 2382 "SQL Browser" 
@echo =========  Misc Applications  ==============
@echo Enabling HTTP port 80 
netsh firewall set portopening TCP 80 "HTTP" 
@echo Enabling SSL port 443
netsh firewall set portopening TCP 443 "SSL" 
@echo Enabling port for SQL Server Browser Service's 'Browse' Button
netsh firewall set portopening UDP 1434 "SQL Browser" 
@echo Allowing multicast broadcast response on UDP (Browser Service Enumerations OK)
netsh firewall set multicastbroadcastresponse ENABLE

NOTE: You may not need Misc Application section but please verify your needs before you run the script.

Now that we have necessary ports opened, we will create a domain user account (dotnetscraps\vivek) which will be an Administrator on the WIN-SP (SharePoint) Server and which will be used to install SharePoint 2010. We will also add this account in SQL Server under Security –> Logins and give it dbcreator and securityadmin server role.

Install SharePoint Server 2010

1. I have logged in on the server WIN-SP using the account (dotnetscraps\vivek). This user is also in the Administrators group
2. Insert the installation media, a setup splash screen will appear
3. Click Install software prerequisites
4. SharePoint will display a list of prerequisites that will be installed –> click Next
5. Accept the License Agreement and click Next
6. The Preparation Tool will now download and install all the required prerequisites.
7. You can monitor the %temp% folder to understand the background processing steps. Once the prerequisites are done. We are now ready to install SharePoint 2010.
8. Before I start Installing SharePoint, I thought of moving IIS folders to D: drive rather than the default C: (no force, it’s just me. I would like to make IIS on a different drive). I followed the blog from thomad onIIS7: Moving the INETPUB directory to a different drive.
9. Click Install SharePoint Server
10. Enter the Product Key and Accept the License agreement –> click Continue
11. Always click “Server Farm”NOTE: Standalone installation will create a single stand-alone farm and installs all the component on a single server with SQL Server Express.
12. Always click Complete, the Stand-alone installation option is very similar to the basic Standalone installation as mentioned earlier.
13. Click Install Now
14. During this process the setup will copy the correct bits on the server, installs necessary Services and prepares the server for configuration.
15. Finally, you will get the Run Configuration Wizard screen.
    I will not run it right now as I will also install Microsoft Office Web Apps which will get integrated with SharePoint.

Install Office Web App

1. You can download the beta version from Microsoft downloads.
2. Insert the media and the installer will launch.
3. Enter the Product Key and Accept the License agreement –> click Continue
4. Change the folder location to store search index files, I changed it to “D:\Program Files\Microsoft Office Servers\14.0\Data”
5. Click Install Now
6. The wizard copies the required bits on the server and gets it ready for configuration
7. Finally, you will get the Run Configuration Wizard screen.
8. Click Close and the Product Configuration Wizard will start

for more info please visit http://www.sharepointreferences.wordpress.com