Last modified: 24 Jul 2008

This feature is in the process of development now. For all questions and feedback, please contact us.

This document gives you information on how to install Microsoft Windows SharePoint Services on your Windows 2003 web servers.

According to Microsoft, Windows SharePoint Services technology "is an integrated portfolio of collaboration and communication services designed to connect people, information, processes, and systems both within and beyond the organizational firewall. SharePoint sites provide a central repository for documents, information, and ideas, and enable users to work interactively with these items."

Currently we support Windows SharePoint Services v2 with Service Pack 2. Support for later versions is coming soon.

• Pre-Installation Requirements
• SharePoint Installation and Configuration
  1. Install MSSQL Server
  2. Select Authentication Mode for SQL Server
  3. Install SharePoint
  4. Configure H-Sphere to use SharePointB

Pre-Installation Requirements

Before you install Microsoft Windows SharePoint Services on your Web server, make sure that you have installed the required hardware and software.

* Microsoft Windows SharePoint Services SQL Server 2000 Desktop Engine (WMSDE) is not supported by H-Sphere

SharePoint Installation and Configuration

To install and configure SharePoint Services, follow the procedure:

 Step 1: Install MSSQL Server

Prior to installing SharePoint, you need to install MSSQL Server. You can chose between:

• MSSQL Server 2000
• MSSQL Server 2005

 Step 2: Select Authentication Mode for SQL Server

In order to allow Windows SharePoint Services to connect to your SQL Server database, it is recommended that you configure the SQL Server database to use Windows authentication.

For SQL Server 2000:

1. On your server computer, go to Start -> All Programs -> Microsoft SQL Server -> Enterprise Manager.
2. In Enterprise Manager, click the plus sign (+) next to Microsoft SQL Servers.
3. Click the plus sign (+) next to the SQL ServerGroup.
4. Right-click the SQL Server name, and go to Properties.
5. In the Properties dialog box, click the Security tab.
6. In the Authentication section:
• If you want use the MSSQL Server only for Microsoft Windows SharePoint Services, select only Windows Authentication mode.
• If you want use the MSSQL Server both for Microsoft Windows SharePoint Services and hosting, select SQL Server and Windows Authentication mode.
7. Click OK.

Note: If you have used a domain account that does not already have database creation rights in SQL Server, you can give the account this access using Enterprise Manager in SQL Server 2000, as a temporary solution.

For SQL Server 2005

1. On your server computer, go to Start -> All Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio.
2. On the Connect to Server screen, select the name of the local server from the Server name drop-down list.
3. On the Server Properties - Server name screen, click Security in the Select a page section.
4. In the Server Authentication section:
• If you want use the MSSQL Server only for Microsoft Windows SharePoint Services, select only Windows Authentication mode.
• If you want use the MSSQL Server both for Microsoft Windows SharePoint Services and hosting, select SQL Server and Windows Authentication mode.
5. Click OK.

Note: If you have used a domain account that does not already have database creation rights in SQL Server, you can give the account this access using SQL Server Management Studio, as a temporary solution.

 Step 3: Install SharePoint

By default, when you install Windows SharePoint Services, the Setup program installs WMSDE (Microsoft Windows SharePoint Services SQL Server Desktop Engine).
H-Sphere doesn't support WMSDE. To use SharePoint with SQL Server, run Setup with the Server Farm option. Server Farm option allows supporting a larger set of Web sites.

1. Download and install SharePoint
WARNING:
During SharePoint setup, you may get the error when connecting to http://localhost:SharePointPort/. To solve it, you should remove the string <identity impersonate="true" /> from
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\template\admin\1033\web.config.

Also please check the Authentication Methods for SharePoint Central Administration WebSite in IIS. And if Basic authentication is disabled, enable it.
2. Go to SharePoint Central Administration:
   Start/Settings/Control Panel/Administrative Tools/SharePoint Central Administration
3. Configure Administrative Virtual Server in the Server Configuration tab:
• Select Use an existing application pool and chose StsAdminAppPool
• Go to Security Configuration and select NTLM
• Click OK
4. Configure Database Server in the Server Configuration tab:
• Select Database Server and enter your MSSQL Server IP or MSSQL instance
• In SQL Server database name enter your SharePoint Main DB NAME
• Set Windows authentication
5. In Active Directory Account Creation chose Users already have domain accounts. Do not create active directory accounts.
6. Click OK

 Step 4: Configure H-Sphere to use SharePoint

1. If you installed Microsoft Windows SharePoint Services after H-Sphere is updated, run the H-Sphere updater again.
2. Open HSphere.config file usually located
   • in the {disk}\Hsphere.NET\bin\ directory (for H-Sphere 3.0 branch)
   • in the {disk}\Program Files\HSphere\Config\ directory (for H-Sphere 3.1 and up)
   and make sure the correct name of your MSSQL server was set in the SharePoint resource setting during H-Sphere update.
3. Restart H-Sphere service

   net stop hsphere
   net start hsphere