in

SharePoint Blogs

The Best Place for SharePoint-related Blogs

Bobby Habib SharePoint & MOSS Blogging Space

Bobby Habib - My findings on SharePoint / MOSS, Web Part Developments, etc. Information I think will help the SharePoint Community. All posts are provided "AS IS" with no warranties, and confers no rights. Whats the bloody Point!

September 2007 - Posts

  • List Types & List Internal ID available within MOSS 2007

    The following lists the default lists types and their internal sharepoint ID available in MOSS 2007. This references list can prove to be handy when creating your own Site Definitions, List Definitions and for Event Handlers:

    Value                               Description

    100                                  Generic List

    101                                  Document Library

    102                                  Survey

    103                                  Links List

    104                                  Announcement List

    105                                  ContactsList

    106                                  Events List

    107                                  Tasks List

    108                                  Discussion Board

    109                                  Picture Library

    110                                  Data Sources

    111                                  Site Template Gallery

    113                                  Web Part Gallery

    114                                  List Template Gallery

    115                                  XML Form Library

    120                                  Custom Grid for a List

    200                                  Meeting Series List

    201                                  Meeting Agenda List

    202                                  Meeting Attendees List

    204                                  Meeting Decisions List

    207                                  Meeting Objectives List

    210                                  Meeting Text Box

    211                                  Meeting things To Bring List

    212                                  Meeting Workspace Pages List

    300                                  Portal Sites List

    1100                                Issues Tracking

    2002                                Personal Document Library

    2003                                Private Document Library

    One of the interesting points in the above list is the lack of numbering. You may have noted that 112 is not in the above list for example. But if you go to any Site Setting page within a MOSS site and in the Site Actions option click People & Group which takes you to a page that displays users and groups. Right hand click this page and view HTML source on this page. Schroll down to the bottom of the page and what you will notice is a hidden object in the HTML referencing the ListTemplate ID that displays the value of 112. INTERESTING! Wink

  • New MOSS implementation gives ACCESS DENIED error when using AD Form Based Authentication

    After installing MOSS onto a Virtual Machine and trying to connect to the Portal not using the SharePoint service account initially you may find that you will recieve a "ACCESS DENIED" error. All of the users and permission that I have set up in Sharepoint are Windows-based Active Directory accounts.

    Form Based Authentication

    If your role provider is not configured correctly for Single Sign On or you are using form based authentication you can change the policy of your webapp to add a user accounts or AD group into the Web Application Policy providing the relevant security access required.

    Central Admin > Application Management > Application Security > Policy for Web Application

    Add Users > Select SharePoint & specific zone > Add User > Pick Full Control if required > Finish

     

  • MOSS Database Server Options

    Backend Servers / SQL Server


    Principally, MOSS and Windows SharePoint Services v3 use a SQL Server database to store all of its documents, web pages, and metadata. Another database is used to store the configuration detail of the portal. In fact, almost everything pertaining to SharePoint is stored in a SQL Server. This highlights the importance of the availability of the database and if this is not available your Portal is not available.
    A high availability solution masks the effects of a hardware or software failure and maintains the availability of applications so that the perceived downtime for users is minimized. If there is a need for uninterrupted operation of an organization's SharePoint databases, it is recommended that a understanding of the high availability alternatives offered in SQL Server. With regard to SharePoint, SQL Server 2005 offers three high availability alternatives: log shipping, failover clustering, and database mirroring. Peer-to-peer replication is another SQL high availability alternative; however, it is not applicable to SharePoint.

    Log Shipping

    Log shipping is a recommended solution for creating redundant copies of databases from a source SQL Server to another target SQL Server. The normal procedure of log shipping involves the transaction logs being backed up from a source server (primary server), copied across to another target server (secondary server), and finally restored. To provide high availability for SharePoint mission-critical databases, log shipping is adequate because first, it is inexpensive, and second, it is relatively easy to administer. This is the most cost-effective method available for creating redundant databases compared to significantly higher costs associated with a hardware cluster. Unlike database mirroring, which is limited to a single destination server, when using log shipping, it is possible to configure more than one secondary server for redundancy. On the other hand, log shipping offers a slower and manual failover process that is not seamless. Therefore, log shipping might not be the best solution for providing an organization with high availability when compared to the Windows clustering and database mirroring approaches. All SharePoint database connections will also have to be manually changed to reflect the name of the new target SQL Server.

    Windows 2003 and SQL Server 2005 Clustering

    Windows Server 2003 and SQL Server 2005 support the shared-nothing cluster model. In a shared-nothing cluster, each node of the cluster owns and manages its local resources and provides nonsharing data services. In case of a node failure, the disks and services running on the failed node will failover to a surviving node in the cluster. However, with high availability clustering, only one node is managing one particular set of disks and services at any given time.
    SQL 2005 on Windows 2003 Enterprise or Windows 2003 Datacenter can support up to eight nodes within a single cluster. Failover clustering of SQL Server 2005 can be configured in two ways: a single-instance failover (Active/Passive) configuration or a multiple-instance failover (Active/Active) configuration.
    Single-Instance Failover Configuration
    In a SQL Server single-instance failover configuration, the cluster runs a single instance of SQL Server on all nodes in the cluster. If the main SharePoint SQL Server instance fails on the primary node, the surviving node or nodes will run the same SQL Server instance. In this configuration, all the servers within a cluster share a master database along with a set of SharePoint databases, such as the configuration and content databases.
    In the multiple-instance failover configuration, each of the active nodes has its own instance of SQL Server. Each instance of SQL Server includes a separate installation of the full service and can be managed, upgraded, and stopped independently. To apply a multiple-instance failover configuration, at least two instances of SQL Server must be installed on the cluster and each instance should be configured to run on a certain node as its primary server.
     
    Database Mirroring

    Database mirroring is a new high availability alternative introduced in SQL Server 2005. This solution increases database availability by maintaining an up-to-date copy of the source database on a hot standby server in real-time.
    Database mirroring consists of two mandatory roles and a third optional role. The first mandatory role is the Principal Server, which contains the source database and is the source of all transactions. The secondary mandatory role is the Mirror Server, which is another server, one that focuses on receiving transactions from the principal server. The Witness Server is the third and optional role, which detects and enables automatic failover between the principal and mirror servers in the event of a failure.
    Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Database mirroring is supported in SQL Server 2005 Standard Edition and Enterprise Edition.
    Database mirroring offers a substantial improvement in availability over the previous high availability alternatives. Implementation is simplistic and it is straightforward to maintain. It is similar to log shipping; however, when a database mirroring session synchronizes, it provides a hot standby server that supports rapid failover with no loss of data from committed transactions. In addition, unlike log shipping, the failover is nearly seamless and client applications can recovery with minor interruption by reconnecting to the mirror server.

  • How to install SharePoint Server 2007 on a single machine

    How to install SharePoint Server 2007 on a single machine

    How to do a simple installation of SharePoint (with SQL 2005) on a single machine to be used for a stand-alone development, demonstration or simple 'play-pen' server (normally on a virtual machine).

    This guide will outline all of the main steps to setup such an environment.

    Please bear in mind that this is just an unofficial guide to getting SharePoint 2007 installed quickly and easily in a demo / test environment. This guide will not necessarily observe best practices with regard to security etc. For production setups, you should seek guidance from the official documentation which is available on TechNet (http://technet2.microsoft.com/Office/en-us/library/3e3b8737-c6a3-4e2c-a35f-f0095d952b781033.mspx?mfr=true).


    Pre-Install

    There are several things that you must do before you even insert the SharePoint 2007 CD they are:

    Install Windows 2003 R2 with the latest service pack (2 at time of writing) and all of the latest Windows Updates.
    NOTE: Please do not use NewSID to change the SID of the machine if you are using a copy of another VM, this breaks things in SharePoint. My advice is to build Windows from fresh or to use Sysprep if you are using a copy of a VM.

    Join your machine to a domain or create a domain by running DCPromo.exe from the Start > Run dialog.
    Install the .net frameworks v3.0 and v2.0 from Windows Update. You can also download the full redistributable packages if your server is not online.
    Install Windows 'Application Server' from Add/Remove Programs in Control Panel with default settings
    Prepare a service account in your active directory domain to use for all Sharepoint services.
    NOTE: Do not use the main domain\administrator account. This causes a problem if ever you wish to install Project Server 2007 on the same machine.

    Give your service account local administrator rights and logon as this account throughout the entire installation process.
    Install SQL 2005 (and latest service pack) with typical settings.
    Assign your service account to the 'Security Administrators' and 'Database Creators' server roles in SQL server (You will need to use SQL Server Management Studio).

     

    Base SharePoint Server Install

    You are now ready to install SharePoint 2007 itself, follow these steps:

    Login as your service account
    Insert your CD (or attach your ISO image) and run setup.exe if it does not autorun.
    NOTE: If you get an error about web service extensions here, ensure that 'ASP.net V2.0.50727' web service extension is allowed in IIS. If it is not in the list, perform a 'repair' on .net 3.0 framework using add/remove programs and then the web service extension will appear in the list. This is caused when IIS is installed after the .net framework

    Enter your CD key and accept the license agreement.
    Choose 'Advanced' on the installation type dialog.
    NOTE: The definition of 'Advanced' means that you are using full SQL server (which may or may not be on the same machine). If you had selected 'Basic' then it would have installed the cut down version of SQL (MSDE).

    Select 'Complete' on the Server Type screen and click 'Install Now'. The setup will now commence and you'll get a blue progress bar.
    Once installed you will get a screen with a check box that reads "Run the SharePoint products and Technologies Wizard now". Ensure this is ticked and click 'Close'.
    After a short pause, you'll get a 'Welcome' screen. Click 'Next'.
    You will get a warning that the wizard is about to reset several services, click 'Yes'.
    You'll be asked about the farm configuration, select to 'No, I want to create a new server farm'.
    Provide the database server (your server name) and your account details (account in the domain\user format). Leave the database name as the default. Click 'Next'.
    Leave the authentication mode as 'NTLM', set a specific port number is desired (not required) and click 'Next'.
    NOTE: In a production environment, you would most likely use Kerberos where possible (if your infrastructure supports it).

    You'll get a summary screen; click 'Next' to kick-off the process.
    NOTE: If it fails here, it is most likely that you do not SQL setup correctly. Ensure your service account is in the right groups. Please also note that this section can take a very long time, especially step 2 (up to 45 minutes).

    You'll get a success screen at the end, click 'Finish'.
    The wizard will attempt to load the central administration window. You may need to login here, use your service account. You may also get prompted to add the site to your trusted sites; go ahead and do that.
    NOTE: This authentication prompt is caused by the secure version of IE on Windows 2003 Server. You can turn if off by modifying the security settings in IE.

     

    Services on Server Configuration

    The first bit of configuration to do is set your server to host all services. You do not strictly have to enable all of these services, but I find it helps if you are using the machine to test / investigate functionality.

    When the Central Administration screen appears, go to 'Operations' tab, then 'Services on Server'.
    Start the 'Document Conversions Load Balancer Service'.
    Start the 'Document Conversions Launcher Service', you'll have to choose the 'Load Balancer Server'; there should only be one option. If there are no options, ensure that the 'Document Conversions Load Balancer Service' has been started.
    Start the 'Excel Calculation Services'.
    Start the 'Office SharePoint Servers Search' service, observing the following guidelines:
    Tick both Query and Indexing check boxes
    Specify a contact email address (this can be any address)
    Enter your service account in the 'Farm Search Service Account' section
    Accept all other defaults and click 'Start'
    Leave all remaining services in their default configuration

     

    Web Application Setup

    The next stage is to create the 3 web applications that will be required to host the basic set of sites for a typical deployment, these are:

    Shared Service Provider Administration Site (Recommended to be called 'SSPAdmin')
    My Site Host (Recommended to be called 'MySite')
    The Main Intranet (or 'Portal') Site (Recommended to be called 'Intranet')
    It is much simpler if all of these sites are on port 80 in IIS; this means that you do not have to remember to enter the ports all of the time. However having all three sites on port 80 means that each needs their own Host Header (required by IIS to differentiate between sites on the same port). The simplest way to do this is to create new 'Host (A)' records in DNS for each of your three sites. These should point to the IP address of your server; to do this follows these steps:

    Open the DNS Management tool from Administration Tools on your domain controller
    Navigate to your DNS zone
    Create new 'Host (A)' record
    Enter the Host header (i.e. 'SSPAdmin', 'MySite' or 'Intranet') for the site and the IP address of your server
    Click 'Add Host' and repeat for each of the three sites
    Now the DNS entries are configured, we can create the three web applications in SharePoint; follow these steps for all three of your web applications (i.e. 'SSPAdmin', 'MySite' or 'Intranet'):

    In Central Administration, go to the 'Application Management' tab
    Click 'Create or Extend Web Application' and then click 'Create a new Web Application'
    Fill out the new web application screen observing the following points:
    Change the New IIS Site description to read something like 'SharePoint – 80 - <Host header name>' where <Host header name> is the name of the web application your are creating (i.e. 'SSPAdmin', 'MySite' or 'Intranet')
    Ensure the 'Port' is set to 80
    Set the 'Host Header' to match the DNS record you created (i.e. 'SSPAdmin', 'MySite' or 'Intranet')
    Change the 'Application Pool Name' to match the 'New IIS Site Description'
    Enter your service account for the Application Pool account settings
    Change the 'Database Name' to read something like 'WSS_Content_<Host header name>' where <Host header name> is the name of the web application your are creating (i.e. 'SSPAdmin', 'MySite' or 'Intranet')
    Leave all other settings on default and click 'OK'
    Repeat for all three web applications (i.e. 'SSPAdmin', 'MySite' or 'Intranet')


    Shared Service Provider Setup

    The next stage is to create the Shared Service Provider (SSP). The SSP is required in order to provide several key services such as Search or My Site. To configure the SSP, follow these steps:

    In Central Administration, go to the 'Application Management' tab
    In the 'Office SharePoint Server Shared Services' section, click 'Create or Configure This Farms' Shared Services'
    Click 'New SSP'
    Fill out the 'New Shared Services Provider' screen observing the following guidelines:
    For the 'SSP Administration Site' web application (the first one you get asked for), choose the web application that you created earlier (suggested name was 'SharePoint – 80 - SSPAdmin')
    For the 'My Site Location' web application (the second one you get asked for), choose the web application you created earlier (suggested name was 'SharePoint – 80 - MySite')
    Enter your service account for the 'SSP Service Credentials'
    Leave all other settings on default and click 'OK'
    The creation of an SSP can take some time (up to 1 hour on a virtual machine). When it is finished you will see a 'Success!' screen, Click OK.
    Collaboration Portal Site Collection Setup

    The next stage is to create a collaboration portal which is one of the more feature-filled site types and represents a typical intranet environment. To do this, follow these steps:

    In Central Administration, go to the 'Application Management' tab
    In the 'SharePoint Site Management' section, choose 'Create Site Collection'
    Fill out the 'Create Site Collection' observing the following guidelines:
    Ensure you have selected the 'Intranet' web application you created earlier (suggested name was 'Intranet')
    Give your site a title ('Intranet' is suggested)
    In the 'Template Selection' section, choose 'Collaboration Portal' from 'Publishing' tab
    Enter you service account for the 'Primary Site Collection Administrator'
    Leave all other settings on default and click 'OK'
    When the 'Top-Level Site Successfully Created' message appears you have created the site, simply click the link that is provided (something like http://intranet)

     

    Configure Indexing

    The final step of the process is to configure indexing so that you have some search results. Though this step is optional, it is recommended as it will enable you to use the powerful search capabilities of SharePoint. To configure the index, follow these steps:

    In Central Administration, click the 'SharedServices1' link on the left-side navigation (or whatever you name your SSP)
    When the SSP Administration site appears, click on 'Search Settings' in the 'Search' section
    On the 'Configure Search Settings' page, click 'Content Sources and Crawl Schedules'
    Edit the 'Local office SharePoint Server Sites' content source by hovering your mouse over it and choosing 'Edit'
    Fill out the 'Edit Content Source' observing the following guidelines:
    Set a full crawl schedule to be at least once a day
    Set a incremental crawl schedule for every 10 minutes
    Tick the 'Start Full Crawl of this Content Source' tick-box
    Click 'OK'
    A crawl will now start. Initial crawls normally take up to 10 minutes.
    The process is now complete. User should be able to access the main collaboration portal from http://intranet (or whatever you called the DNS record).

    I hope this was useful, because it was for me. Stick out tongue

  • Performance Guidelines for MOSS

    Good Performance Guidelines for MOSS;

    They are guidelines for designing a server that has good overall performance.

    Site collections (Database scope) 50,000 ... Total throughput degrades as the number of site collections increases.
    Web sites (Web site scope) 2,000 ... The interface for enumerating subsites of a given Web site does not perform well much
    beyond 2,000 subsites.
    Web sites (Site collection) 250,000 - You can create a very large total number of Web sites by nesting the subsites. For example, 100
    sites each with 1000 subsites is 100,100 Web sites.
    Documents (Folder scope) 2,000 ... The interfaces for enumerating documents in a folder do not perform well beyond a thousand entries.
    Documents (Library scope) 2 million ... You can create very large document libraries by nesting folders.
    Security principals (Web site scope) 2,000 ... The size of the access control list is limited to a few thousand security principals, in other words users and groups in the Web site.
    Users ( Web site scope) 2 million ... You can add millions of people to your Web site by using Microsoft Windows security groups to manage security instead of using individual users.
    Items (List scope) 2,000 ... The interface for enumerating list items does not perform well beyond a few thousand items.
    Web Parts (Page scope) 100 ... Pages with more than 100 Web Parts are slow to render.
    Web Part personalization (Page scope) 10,000 ... Pages with more than a few thousand user personalizations are slow to render.
    Lists (Web site scope) 2,000 ... The interface for enumerating lists and libraries in a Web site does not perform well beyond a few thousand entries.
    Document size (File scope) 50 MB ... The file save performance degrades as the file size grows. The default maximum is 50 MB. This maximum is enforced by the system, but you can change it to any value up to 2 GB (2047 MB) if you have applied Windows SharePoint Services Service Pack 1.

    The following table lists some of the SharePoint Portal Server objects and describes their recommended use. "Typical" indicates comfortable and well tested; "maximum" indicates that the system can support that number, but not without some performance ramifications or
    special configurations.

    An asterisk (*) indicates a hard limit; no asterisk indicates a tested or supported limit.

    Portal sites (full) - typically 2 ... maximum 15 *
    Portal sites (child) - typically 10 ... maximum 100 *
    Areas - typically 1,000 ... maximum 10,000
    Best Bets - typically 1,000 ... maximum 25,000
    Area depth - typically 5 ... maximum 20 *
    User profiles - typically 50,000 ... maximum 1,000,000
    Audiences - typically 500 ... maximum 10,000
    Audience memberships - typically 500,000 ... maximum 5,000,000
    SSO credentials - typically 100,00 ... maximum 100,000
    Search indexes - typically 3 ... maximum 32
    Content sources -typically 25 ... maximum 250
    Search scopes - typically 25 ... maximum 250 *
    Indexed documents per content index - typically 100,000 ... maximum 5,000,000
    Indexed documents - typically 2,500,000 ... maximum 20,000,000
    Thesaurus entries - typically 1,000 ... maximum 10,000
    Alerts - typically 50,000 ... maximum 1,000,000
    Team sites - typically 10,000 ... maximum 250,000
    Personal sites - typically 10,000 ... maximum 250,000

     

  • SharePoint 2007 Entity Hard / Maximum Limitations

    SharePoint 2007 Maximum Limitation


    Following is a list of names and other parameters with the maximum allowable size on each.

    Entity                              Max Permissible Size


    Site Name                          128 characters
    Site URL                             255 characters
    Display name                      128 characters
    Connection string                 384 characters
    Email address                     128 characters
    Version numbers                  064 characters
    Virtual Server Friendly Name 064 characters
    SQL Database Name           123 characters
    SQL Database Column         128 characters
    SQL Database Table Name   128 characters
    SQL Role Name                   128 characters
    Server Name                        128 characters
    Windows User Name            300 characters
    Windows Password              300 characters
    Dependencies per object       032 objects
    Zone enumeration value         004 zones
    Default SQL command timeout 300 seconds
    Number of simultaneous
    workflows that can be run*     015

    If during your course of using the product, you inadvertently cross these limits, then you would end up with errors. These are hard limits.

  • MOSS Out of the Box Web Parts

    Web Parts 

    Form Web Part Use to connect simple form controls to other Web Parts.
    Image Web Part Use to display pictures and photos.
    Members Use the Members Web Part to see a list of the site members and their online status.
    Page Viewer Web Part Use to display linked content, such as files, folders, or Web pages. The linked content is isolated from other content on the Web Part Page. Relevant Documents Use this webpart to display documents that are relevant to the current user.
    User Tasks Use this webpart to display tasks that are assigned to the current user.
    XML Web Part Use for XML, and XSL Transformation of the XML.
    List View Web Part 
    Data View Web Part 
     
    Web Parts specific to MOSS 2007 

    Business Data 
    Business Data Actions Display a list of actions from the Business Data Catalog.
    Business Data Item Display one item from a data source in the Business Data Catalog.
    Business Data Item Builder Creates a Business Data item from parameters in the query string and provides it to other web parts. This web part is only used on Business Data profile pages.
    Business Data List Display a list of items from a data source in the Business Data Catalog.
    Business Data Related List Display a list of items related to one or more parent items from a data source in the Business Data Catalog.
     
    Content Rollup 

    Colleague Tracker Displays your list of colleagues and any recent changes they made have had.
    Memberships Displays your site and distribution list memberships.
    My Links Use to display your links
    My SharePoint Sites Use to display documents authored by you on sites where you are a member and sites of your choice.
    My Workspaces Displays sites created under your My Site.
    Site Aggregator Use to display sites of your choice.
     
    Dashboard 

    Key Performance Indicators Shows a list of status indicators. Status indicators display important measures for your organization, and show how your organization is performing with respect to your goals.
    KPI Details Displays the details of a single status indicator. Status indicators display an important measure for an organization and may be obtained from other data sources including SharePoint lists, Excel workbooks, and SQL Server 2005 Analysis Services KPIs.
     
    Other 

    Excel Web Access Use the Excel Web Access to interact with an Excel 2007 workbook as a Web page.
    I need to… Displays tasks and tools from a list
    IView Web Part Displays iViews from SAP portal servers.
    RSS Viewer Renders RSS Feed
    This Week in Pictures Use to display the images library in the News web
    WSRP Consumer Web Part Displays portlets from web sites using WSRP 1.1.
     
    Filters 

    Authored List Filter Filter the contents of web parts using a list of values entered by the page author.
    Business Data Catalog Filter Filter the contents of web parts using a list of values from the Business Data Catalog.
    Current User Filter Filter the contents of web parts by using properties of the current page.
    Date Filter Filter the contents of web parts by allowing users to enter or pick a date.
    Filter Actions Filter Actions
    Page Field Filter Filter the contents of web parts using information about the current page.
    Query String (URL) Filter Filter the contents of web parts using values passed via the query string.
    SharePoint List Filter Filter the contents of web parts by using a list of values from a Office SharePoint Server list.
    SQL Server 2005 Analysis Services Filter Filter the contents of web parts using a list of values from SQL Server 2005 Analysis Services cubes.
    Text Filter Filter the contents of web parts by allowing users to enter a text value.
     
    Misc 

    Contact Details Use to display details about a contact for this page or site
     
    Outlook Web Access 

    My Calendar Use to display your calendar. This part works with Microsoft Exchange Server 2003 and above.
    My Contacts Displays your contacts using Outlook Web Access for Microsoft Exchange Server 2007.
    My Inbox Displays your inbox using Outlook Web Access for Microsoft Exchange Server 2003 or later.
    My Mail Folder Displays your calendar using Outlook Web Access for Microsoft Exchange Server 2000 or later.
    My Tasks Displays your tasks using Outlook Web Access  for Microsoft Exchange Server 2003 or later.
     
    Search 

    Advanced Search Box Entry point for advanced search
    People Search Box Entry point for people search
    People Search Core Results Web part to display the people search results.
    Search Box Entry point for search.
    Search Core Results Web part to display the search results.
    Search High Confidence Results Web part to display the special term and high confidence results.
    Search Paging Displays search paging.
    Search Statistics Displays search statistics.
    Search Summary Displays search summary.
     
    Site Directory 

    Categories Displays categories from the Site Directory
    Sites in Category Displays sites in the Site Directory
    Top Sites Display the top sites from Site Directory

  • Types of MOSS Server Farms

    Server farm environments can encompass a wide range of topologies, and can include many servers or as few as two servers commercially. To deploy a high-availability solution, you must deploy a server farm. By using a server farm, you mitigate against the effects of unexpected downtime as well as downtime that is related to ongoing maintenance, such as operating system updates.

    There are several different server topologies that can be used as a baseline. Each of these topologies builds in a level of server redundancy.

    This following provides an overview of these server farms.

    Small Server Farm

    A small server farm typically consists of a database server running either Microsoft SQL Server 2005 or Microsoft SQL Server 2000 with the most recent service pack, and one or more servers running Internet Information Services (IIS) and Office SharePoint Server 2007. In this configuration, the front-end servers are configured as Web servers and application servers. The Web server role provides Web content to clients. The application server role provides Office SharePoint Server 2007 services such as servicing search queries, and crawling and indexing content.

    Medium Server Farm

    A medium server farm typically consists of a database server, an application server running Office SharePoint Server 2007, and one or two front-end Web servers running Office SharePoint Server 2007 and IIS. In this configuration, the application server provides indexing services and Excel Calculation Services, and the front-end Web servers service search queries and provide Web content.

    Large Server Farm

    A large server farm typically consists of two or more clustered database servers, several load-balanced front-end Web servers running Office SharePoint Server 2007, and two or more application servers running Office SharePoint Server 2007. In this configuration, each of the application servers provides specific Office SharePoint Server 2007 services such as indexing or Excel Calculation Services, and the front-end servers provide Web content.

    Development Environments 

    For Development purposes you could install MOSS on a single server with all 3 tiers (Front End, Application Services, Database) shared on this server, to allow developers to develop custom soultions.


Need SharePoint Training? Attend a SharePoint Bootcamp!

Posts (c) their respective authors. Everything else (c) 2007 SharePoint Experts