SharePoint 2007 The Definitive Guide James Pyles, Christopher M. Buechler, Bob Fox, Murray Gordon, Michael Lotter, Jason Medero, Nilesh Mehta, Joris Poelmans, Christopher Pragash, Piotr Prussak, and Christopher J. Regan Beijing • Cambridge • Farnham • Köln • Paris • Sebastopol • Taipei • Tokyo SharePoint 2007: The Definitive Guide byJamesPyles,ChristopherM.Buechler,BobFox,MurrayGordon,MichaelLotter, JasonMedero, Nilesh Mehta, Joris Poelmans, Christopher Pragash, Piotr Prussak, and Christopher J. Regan Copyright © 2007 O’Reilly Media, Inc. All rights reserved. Printed in the United States of America. Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472. O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions are also available for most titles (safari.oreilly.com). For more information, contact our corporate/institutional sales department: (800) 998-9938 [email protected]. Editors: John Osborn and Laurel R.T. Ruma Indexer: Ellen Troutman Zaig Production Editor: Rachel Monaghan Cover Designer: Karen Montgomery Copyeditor: Genevieve d’Entremont Interior Designer: David Futato Proofreader: Reba Libby Illustrators: RobertRomanoandJessamynRead Printing History: September 2007: First Edition. Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are registered trademarks of O’Reilly Media, Inc.SharePoint 2007: The Definitive Guide, the image of buntings, and related trade dress are trademarks of O’Reilly Media, Inc. Manyofthedesignationsusedbymanufacturersandsellerstodistinguishtheirproductsareclaimedas trademarks. Where those designations appear in this book, and O’Reilly Media, Inc. was aware of a trademark claim, the designations have been printed in caps or initial caps. While every precaution has been taken in the preparation of this book, the publisher and authors assume no responsibility for errors or omissions, or for damages resulting from the use of the information contained herein. This book uses RepKover™, a durable and flexible lay-flat binding. ISBN-10: 0-596-52958-9 ISBN-13: 978-0-596-52958-1 [M] Table of Contents Credits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv 1. Introducing Microsoft Office SharePoint Server 2007 . . . . . . . . . . . . . . . . . . . . 1 Collaboration 1 Portals 11 Enterprise Search 17 Enterprise Content Management 22 Business Process and Forms 25 Business Intelligence 27 2. Changes in the WSS Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Microsoft Windows SharePoint Services Version 3.0 30 3. Installing SharePoint 2007. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Preinstallation 43 Installation 49 Post-Installation Tasks 56 4. Configuring a Multiserver Farm. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Planning for Scalability 61 Topologies 65 Implementing a Multiserver Farm 67 5. Designing SharePoint Sites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Sites Versus Site Collections 80 Site Creation and Management 81 v Determining Which Type of Site to Create 85 Create a New Site Using Site Actions 89 Enabling Self-Service Site Creation 91 Create Sites and Site Collections from the Site Directory 94 Managing Sites from the Site Directory 95 Show New Categories on the Create Site Page 101 Add or Edit Site Directory Categories 103 Scan for Broken Links in Site Directory 106 6. Understanding the Datasheet and Explorer Views . . . . . . . . . . . . . . . . . . . . 108 Datasheet View 108 Explorer View 132 7. Applying Templates, Page Layouts, and Themes . . . . . . . . . . . . . . . . . . . . . . 135 Site Templates 136 Default Site Templates 136 Site Template and Page Layout Settings 142 Managing Site Themes and Images 152 8. Creating Web Parts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 Default Web Parts 161 Select a Web Part Page 167 Customize a Web Part Page 168 Connect Data in Web Parts 171 Using Content Editor Web Parts 178 Using Form Web Parts 180 Using Image Web Parts 183 Using List View Web Parts 185 Using Page Viewer Web Parts 189 Using Site Users Web Parts 190 Using XML Web Parts 192 9. Creating and Managing Document Workspaces and Libraries. . . . . . . . . . . 195 What Is the Significance of Document Libraries? 196 Organizing Documents 205 Document Management and Workflow 213 Document Workspaces 218 vi | Table of Contents 10. Creating and Managing Meeting Workspaces . . . . . . . . . . . . . . . . . . . . . . . . 223 Meeting Workspace Templates 223 Creating and Designing a Meeting Workspace Site 224 Customizing a Meeting Workspace Site 228 Working with Pages in a Meeting Workspace Site 236 Assigning and Tracking Tasks in a Meeting Workspace Site 241 Managing Attendees in a Meeting Workspace Site 245 11. Creating and Managing Discussions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 248 Discussion Group Views 248 Creating a SharePoint Discussion Board 250 Customizing a Discussion Board 254 Participating in a Discussion 263 12. Creating and Managing SharePoint Groups and Users . . . . . . . . . . . . . . . . . 270 Permission Groups 270 Adding and Configuring SharePoint Groups 273 Maintaining SharePoint Groups 280 Targeting Content Based on Group 283 Allowing Anonymous Users Access to SharePoint 291 13. Creating and Managing Picture Libraries . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Slide Libraries 296 Creating Libraries 296 Add Content to a Picture Library 299 Editing and Managing Images in a Picture Library 301 Adding Images from a Picture Library to a Web Page 307 14. Creating and Managing Lists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 316 Creating Lists 317 Managing List Templates 334 Managing Large Lists 339 15. Business Intelligence and SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 342 The Report Center 343 Creating and Customizing Dashboards 345 Excel Services Web Access 345 Table of Contents | vii External Data Sources 348 Filter Web Part Information 350 Using Key Performance Indicators (KPIs) 351 Performance Management 352 Data Analysis and Reporting 354 Data Warehousing 356 16. Sharing Contacts and Meetings with Outlook . . . . . . . . . . . . . . . . . . . . . . . . 363 SharePoint, Outlook 2007, and Collaboration 364 Enabling Email Support in Central Administration 366 Configuring Email Support During Site Creation 369 Enabling Email Support for Lists and Libraries 370 Outlook Web Access 378 Using Email Servers 379 17. Creating, Editing, and Managing Word Documents with SharePoint . . . . . 381 Content Types and Document Libraries 382 Managing Document Library Workflow 387 SharePoint, Word 2007, and Collaboration 391 18. Creating, Editing, and Managing Excel Documents with SharePoint . . . . . 393 Office Excel 2007 and Excel Services 394 Publishing and Viewing an Excel Workbook in an Excel Web Access Web Part 395 Working with Excel Web Access Data in Office Excel 2007 401 Printing from Excel Services 405 Connecting a List View Web Part to Excel Web Access Web Part 407 Finding and Calculating in Excel Services 409 19. Creating in SharePoint Designer 2007 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 412 Customizing SharePoint Sites 415 20. InfoPath and SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 433 Improvements in InfoPath 2007 434 InfoPath Forms Architecture 436 Configuring InfoPath Forms Services 437 InfoPath and SharePoint Integration Overview 440 Forms Deployment 442 Administrative Deployment 446 viii | Table of Contents Property Promotion and Property Demotion 450 Document Information Panel 454 21. Designing SharePoint My Sites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 462 Using Your My Site 463 Adding Basic Information to My Site 465 Adding a Site Tab to My Site 470 Managing Your My Site 471 Configuring Privacy Groups in My Site 474 Managing My Colleagues in My Site 478 Customizing My Site with Role-Based Templates 483 22. Applying Security to Your SharePoint Site . . . . . . . . . . . . . . . . . . . . . . . . . . . . 485 Topology Design Considerations 485 Server Hardening 490 SharePoint Authentication 494 Utilizing Encryption 498 Levels of Administrative Rights 507 SharePoint Site Permissions and Groups 508 Object Security Functionality 511 Protecting SharePoint Sites with Microsoft ISA Server 517 Antivirus Usage 517 Other Security Considerations 519 Maintaining a Secure Environment 521 23. SharePoint Administration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 524 Common Central Administration Tasks 525 Top-Level Site Administration 548 Site Administration 550 24. Upgrading from SharePoint Portal Server 2003 . . . . . . . . . . . . . . . . . . . . . . . 554 Supported Topologies 556 Prerequisites for Upgrade 556 Perform Preupgrade Steps 557 Possible Upgrade Options 561 Gradual Upgrade 575 Upgrading the Portal Using Database Migration 596 Perform Post-Upgrade Steps 598 Common Issues 600 Table of Contents | ix 25. Using Server-Side and Client-Side Web Parts . . . . . . . . . . . . . . . . . . . . . . . . . 606 Web Parts for Power Users and Business Users 607 Web Part Architecture 615 Web Parts for Administrators 618 Web Parts for Web Masters and Web Developers 622 26. Using SharePoint Web Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 639 Services Associated with MOSS and WSS 640 Invoking Web Services 647 Utilizing Web Services with Visual Studio 655 Related APIs 658 Programming Custom Web Services 660 27. Using SharePoint Server for Search . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 663 Search from the End User’s Perspective 664 Different Features of Search 675 Architecture of Indexing and Search 677 Administering Search Services 680 Advanced Configuration Options 683 Extensibility Options Associated with Search 693 28. Using the SharePoint Object Model . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 697 Exploring the Microsoft.SharePoint Namespace 698 Deploying Customizations with SharePoint Solutions 723 Working with the Microsoft Office SharePoint Server 2007 Class Libraries 725 29. Web Content Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 739 Architecture 740 Content Publishing 754 Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 765 x | Table of Contents Credits 1 JamesPyles, currently a technical writer for Aquent Studios in Boise, Idaho, is the author of PC Technician Street Smarts: A Real World Guide to CompTIA A+ Skills (Sybex) and numerous other technical works. He has also been a SharePoint site administrator for a software group at Micron Technologies. He regularly reviews books on operating systems, web design, and programming for various web and print publications, including Linux Pro Magazine. James can be reached at http:// www.wiredwriter.net. ChristopherM.Buechler,CISSP,SSCP,MCSE,MCSA,MCDBA,isacofounderand Chief Technology Officer of BSD Perimeter, a company providing IT security ser- vices, including firewall support, vulnerability assessment, and penetration testing. He also serves as Network Manager for a regional bank, handling its network secu- rity and infrastructure. As an independent consultant, and in past positions in his decade-longcareer,hehasprovidedsecurity,network,andotherservicesfororgani- zationsinthepublicandprivatesector,rangingfromsmallorganizationstoFortune 500 companies and large public sector organizations. He can be reached at http:// ChrisBuechler.com. Bob Fox, MCP, MCTS, is currently Technical Lead, SharePoint Technologies, at B&RBusinessSolutions,LLC.HeisaMicrosoftWindowsSharePointServicesMVP, and his MVP blog can be viewed at http://bobfox.net/splog. Bob writes: “I have been working as an IT Professional since the mid 90s...I have spent a great deal of time working as a Systems Administrator dealing mainly with Microsoft Technologies. Forthepastfiveyearsmyprimaryfocus/passionhasbeenMicrosoftSharePointSer- vices. I specialize in Deployment, Portal and Site Customization, Administration, and Collaboration Solutions. I have in the past worked for such companies as Mer- rill Lynch, BISYS Retirement Services, Educational Testing Service, and Pfizer, to nameafew.IambasedoutofLawrenceville,NJ,whereIlivewithmywife,Barbara, and our children, Zachary and Sarah.” xi Murray Gordon is the Director of Technology at Cambar Solutions (www. cambarsolutions.com), a premier consulting company committed to value chain improvement through best practice consulting and technology innovation. He brings more than 10 years of technology consulting and solutions architecture experience to bear. In addition to his other duties, it is his charge to guide Cambar Solutions’ pri- maryfocusofprovidingstrategicbusiness-driventechnologysolutions. Murrayisalso acoauthorofMCPDSelf-PacedTrainingKit(Exam70-547):DesigningandDeveloping Web-Based Applications Using the Microsoft .NET Framework and MCTS Self-Paced Training Kit (Exam 70-529): Microsoft .NET Framework 2.0 Distributed Application Development (both by Microsoft Press). MichaelLotter is a SharePoint Solution Architect and Microsoft Certified Technol- ogy Specialist, currently working for B&R Business Solutions (www.bandrsolutions. com). He travels throughout the country doing SharePoint and InfoPath solution- based contract work. You can reach Michael [email protected]. JasonMedero, MCP, MCT, MCTS, MVP (WSS), is a systems architect with a con- centration in Microsoft Office SharePoint Server (MOSS) and its related Microsoft technologies. He is a managing partner of B&R Business Solutions, a central New Jersey–based firm specializing inSharePointandsurroundingtechnologies,infrastruc- ture,real-timecommunications(OCS),andapplicationdevelopment. Jasonisanactive memberoftheSharePointUserGroupinNewYorkCity,wherehesitsonthespeaker selection committee. He also contributes his SharePoint knowledge as a mentor for some of the popular forums (MSD2D, MSDN). You can visit his blog at www. sharepointblogs.com/JasonMedero or his company’s page atwww.bandrsolutions.com. NileshMehta, current President of NGenious Solutions, Inc., is a recognized senior architectinMicrosoftsolutions,specializinginMicrosoft’sOffice,SharePointServer, Project Server, Exchange Server, and Active Directory technologies. He can be reached athttp://www.ngenioussolutions.com. JorisPoelmansiscurrentlyApplicationGroupManageratDolmen(www.dolmen.be), aleadingBelgianITservicescompanyandMicrosoftGoldPartner.Hismaincompe- tenceareaisInformationWorkersolutions,wherehecurrentlyfocusesontheShare- Point Products and Technologies platform. In October 2005, he was given the Microsoft MVP award for Windows SharePoint Services. He can be contacted through his blog athttp://jopx.blogspot.com. ChristopherPragashhasmorethan11yearsofITexperienceandhasbeenpredomi- nentlyfocusedonMicrosoftsolutions.UnderhiscurrentcapacityasaSeniorShare- PointArchitect,ChristopherhasimplementedportalsbasedonMicrosoftSharePoint technologies.HisexpertieseinMicrosoftSharePointTechnologiesrangesfromhelp- ing organizations translate business requirements into SharePoint solutions, build- ing the solution, and training SharePoint administrators and developers. xii | Credits