Installing Microsoft Office SharePoint Server 2007 on Windows Server 2008
Instructions to build a SharePoint development machine using MOSS 2007, Windows Server 2008, SQL Server 2008, and Visual Studio 2008. This will create a single server installation for SharePoint development.
Note: These instructions are a modified set of instructions originally based on a posting by Andreas Glaser:
http://andreasglaser.net/post/2008/08/14/Installing-MOSS-2007-on-Windows-Server-2008-and-SQL-Server-2008-Part-1-Overview.aspx
Windows Server 2008 Installation
-
Install Windows Server 2008 or Windows Server 2008 R2.
-
Run Windows Update to get all the critical and recommended updates.
-
Install antivirus software.
Domain Accounts
In order to set up a MOSS 2007 farm you need the following domain accounts. Please remember that this is just an example and that there are different naming conventions.
|
Account name |
Account type |
|
SqlService |
SQL Service |
|
MossFarm |
MOSS Farm Service Account |
|
MossWeb |
MOSS Web Application Service Account |
|
MossSspAdmin |
MOSS SSP Admin Service (Application Pool) |
|
MossSspMySite |
MOSS SSP MySite Service (Application Pool) |
|
MossSspService |
MOSS SSP Service (Application Pool) |
|
MossSearchService |
MOSS Search Service |
|
MossProfile |
MOSS Profile Import |
|
MossExcel |
MOSS Excel Services |
|
WssSearchService |
WSS Search Service |
|
WssContentAccess |
WSS Search Content Access |
For each user above:
-
Add the user to your Active Directory.
-
Set the password.
-
Check "User cannot change password".
-
Check "Password never expires".
Script to Create User Accounts
The user accounts can optionally be created using the following script. Replace the myPassword, myDC, and myDcExt with the appropriate values for your domain. The following script creates the user accounts for the WagnerVN.local domain. Yours should be different. MossPoolWebPortal
Script: (CreateAccounts.cmd)
Rem Create accounts for the WagnerVN.local domain:
set myPassword=YOUR-PASSWORD
set myDC=WagnerVN
set myDcExt=local
dsadd user cn="SqlService,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "SQL Service" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="MossFarm,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "MOSS Farm Service Account" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="MossWeb,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "MOSS Web Application Pool" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="WssSearchService,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "WSS Search Service" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="WssContentAccess,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "WSS Search Content Access" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="MossSspPoolAdmin,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "MOSS SSP Admin Application Pool" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="MossSspPoolMySite,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "MOSS SSP MySite Application Pool" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="MossSspService,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "MOSS SSP Service" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="MossSearchService,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "MOSS Search Service" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="MossProfile,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "MOSS Profile Import" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
dsadd user cn="MossExcel,cn=users,dc=%myDC%,dc=%myDcExt%" -desc "MOSS Excel Services" -mustchpwd no -pwdneverexpires yes -canchpwd no -pwd %myPassword% -disabled no
Web Server (IIS7) Installation
-
Add the "Application Server" role to your server and add the required features. Note: You don't have to add the server role. You can also add the .NET Framework 3.0 Features instead.
-
Add the "Web Server (IIS)" server role.
-
Click through the role services for the Application Server.
-
Select the ASP.NET role service and add the required features for the Web Server (IIS) role.
-
Select "Basic Authentication" and "Windows Authentication".
-
Click next until the wizard has finished the installation process.
SQL Server 2008 Installation
-
Start the "setup.exe" of your SQL Server 2008 installation DVD.
-
Note: You may be prompted to install the .NET Framework 3.5 SP1 if you have not already done so. If so, you need to run Windows Update to get any updates.
-
Click "Installation" (on the left side).
-
Click "New SQL Server stand-alone installation or add features to an existing installation".
-
Select your version of SQL Server 2008. I usually select the Standard version.
-
After installing the setup support files you are prompted that there are some warnings. You can ignore the Windows Firewall and Computer Domain Controller warnings since this is for a development environment.
-
Select the "Database Engine Services" feature.
-
Select the "Management Tools" feature, and click Next.
-
Keep the default instance checked, and click Next.
-
After validating the hard disk requirements you have to select a services account, click Next.
-
Click “Use the same account for all SQL Server services”.
-
Enter your SQL Service domain account.
-
You don't need to change the default collation settings given by the installation wizard, click Next.
-
Select “Windows Authentication”.
-
Click “Add Current User” as a SQL Server administrator.
-
Click Next a few times to start the installation.
SQL Server 2008 Service Pack 1 Installation
SQL Server 2008 Configuration
-
Open SQL Server Configuration Manager.
-
Expand the SQL Server Network Configuration node.
-
Select the Protocols for MSSQMSERVER node.
-
You have to enable "Named Pipes".
SharePoint Installation User Account Permissions
To install all software (SQL Server, IIS7, MOSS 2007), use a Domain Administrator account.
Or
To create a special installation user account, do the following:
After creating the specified domain accounts you need to assign permission for the SetupAdmin user account. After installing the SQL Server you should continue with the following steps.
-
First, connect to the SQL Server using the Management Studio and create a new login.
-
Select the SetupAdmin account and assign the following roles to that account: dbcreator and securityadmin.
-
After finishing you can see your account listed next to the others.
-
At the end you need to put the SetupAdmin account in the administrators group on every Application and Front-end server.
SharePoint 2007 Installation
Note: You can download a MOSS 2007 installation DVD/ISO including SP1 from Microsoft. You must install SharePoint Server 2007 with SP1 to install on a Windows Server 2008 or Windows Server 2008 R2.
-
Start the SharePoint Server 2007 setup.
-
Select “Advanced” installation mode.
-
Select "Complete - Install all components. Can add servers to form a SharePoint farm."
-
The installation process will take a few minutes.
-
Note: SharePoint Configuration will be done later, after backing up the image.
Visual Studio 2008 Installation
-
Install Visual Studio Team System 2008.
-
Install Visual Studio Team Explorer 2008.
-
Note: Do not install the Visual Studio 2008 Service Pack 1 at this time. This will be done soon.
Microsoft Office InfoPath 2007 Installation
This is only needed if you plan to develop using InfoPath 2007 forms.
-
Install InfoPath 2007 and Visual Studio Tools for Applications. This option is under of the InfoPath installation option, under the .NET Programmability Support section.
Note: Other application such as Word, Excel, and Access may be useful.
Visual Studio 2008 Service Pack 1
Windows Update
Run Windows Update to get the latest updates for all the installed products.
Backup Your Virtual Machine Image NOW
I strongly suggest you backup your virtual machine image at this point. This will allow you to easily roll back to this back with everything installed, but with SharePoint not configured. This will allow you to have a fresh installation of SharePoint that you can configure as needed.
Done backing up? Okay...
SharePoint 2007 Configuration
-
Start the “SharePoint Products and Technologies Configuration Wizard”.
-
Select "No, I want to create a new server farm".
-
Enter the name of your Database Server (i.e the name of your machine).
-
Enter the name of your SharePoint Database Access Account (i.e. domain\MossFarm), click Next.
-
Specify the port number for Central Administration and the authentication provider. I suggest picking a number you can easily remember (i.e. 25000) on your development machine.
-
Click Next.
-
Review your configuration and if everything looks correct, click Next.
-
When the configuration wizard has finished, the SharePoint Central Administration site is now ready for use.
Create the Main (Port 80) Web Application
The only reason I prefer to create my main (port 80) web application first is so that it will be the default web application when working in Central Administration. This can be done now or later.
-
In Application Management, go to the “Create or extend Web application” page.
-
Click “Create new Web application”.
-
Enter port 80.
-
Enter the account for the (domain\MossWeb).
-
You can create your default site collection for this web application now or later.
Start SharePoint Services
-
Open “SharePoint 3.0 Central Administration”.
-
On the Home tab click your server name.
-
Start the “Windows SharePoint Search Service” service.
-
Start the “Office SharePoint Server Search” service.
-
Enter the service account (domain\MossSearchService).
-
Check both “Use this server for indexing content” and “Use this server for serving search queries”.
-
Enter an email account.
-
Optionally, select Reduced for the Indexer Performance, since this is a development machine.
-
Optional: Start the "Excel Calculation Services". I suggest not starting this unless you need it.
Shared Services Provider
-
Creating the My Site web application:
-
In Application Management, click the “Create or extend Web application” link.
-
Click “Create new web application”.
-
Enter the port number for your My Site web application (i.e 25001).
-
Optional: Append “MySite” to the description (i.e. “SharePoint - 25001 - My Site”).
-
Optional: Append “MySite” to the Application Pool Name (i.e. “SharePoint - 25001 - MySite”).
-
In the Application Pool section, enter the My Site service account (domain\MossSspPoolMySite).
-
Change the Database Name to “WSS_Content_MySite”.
-
Review your entries and then click OK to create the web application.
-
Do NOT create the site collection.
-
This My Site web application will be used when creating Shared Service Provider (SSP).
-
Creating the SSP Admin web application:
-
In Application Management, click the “Create or extend Web application” link.
-
Click “Create new web application”.
-
Enter the port number for your SSP web application (i.e. 25002).
-
Optional: Append “SSP” to the description (i.e. “SharePoint - 25002 - SSPAdmin”).
-
Optional: Append “SSP” to the Application Pool Name (i.e. “SharePoint - 25002 - SSPAdmin”).
-
In the Application Pool section, enter the SSP service account (domain\MossSspPoolAdmin).
-
Change the Database Name to “WSS_Content_SSPAdmin”.
-
Review your entries and then click OK to create the web application.
-
Do NOT create the site collection.
-
This SSP web application will be used when creating Shared Service Provider (SSP).
-
Creating the Shared Service Provider (SSP):
-
Click on the “Shared Services Administration” link in the left side navigation to create a new Share Services Provider (SSP).
-
Click New SSP.
-
Select the SSP web application for the SSP Name section.
-
Select the MySite web application for My Site Location section.
-
Enter the SSP Service account (domain\MossSspService).
-
Optional: Adjust the databases using your naming convention.
-
Click OK to complete the Share Service Provider configuration.
Profile Import
-
Click on SharedServices1.
-
Click User Profiles and Properties.
-
Click Configure profile import.
-
Select the Specify Account in the Default Access Account section.
-
Enter the user profile import account name (domain\MossProfile).
-
Enter the account password, and click OK.
-
Click Start Full Import.
-
Click the Refresh link until the number of user profiles changes to something other than zero.
Optional Registry Updates
The following registry updates may be useful on your development machine.
Disable the Shutdown Event Tracker
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT\Reliability]
"ShutdownReasonOn"=dword:00000000
Disable Ctrl+Alt+Del
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System]
"DisableCAD"=dword:00000001
Performance for Programs
Windows Registry Editor Version 5.00
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\PriorityControl]
"Win32PrioritySeparation"=dword:00000026
Enable SuperFetch Service
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\PrefetchParameters]
"EnablePrefetcher"=dword:00000003
"EnableSuperfetch"=dword:00000003
Prevent Stuttering Sound
If SystemResponsiveness is set to 100 (default in Server 2008), it means that all processes are given a higher priority than multimedia. In Windows Vista the default value is 20. This is a addition to the article Enable Sound Acceleration.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Multimedia\SystemProfile]
"SystemResponsiveness"=dword:00000014
ALL Registry In One
Below are all the above registry entries combined for convenience.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows NT\Reliability]
"ShutdownReasonOn"=dword:00000000
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System]
"DisableCAD"=dword:00000001
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\PriorityControl]
"Win32PrioritySeparation"=dword:00000026
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management\PrefetchParameters]
"EnablePrefetcher"=dword:00000003
"EnableSuperfetch"=dword:00000003
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Multimedia\SystemProfile]
"SystemResponsiveness"=dword:00000014
Manual Web.Config Entries for Debugging
<configuration>
<SharePoint>
<SafeMode CallStack="true" />
</SharePoint>
<system.web>
<customErrors mode="Off" />
<compilation debug="true" />
</system.web>
</configuration>
Run Batch Command (Visual Studio)
In Visual Studio, create a new External Command by clicking Tools > External Tools.
-
Title: Run &Batch Command
-
Command: C:\Windows\System32\cmd.exe
-
Arguments: /C $(ItemFileName)
-
Initial Directory: $(ItemDir)
-
Check the "Use Output window"