4.7. Summary

In this chapter, you learned that:

• MOSS is more advanced (and, therefore, more complicated to install) than WSS.

• MOSS has a different type of SQL Express database compared to WSS, which is limited to 4 GB.

• MOSS features:

  • Targeting of information on the portal site.

  • Global searching, both inside SharePoint and outside.

  • My Site is used both as a personal web site for the user and to describe the user's properties, such as the e-mail address, phone numbers, department, picture, and much more.

• The license model for MOSS is based on the edition selected, Standard or Enterprise; the number of MOSS servers; and number of client access licenses (CAL) that can access MOSS.

• Even if you only read information in the portal site, you will need a separate CAL.

• MOSS can use MS SQL Server 2005 or 2000.

• MOSS can use a local or remote database. A local database can be either SQL Express or MS SQL Server 2000/2005.

• You learned the following definitions:

  • Stand-alone: MOSS with a local SQL Express.

  • Single-Server: MOSS with a local MS SQL Server 2000/2005.

  • Front-End Server: A server that has MOSS binaries installed and running one or more of the MOSS roles.

  • Back-End Server: A server running MS SQL, used by MOSS for storing data.

  • Small farm: MOSS with a remote server running MS SQL Server 2000/2005.

  • Large and medium farm: A MOSS configuration with two or more MOSS servers running one or more roles, such as the Web, Index and Search roles.

  • The Web service: The service responsible for contact with the user client.

  • The Search service: The service responsible for answering any search queries from the client.

  • The Index service: The service responsible for crawling through and indexing information.

• There are seven different databases in MOSS, used either for administrative purposes or for storing content in user web sites.

  • If you implement the Single Sign-On feature of MOSS, it creates one more database type.

  • There may be any number of content databases, but only one each of the other types.

• Hardware requirements for MOSS are higher than for WSS.

• You can use the formula for calculating the normalized operations per second (NOPS) to find out the load for a given user population was covered.

• Even a small farm may support up to 10,000 users in a typical organization, as long as the hardware is properly configured.

• You should make sure that the SQL Server always has at least 50 percent free disk space for its maintenance utilities.

• MOSS requires ASP.NET 2.0 and Windows Workflow Foundation with the .NET 3.0 Framework.

• MOSS uses several more web applications, virtual IIS web sites, than WSS.

• The security account for the application pool is used when communicating with the database.

• There are a number of service accounts that you can define during the installation of MOSS, such as:

  • The application pool security account.

  • The default content access account.

  • The configuration database user account.

• A Basic installation of MOSS is very easy and fast to perform; it does not ask about the application pool security account or the configuration database user account.

• The installation of MOSS must be followed by an installation of the latest service pack.

• Some of the new file directories created during the MOSS installation are:

  • C:Program FilesCommon FilesMicrosoft Sharedweb server extensions12: This is the general file structure for all site definitions and features of MOSS and/or WSS.

  • C:Program FilesMicrosoft Office Servers12.0: This location has several folders and files specific to SharePoint 2007, including the search index.

  • C:Program FilesMicrosoft Microsoft Office Servers12.0DataMSSQL: This folder structure stores the SQL Express content.

• You can use the SharePoint Central Administration tool for complete backups of all data including all portal sites, all team sites, and index files.

• You can upgrade a local SQL Express database to MS SQL Server 2005. This is a straightforward process.

• It is possible to migrate from a local SQL Express database to a remote version of MS SQL Server, but it is a complicated process. Check Microsoft's Knowledge Base for more details on this procedure.

• You can uninstall MOSS in several ways:

  • Remove the portal site but not the binaries.

  • Remove the binaries but not the databases (must be an Advanced installation of MOSS).

  • Remove everything.

• When removing SharePoint completely, you must start by removing MOSS, which also removes WSS, and then the database, if you used a local database.

In the next chapter, you will learn more about managing and configuring this new MOSS environment.