Installing MOSS 2007 on Windows Server 2008 and SQL Server 2008

[patris1]

http://andreasglaser.net/post/2008/08/14/Installing-MOSS-2007-on-Windows-Server-2008-and-SQL-Server-2008-Part-1-Overview.aspx

Part 1: Overview


This week I had some time to play with the newly released SQL Server 2008 and a Microsoft Office SharePoint Server 2007 (MOSS) installation. The following articles describe how to set :

1. Part 1: Overview
2. Part 2: Installing Active Directory
3. Part 3: Domain Accounts
4. Part 4: Installing and configuring SQL Server 2008
5. Part 5: Installing IIS7
6. Part 6: Installing MOSS 2007
7. Part 7: Configuring MOSS 2007
8. Part 8: Pop3, SMTP, Outlook

Windows Server 2008 and SQL Server 2008 support (Update)

Microsoft Office SharePoint Server 2007 SP1 as well as Windows SharePoint Services 3.0 SP1 support Windows Server 2008 and SQL Server 2008 as it is written at the Microsoft SharePoint Team Blog.

• Windows SharePoint Service 3.0: Determine hardware and software requirements (Windows SharePoint Services)
• Office SharePoint Server 2007: Determine hardware and software requirements (Office SharePoint Server)

Server farm

I tried to create a server farm containing a SQL Server 2008 and a MOSS 2007. The SQL Server acts as a PDC and the MOSS 2007 server is used as a web server and an application server.

Installing Windows Server 2008 as a Hyper-V virtual image

For my testing environment I installed 2 Windows Server 2008 x64 Enterprise Edition virtual images using Hyper-V. After the installation process I had to install a newer version of the integration components.

After that I applied all new updates using Windows Update

[patris1]

http://andreasglaser.net/post/2008/08/14/Installing-MOSS-2007-on-Windows-Server-2008-and-SQL-Server-2008-Part-2-Installing-Active-Directory.aspx

Part 2: Installing Active Directory


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".

• Right now I'm working on the SQL Server 2008 image.
• Open the "Run" dialog box and type "dcpromo".

• Click next without checking "Use advanced mode installation".
• Click next and after that check "Create a new domain in a new forest".

• Type a new full qualified domain name like "aglaser.net".
• In my environment I set the forest functional level to "Windows Server 2008".

• Make sure "DNS server" is checked.
• After clicking next you may get a warning that one of your network adapters has a dynamically assigned IP address. Click "Yes" if you are sure you have one network adapter with a static IP address.

• Click "Yes" because you don't have to care about a DNS server in a parent zone since this is a testing environment.
• Click next again.

• Type in a "Directory Services Restore Mode Administrator Password".
• Click next to start the installation wizard.

• After installing the AD and the DNS server you have to restart your computer.
• If you take a look at the roles you will see that "Active Directory Domain Services" and "DNS Server" are checked.

[patris1]

http://andreasglaser.net/post/2008/08/14/Installing-MOSS-2007-on-Windows-Server-2008-and-SQL-Server-2008-Part-3-Domain-Accounts.aspx

Part 3: Domain Accounts


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.

[patris1]

http://andreasglaser.net/post/2008/08/14/Installing-MOSS-2007-on-Windows-Server-2008-and-SQL-Server-2008-Part-4-Installing-and-configuring-SQL-Server-2008.aspx

Part 4: Installing and configuring SQL Server 2008


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".
Installation

• Start the "setup.exe" of your SQL Server 2008 installation DVD.
• You are prompted to install the .NET Framework 3.5 SP1 (surprise since this was officially released later)
• After that you need to install a Windows Update.

• On the left side click "Installation" and on the right side click "New SQL Server stand-alone installation or add features to an existing installation".
• After that select your version of SQL Server 2008.

• After installing the setup support files you are prompted that there are some warnings. You can ignore that on a development environment.

• After that select the "Database Engine Services" feature and the "Management Tools" feature.
• Keep the default instance checked.

• After validating the hard disk requirements you have to select a services account. Please use the domain account from Part 3: Domain Accounts.

• You don't need to change the collation settings given by the installation wizard.
• Use "Windows Authentication" and add the current user as a SQL Server administrator.

• Click a few times next to start installation.

Configuration

• You have to enable "named pipes".
• "Remember to reboot for the named pipes to be available (needed for part 6)." (Updated 13. September 2009, provided by Audun)

"Remember to go back to the Domain setup page and set the required permissions for SQL server /setupAdmin account." - Installing MOSS 2007 on Windows Server 2008 and SQL Server 2008 - Part 3: Domain Accounts (Updated 13. September 2009, provided by Audun)
Please take a look at Part 5: Installing IIS7

[patris1]

http://andreasglaser.net/post/2008/08/14/Installing-MOSS-2007-on-Windows-Server-2008-and-SQL-Server-2008-Part-5-Installing-IIS7.aspx

Part 5: Installing IIS7


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".
Right now I'm working on the MOSS 2007 image.

• Add the "Application Server" role to your server and add the required features.
• You don't have to add the server role. You can also add the .NET Framework 3.0 Features. I have selected the server role for this demonstration.

• After that select the "Web Server (IIS)" server role.
• Skip the role services for the Application Server.

• Select the ASP.NET role service and add the required features.
• Your selected role services might look like that. Note that you might need more services for a production environment.

• Select "Basic Authentication" and "Windows Authentication".
• Click next until the wizard has finished the installation process.

[patris1]

http://andreasglaser.net/post/2008/08/14/Installing-MOSS-2007-on-Windows-Server-2008-and-SQL-Server-2008-Part-6-Installing-MOSS-2007.aspx

Part 6: Installing MOSS 2007


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".

• Select Advanced installation mode.
• Select "Complete - Install all components. Can add servers to form a SharePoint farm."

• Wait until the installation process finishes.
• Note that you can download a MOSS 2007 installation DVD including SP1 from Microsoft. You need an installation source including SP1 in order to install MOSS 2007 on a Windows Server 2008.

• Click Yes and proceed to the next screen.
• Select "No, I want to create a new server farm".

• Now you have to enter the name of your SQL Server (This is usually your system NAME or ip address or Default Database Server Name [thx to Veer]) and the MOSS farm account credentials (In my case aglaser\MOSSfarm).
• If you are getting the error
  
  "Failed to connect to the database server or the database name does not exist. Ensure the database server exists, is a Sql server, and that you have the appropriate permissions to access the database server. To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_8_13_2008_11_19_ 34_359_1143906485.log. Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access." or
  
  "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
  
  you have to make sure you
  
  -have deactivated your firewall or opened the ports needed and
  -that you have a working network connection to your Active Directory server. Try to ping your AD server.

• Specify the port number for Central Administration and the authentication provider.
• Wait until the configuration wizard has finished.

[patris1]

http://andreasglaser.net/post/2008/08/15/Installing-MOSS-2007-on-Windows-Server-2008-and-SQL-Server-2008-Part-7-Configuring-MOSS-2007.aspx

Part 7: Configuring MOSS 2007


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".
Services

At the beginning you have to start some services.

• Start the "Windows SharePoint Search Service" and enter the service account (aglaser\WSSsearchService) and the content access account (aglase\WSScontentAccess).

• After that start the "Office SharePoint Server Search" and enter the service account (aglaser\MOSSsearchService).
• Please select "Use this server for indexing content" and "Use this server for serving search queries". Otherwise the configuration is not complete.

• Now you can start the "Excel Calculation Services" (or not). You are finished with the services.

Shared Service Provider

• Go to Shared Services Administration and create a new Share Services Provider (SSP).
• Create two web applications for the SSP Administration site (aglaser\MOSSsspPool) and the MySite (aglaser\MOSSsspMySite) using the domain accounts specified earlier.

• After that provide the SSP service account (aglaser\MOSSsspService).
• After naming the databases using your naming convention you can finish the configuration by clicking OK.

• After that the configuration of the Shared Service Provider is finished.

Profile Import

• At the end of this process you should specify the profile import domain account (aglaser\MOSSprofile).

[patris1]

http://andreasglaser.net/post/2008/08/15/Installing-MOSS-2007-on-Windows-Server-2008-and-SQL-Server-2008-Part-8-Pop3-SMTP-Outlook.aspx

Part 8: Pop3, SMTP, Outlook


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".
Hmm, where was that POP3 server role? Or was it a feature? It doesn't exist any more... POP3 has been deprecated and is no longer part of Windows Server. You have to use an alternative like Microsoft Exchange Server 2007 or something from the cloud... (Did I say that loud?)