SharePoint Server makes collaboration easier

With the release of Office SharePoint Server 2007, Microsoft has made some dramatic changes to its popular collaboration software. Our Clear Choice Test of the SharePoint collaboration and content-management server found the new version easier than its predecessor to install and use.

How we tested SharePoint Server

Archive of Network World tests

Subscribe to the Network Product Test Results newsletter

For large SharePoint deployments, a customized installation might be preferable, so that portions of the software can be installed on different servers. The SharePoint installation program automatically installs and configures a version of Microsoft's SQL Server 2005 and then configures IIS for use with SharePoint Server 2007. Once that's done, you're ready to go, as long as your IIS Web server can be seen on the network.



Price:Server licenses start at $4,300. Standard Edition client access licenses start at $93 and Enterprise Edition client access licenses start at $76 (both are required for the full array of business-intelligence functions.)
Pros:Easy to install and use; compatible with many Web browsers; now is template-driven.
Cons:Server runs only on Microsoft Windows; works better with Internet Explorer than with other browsers; many features rely on Microsoft Office 2007 file formats.
The breakdown
Installation 20%4.5Scoring Key: 5: Exceptional4: Very good3: Average2: Below average1: Subpar or not available
Compatibility 20%4

Management 30%

Ease of use 30%4.5

SharePoint is managed through a Web browser. For the majority of our administrative work (see How we did it), we used versions 2.0 and 1.5 of Mozilla's Firefox. Internet Explorer's new Version 7.0, as well as its previous versions, is a little better at performing some of the drag-and-drop functions and selection boxes. However, all of SharePoint Server's features are available using a variety of browsers. You just have to work a little harder when using something other than Internet Explorer.

A sprinkling of data

Once installation is complete, the next task is to create the first SharePoint "site." SharePoint now is driven by templates, which lets site owners choose from a variety of predefined page layouts. There are four basic template categories: collaboration, meetings, enterprise and publishing.

Collaboration templates facilitate sharing of files and ideas, including new wiki and blog functions -- Microsoft calls functions "Web parts." The meetings templates include calendaring functions, as well as places to record events, decisions, agendas and tasks. The more business-oriented enterprise templates include functions for storing and searching for documents, tracking project status and showing key performance indicators (KPI), which provide a visual status of conditions being monitored. Finally, the publishing templates are for managing Web pages, and include functions for document management, approval workflow, version control and history.

In our test, we created a collaboration site and used the team site template. We added a calendar function to display upcoming appointments but removed the links function because we didn't need to share any site addresses. Finally, we put a link to the document library on the top page and added a dashboard status indicator. This took a little time to set up but provided a customized space where documents could be stored, shared and tracked; deadlines listed; and the overall project status displayed.

SharePoint users also can create individual profiles, which are their personal SharePoint Web space. These pages have various permissions set to display different information to different people. For example, perhaps you want your office phone number displayed only to those you define as colleagues. Or maybe you want to track when certain people make new blog posts, but you don't want others to see whose posts you are interested in seeing.

Each site is customizable, letting users build a site that will help them track their own work and information. It also is possible to create tools that only the individual uses, such as a private document store. The administrator can limit the size of these profiles and decide who has permission to create them, but the users ultimately control what these pages contain and their layout.

Microsoft also has added some navigational aids to the SharePoint screens. Along the top, the sites most recently visited are represented with clickable tabs. This makes it easy for users to return quickly to the sites they use the most. Along the left side is the Quick Launch bar. This lists all the content on the site, even content on different pages, and categorizes it by type. Among the items listed are calendars, task lists and document stores.

On larger sites, these aids make finding a particular object easier. For example, users looking for a project calendar buried deep within a site can navigate to that page with a click. Near the top, a navigation feature helps users visualize where they are in a site's hierarchy. It starts at the top level and displays the title of each subpage the user traversed to get to a particular function. This allows quick navigation to a site's higher levels or even an escape back to the top.

Serving up the info

Excel Services let all or part of an Excel spreadsheet be displayed as part of a Web page. Using Excel Services eliminates having to install Excel locally on a user's machine. More important, it lets site owners display information without revealing the details and formulas behind the cells. For example, a sales-forecast model can be set up within a workbook. With Excel Services, the results can be displayed without people seeing the formulas responsible for creating those values.

Another useful function is the KPI. A simple dashboard status symbol quickly summarizes an Excel worksheet, entries in a database or other information. For our test site, we created two KPIs. We had created a spreadsheet to track our project expenses. The first KPI turned from green to red if we bought too many doughnuts. With the second KPI, we tracked task due dates. Normally green, it turned red if a task needed immediate attention.

Although SharePoint can be accessed via a browser, there is some real power to be gained by using Office 2007. Calendars can be created within a site and accessed directly from Outlook. Tasks also can be tracked directly from Outlook, as well as document stores. Information is kept in sync automatically as files are checked out and updated.

These synchronization features don't have to be specific to Microsoft products. Each uses standard Simple Object Access Protocol () calls to authenticate, retrieve and synchronize the files. We did not test this feature, but any application that uses SOAP should be able to access the stores within SharePoint. That said, many of SharePoint's features rely on file formats specific to Microsoft Office 2007. For example, Excel Services work only with Excel 2007formatted worksheets. Even Excel 2003 will not work.

Overall, SharePoint Server 2007 is simple to set up and has the tools that let users become proficient with it in a short time. It is also flexible enough to configure and modify virtually any way users see fit. SharePoint can be accessed by a wide variety of browsers and platforms, making it an easy fit into any enterprise. It provides a convenient place to store, organize and find business data, and should go a long way to making organizations more efficient. All in all, this product is definitely worth a look.

Berkley is the associate director of Networking and Telecommunications Services at the University of Kansas. He can be reached at

Berkley is also a member of the Network World Lab Alliance, a cooperative of the premier reviewers in the network industry, each bringing to bear years of practical experience on every review. For more Lab Alliance information, including what it takes to become a member, go to

Copyright © 2007 IDG Communications, Inc.

The 10 most powerful companies in enterprise networking 2022