Functional comparison between Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007

Functional comparison between
Windows SharePoint Services 3.0
and
Microsoft Office SharePoint Server 2007
By Andre Galitsky
October 14th, 2009, Lexington Microsoft Users Group
About Me
 10 years in IT, 4 years with SharePoint
 Currently working at L-3 Communications in BGS
 B.S. in IT from Univ. of Phoenix (2005)
 MBA from Univ. of Minnesota (2009)
 MCTS in Configuring & administering MOSS 2007
 Enjoy running, travelling, blogging, and gardening
 Married with 5 kids (soon to be 6)
 Blog: http://www.sharepointnomad.com
 Email: [email protected]
The SharePoint Wheel
SharePoint
system
architecture
diagram
MS Office
Online
comparison
tool
http://office.microsoft.com/en-us/sharepointtechnology/fx101758691033.aspx
The feature
comparison
workbook
http://office.microsoft.com/en-us/sharepointserver/HA101978031033.aspx
Windows SharePoint Services (WSS 3.0)
Main Features
What do you get out of the box (OOB)?
• Rapid provisioning of team web sites
• Active Directory integration for authentication and security
• Functionality to create document libraries, task lists, team calendars,
custom lists, contact lists, and surveys
• Tight integration with MS Office, including Excel, Outlook, and InfoPath
• Support for wikis and blogs
• Document check-in/check-out and versioning
• Information recovery (two-level recycle bin)
• 1 workflow (three-state)
• Search capability (see next slide)
Source: WSS 3.0 Features guide
http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb400753.aspx
WSS 3.0 Search capability
 Finds information of any type, stored in the current
site, or a subsite.
 Provides free-text searching in documents, files, and
all list content.
Search Server 2008 Express
http://www.microsoft.com/enterprisesearch/en/us/default.aspx
Installing WSS 3.0
 Install WSS 3.0 binaries
 Run Configuration wizard
 The wizard will provision the Central Administration
site and create configuration database
 When finished, configure your SP environment using
Central Administration site
Basic Install screen
Don’t do Basic install
http://www.sharepointjoel.com/Lists/Posts/Post.aspx?ID=260
Basic Install Issues
1. Lack of manageability
2. Authentication issues (half-baked Kerberos)
3. Service accounts – there are none
4. Moving from a single server to a farm is a
nightmare
5. SQL Express limitations: 1 CPU, 1 GB of RAM
max, 4GB storage limit
Document Library
Task list
Calendar
Other Lists
 Announcements
 Surveys
 Link lists
 Contacts
 Custom list –
create your own fields!
Datasheet View – it’s just like Excel!
WSS 3.0 Technical Specs
 Supports stand-alone or farm installation
 Requires Windows Server 2003 or 2008
 2.5 GHz CPU (3 GHZ recommended)
 1 GB of RAM (2 GB recommended)
 Requires IIS 6.0 (with SMTP for email functionality)
 .NET Framework 3.0
 ASP.NET 2.0 enabled
 SQL Server 2000 SP4 (SQL 2005 SP2 recommended)
WSS 3.0 Hardware requirements
Source: http://technet.microsoft.com/en-us/library/cc288751.aspx
Microsoft Office SharePoint Server
(MOSS 2007) Main Features
 All WSS 3.0 features
 Similar basic hardware and software requirements
 Business data catalog (BDC)
 User Profiles (Personalization services)
 My Sites
 Templates
 7 workflows (Approval, Signature, Collect Feedback, etc.)
 InfoPath services (web-based Infopath forms)
 RSS feeds, enterprise search
MOSS 2007 Search portal
MOSS 2007 vs. WSS 3.0
http://www.milesconsultingcorp.com/SharePoint-Portal-2007-Version-Comparison-between-MOSS2007-and-WSS3.aspx
Takeaways
 The “Free SharePoint” version (WSS 3.0) offers a lot of
OOB functionality: rapid site provisioning, AD integration,
MS Office integration, versioning support
 MOSS 2007 offers all of WSS functionality plus additional
templates, user profiles (My Sites), Business Data
Catalog (BDC), robust enterprise search, BI, RSS feeds
 Both products can be customized and extended using
SharePoint Designer (free program), PowerShell, or
Visual Studio (.NET dev)
Next steps
 Study MS resources:
 For end users- MS Office Online SharePoint site:
http://office.microsoft.com/en-us/sharepointserver/default.aspx
 For IT Pros- SharePoint Server on TechNet:
http://technet.microsoft.com/en-us/office/sharepointserver/default.aspx
 SharePoint Community Portal:
http://sharepoint.microsoft.com/sharepoint/default.aspx
 Set-up test VMs using both WSS 3.0 and MOSS 2007
 Avoid “shiny object syndrome”
 Avoid “Basic Install”
Questions?