This article is a part of a series describing the installation of Microsoft Office SharePoint Server 2007 (MOSS) on a Windows Server 2008 with the newly released SQL Server 2008. Please have a look at "Installing MOSS 2007 on Windows Server 2008 and SQL Server 2008 - Part 1: Overview".
Account overview
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 type | Account name |
| SQL Service | SQLservice |
| Setup Admin | setupAdmin |
| Farm Account | MOSSfarm |
| SSP Admin Application Pool | MOSSsspPool |
| SSP MySite Application Pool | MOSSsspMySite |
| SSP Service | MOSSsspService |
| WSS Search Service | WSSsearchService |
| WSS Search Content Access | WSScontentAccess |
| MOSS Search Service | MOSSsearchService |
| MOSS Profile Import | MOSSprofile |
| MOSS Excel Services | MOSSexcel |
Add the user to your Active Directory. Make sure you have
- "User cannot change password" and
- "Password never expires" checked.
At the end you have the following accounts in your Active Directory:
Assign permission
After creating the specified domain accounts you need to assign permission for the setupAdmin account. After installing the SQL Server (Part 4: Installing and configuring SQL Server 2008) you should continue with the following steps.
First of all 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.
Please take a look at Part 4: Installing and configuring SQL Server 2008.