Software Testing Fundamentals: Methods and Metrics

In this chapter, you learned that:

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

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

• q MOSS features:

  • q Targeting of information on the portal site.

  • q Global searching, both inside SharePoint and outside.

  • q 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.

• q 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.

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

• q MOSS can use MS SQL Server 2005 or 2000.

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

• q You learned the following definitions:

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

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

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

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

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

  • q 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.

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

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

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

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

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

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

• q Hardware requirements for MOSS are higher than for WSS.

• q 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.

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

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

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

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

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

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

  • q The application pool security account.

  • q The default content access account.

  • q The configuration database user account.

• q 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.

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

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

  • q C:\Program Files\Common Files\Microsoft Shared\web server exten-sions\12: This is the general file structure for all site definitions and features of MOSS and/or WSS.

  • q C:\Program Files\Microsoft Office Servers\12.0: This location has several folders and files specific to SharePoint 2007, including the search index.

  • q C:\Program Files\Microsoft Microsoft Office Servers\12.0\Data\MSSQL: This folder structure stores the SQL Express content.

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

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

• q 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.

• q You can uninstall MOSS in several ways:

  • q Remove the portal site but not the binaries.

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

  • q Remove everything.

• q 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.