Note: All of the addresses of the KB / Articles - 2007 Products / MS / Non-MS Articles below were valid at the time I added them to the WSS FAQ
site and to this file. I can't guarantee that they still are.

(Items are added to the WSS FAQ throughout the week so you will find new items more quickly by checking at wss.collutions.com or www.wssfaq.com daily.)

From 28th December 2008 to 3rd January 2009

NOTE: Amendment to KB articles: Microsoft are now not amending the date of a KB article if the change made is marked as a version point change (so from 2.2 to 2.3 for instance).
This ought to mean that the amendment made is cosmetic rather than important as important text changes ought to result in a major version change (such as from 2.2 to 3.0).
Because of this change and to avoid unnecessary effort I will in future not amend the listings in the WSS FAQ sites if only a minor version change has taken place.
I will continue to amend both the date and version numbers of major version changes and of course will continue to add all relevant new KB articles that my RSS feeds and other sources give me.

I.1 2007 KB Articles    (*now only one section for WSS and MOSS*)

New

http://support.microsoft.com/default.aspx?scid=kb;en-us;961176

Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): December 19, 2008

30th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;959122

Users cannot create a new variation of a page that they created in a Microsoft Office SharePoint Server 2007 site

30th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;961138

You cannot enable the Publishing feature in SharePoint Server 2007 after you delete an out-of-box standard permission level

29th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;959616

Version history is not maintained correctly in Windows SharePoint Services 3.0 when changes are made simultaneously by different users in attached list item documents and in "multiple lines of text" fields

31st December 2008

Modifed

None

I.b Forefront KB Articles

New or Modified

None

I.c InfoPath 2007 KB Articles

New or Modified

None

I.d SPD 2007 KB Articles

New or Modified

None

II. Articles - 2007 Products  (no longer with all links to articles for other Office 2007 and other 2007 Products)

New

A. Office 2007 Server Products

None

B. Other Office 2007 products

None

C. Other relevant products

None

Modified

http://www.microsoft.com/downloads/details.aspx?familyid=21eabb90-958f-4b64-b5f1-73d0a413c8ef&displaylang=en&tm

Internet Explorer Application Compatibility VPC Image (ver 4.2) [Note: includes IE8 Beta 2 VM]

31st December 2008

III WebCasts (+ PodCasts, On-Line courses) for 2007 Products

None

IV WSS v3 FAQ

New

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1680

V.203 (2008) Professional Microsoft SharePoint 2007 Reporting with SQL Server 2008 Reporting Services (Wiley - Jacob J. Sanford, Coskun Cavusoglu, Arif Ilhan Kolko)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1681

V.204 Using the Business Data Catalog Editor Tool (Wrox Blox - Zeeshan Shafiq, S. S. Ahmed)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1673

VI.146 Site Provisioning Assistant for SharePoint 2007 (commercial - SharePoint Solutions)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1674

VI.147 Workflow Essentials (commercial - SharePoint Solutions)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1675

VI.148 Alert Manager for SharePoint 2007 (commercial - SharePoint Solutions)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1676

X.250 STSADM Extensions (WSS - wsp) (free - Gary LaPointe)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1677

X.251 STSADM Extensions (MOSS - wsp) (free - Gary LaPointe)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1678

X.252 PowerShell Cmdlets (WSS - Setup Only) (free - Gary LaPointe)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1679

X.253 PowerShell Cmdlets (MOSS - Setup Only) (free - Gary LaPointe)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1682

X.254 SPVisual Dev - SharePoint Developer Tool (codeplex - "tore7506")

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1683

X.255 Imtech Fields Explorer VS Plugin 1.0.0 (codeplex - J Schmitz, Imtech)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1684

X.256 WSS 3.0 Custom Field Types: Password Field (codeplex - "TLingenf")

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1685

X.257 OCDInstalledSiteDefinitions (codeplex - Waldek Mastykarz)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1686

X.258 SPWebPartHide - Hide webpart for specific users (codeplex -  Ludovic Lefort)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1687

X.259 Variations Editor (codeplex - "LSUSlinky")

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1688

X.260 Get SharePoint to Validate (codeplex - Anders Dissing)

Modified

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1320

V.90 Professional Microsoft Office SharePoint Designer 2007 (Wrox - Woodrow W. Windischman, Asif Rehmani, Bryan Phillips) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1390

V.121 Microsoft Sharepoint Designer 2007 Bible (Wiley UK - Vikram Kartik) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1410

V.127 Using Content Types in SharePoint 2007 (Charles River Media - David Gerhardt, Kevin Martin) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=969

VI.07 Extranet Collaboration Manager for SharePoint 2007 (commercial - SharePoint Solutions) (new URLs; new higher prices; new edition)

V WSSv2 KB Articles (plus SPS 2003 Hot fixes)

New or Modified

None

VI WSSv2 FAQ

New or Modified

None

VII. MS Articles

New or Modified

None

If you have been waiting for a SPD 2007 book that doesn't come from MS Press or doesn't only cover site design, your wait is over because two new SPS 2007 books are just out and are in Stock at Amazon US.

First there's the Woody Windischman (+ a couple of other named authors)

"Professional Microsoft Office SharePoint Designer 2007" from Wrox

Amazon US: http://www.amazon.com/exec/obidos/ASIN/0470287616/heme0f

and secondly there's the SPD 2007 Bible,

Amazon US:

which they seem to have rushed into "the shops" (Amazon) once the Wrox title came out, because it wasn't due for a couple of weeks.

 

P.S. I thought that was it, but I see that "Using Content Types in SharePoint 2007 (Charles River Media) has just made it into stock too

Amazon US: http://www.amazon.com/exec/obidos/ASIN/1584506695/heme0f

 

Note: All of the addresses of the KB / Articles - 2007 Products / MS / Non-MS Articles below were valid at the time I added them to the WSS FAQ
site and to this file. I can't guarantee that they still are.

(Items are added to the WSS FAQ throughout the week so you will find new items more quickly by checking at wss.collutions.com or www.wssfaq.com daily.)

From 21st - 27th December 2008

NOTE: Amendment to KB articles: Microsoft are now not amending the date of a KB article if the change made is marked as a version point change (so from 2.2 to 2.3 for instance).
This ought to mean that the amendment made is cosmetic rather than important as important text changes ought to result in a major version change (such as from 2.2 to 3.0).
Because of this change and to avoid unnecessary effort I will in future not amend the listings in the WSS FAQ sites if only a minor version change has taken place.
I will continue to amend both the date and version numbers of major version changes and of course will continue to add all relevant new KB articles that my RSS feeds and other sources give me.

I.1 2007 KB Articles    (*now only one section for WSS and MOSS*)

New

http://support.microsoft.com/default.aspx?scid=kb;en-us;960010

Description of the Windows SharePoint Services 3.0 cumulative update package (WSS server-package): December 16, 2008

18th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;960011

Description of the SharePoint Server 2007 cumulative update package (MOSS server-package): December 16, 2008

18th December 2008

Modifed

None

I.b Forefront KB Articles

New or Modified

None

I.c InfoPath 2007 KB Articles

New

http://support.microsoft.com/default.aspx?scid=kb;en-us;959638&sd=rss&spid=11303

Description of the InfoPath 2007 hotfix package (Infopath.msp, Ipeditor.msp): December 16, 2008

18th December 2008

Modified

None

I.d SPD 2007 KB Articles

New or Modified

None

II. Articles - 2007 Products  (no longer with all links to articles for other Office 2007 and other 2007 Products)

New

A. Office 2007 Server Products

http://www.harbar.net/articles/spca.aspx

SharePoint Central Administration: High Availability, Load Balancing, Security & General Recommendations (Blog - Spencer Harbar)

26th December 2008

http://blogs.msdn.com/maximeb/archive/2008/12/23/fixing-absolute-urls-for-all-alternate-access-mappings-aam-of-content-editor-web-part-with-a-control-adapter.aspx

Fixing absolute URLs for all Alternate Access Mappings (AAM) of Content Editor Web Part with a Control Adapter (Blog - Maxime Bombardier)

23rd December 2008

http://sharepoint.microsoft.com/blogs/LKuhn/Lists/Posts/Post.aspx?List=29310d0a%2D1eda%2D4834%2Dbb4c%2D06ee575a40c3&ID=76

People Search Content Editor Web Part (Blog - Larry Kühn)

13th December 2008

B. Other Office 2007 products

None

C. Other relevant products

None

Modified

None

III WebCasts (+ PodCasts, On-Line courses) for 2007 Products

http://www.microsoft.com/winme/0711/31250/Installation_and_Config/Default.html

Microsoft Search Server 2008 Express: Installation & Configuration (Video)

25th December 2008 (date added)

http://www.microsoft.com/winme/0711/31250/End_User_Experience/Default.html

Microsoft Search Server 2008 Express: User Experience (Video)

25th December 2008 (date added)

http://www.microsoft.com/winme/0711/31250/Federation/Default.html

Microsoft Search Server 2008 Express: Federation Feature (Video)

25th December 2008 (date added)

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032396942&EventCategory=5&culture=en-US&CountryCode=US

MSDN Webcast: SharePoint Products and Technologies for Internet Site Development: Authentication (Level 300) (Todd Bleeker, Mindsharp)

11th December 2008

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032395115&EventCategory=5&culture=en-US&CountryCode=US

TechNet Webcast: Rights Management Services in Windows Server 2008 (Level 400) (Yung Chou)

10th December 2008

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032396675&EventCategory=5&culture=en-US&CountryCode=US

MSDN Webcast: BenkoTips Live and On Demand: SharePoint Server Features with Scot Hillier (Level 100) (Scot Hillier, Scot Hillier Technical Solutions, LLC and Mike Benkovich)

10th December 2008

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032396672&EventCategory=5&culture=en-US&CountryCode=US

MSDN Webcast: SharePoint Products and Technologies for Internet Site Development: Custom Fields, Web Parts, and Lists (Level 200) (Todd Bleeker, Mindsharp)

9th December 2008

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032396670&EventCategory=5&culture=en-US&CountryCode=US

MSDN Webcast: SharePoint Products and Technologies for Internet Site Development: .COM Branding (Level 200) (Doug Ware, Elumenotion, LLC)
 
4th December 2008

IV WSS v3 FAQ

New

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1647

V.187 (2008) Professional Microsoft SQL Server 2008 Reporting Services (Wrox - Paul Turley, Thiago Silva, Bryan C. Smith, Ken Withee) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1648

V.188 (2008) Applied Microsoft SQL Server 2008 Reporting Services (Prologika Press - Teo Lachev) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1649

V.189 (2008) Microsoft SQL Server 2008 Reporting Services (McGraw-Hill Osborne - Brian Larson) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1650

V.190 (2008) Pro SQL Server 2008 Reporting Services (Apress - Rodney Landrum, Shawn McGehee, Walter J. Voytek II) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1651

V.191 (2008) Microsoft SQL Server 2008 Reporting Services Unleashed (Sams - Michael Lisin, Jim Joseph, Amit Goyal)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1652

V.192 (2008) Microsoft SQL Server 2008 Reporting Services Step by Step (MS Press - Stacia Misner)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1654

V.193 Microsoft SQL Server 2005 Reporting Services 2005 (McGraw-Hill Osborne - Brian Larson) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1655

V.194 Professional SQL Server 2005 Reporting Services (Wrox - Paul Turley, Todd Bryant, James Counihan, Dave DuVarney) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1656

V.195 Pro SQL Server 2005 Reporting Services (Apress - Rodney Landrum, Walter J. Voytek II) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1657

V.196 Mastering SQL Server 2005 Reporting Services Infrastructure Design (Sybex - Joseph L. Jorden) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1658

V.197 Microsoft SQL Server 2005 Reporting Services Step by Step (MS Press - Stacia Misner and Hitachi Consulting) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1659

V.198 Microsoft SQL Server 2005 Reporting Services (Sams - Michael Lisin, Jim Joseph) *released

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1660

V.199 Developer's Guide to Reporting Services 2005 (PDSA, Inc. - John A. Kuhn, Paul D. Sheriff) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1661

V.200 SQL Server 2005 Reporting Services in Action (Manning Publications - Bret Updegraff) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1663

V.201 Microsoft SQL Server 2005 Reporting Services (in German) (MS Press Deutschland - Martin B. Schultz; Jörg Knuth, Volker Pruß) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1662

V.201A Microsoft SQL Server 2005 Reporting Services (in German) (MS Press Deutschland - Martin B. Schultz; Jörg Knuth, Volker Pruß) *released*

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1665

V.202 (2008) Microsoft SQL Server 2008 Reporting Services   - Das Praxisbuch (in German) (MS Press Deutschland - Martin B. Schultz; Jörg Knuth, Volker Pruß)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1664

V.202A (2008) Microsoft SQL Server 2008 Reporting Services   - Das Praxisbuch (in German) (MS Press Deutschland - Martin B. Schultz; Jörg Knuth, Volker Pruß)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1646

VII.41A Professional Microsoft SQL Server 2008 Reporting Services (Wrox - ISBN: 978-0-470-24201-8)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1666

VII.42 Pro SharePoint 2007 Development Techniques (Apress - ISBN: 1-59059-913-6) - Chapter 1 - Incorporating ASP.NET 2.0 into Microsoft Office SharePoint Server 2007

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1667

VII.43 SharePoint 2007 Development Recipes: A Problem-Solution Approach (Apress - ISBN: 1-4302-0961-5) Chapter 1 - Site Management

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1669

VII.44 Foundations of WF: an Introduction to Windows Workflow Foundation (Apress - ISBN: 1-59059-718-4) Chapter 1 - Introduction to Workflow and Windows Workflow Foundation

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1670

VII.45 Pro WF: Windows Workflow in .NET 3.0 (Apress - ISBN: 1-59059-778-8) Chapter 8 - Workflow Persistence)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1671

VII.46 Pro SQL Server 2008 Reporting Services (Apress - ISBN: 1-59059-992-6) Chapter 1 - Introducing the Reporting Services Architecture

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1672

VII.47 Pro PerformancePoint Server 2007: Building Business Intelligence Solutions (Apress - ISBN: 1-59059-961-6) Chapter 1 - Business Intelligence

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1653

X.297 WSS3 Workflow Tools (codeplex - Wouter van Vugt, Chris Predeek, Ted Pattison)

Modified

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1294

V.79 SharePoint 2007 Development Recipes: A Problem-Solution Approach (Apress - Mark Gerow) (prices updated/added)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1324

V.91 Developing Applications with SharePoint (Charles River - Brian Hochgurtel) *released*

Deleted

- duplicate of Item V.79  (one OUT / one not out)

- V.124 Pro ADO.NET Data Services: with ASP.NET 3.5, Sharepoint and BizTalk (Apress - John Shaw, Simon Evans) as the title has been revised and no longer includes SharePoint which is also not mentioned in the description of the book.

V WSSv2 KB Articles (plus SPS 2003 Hot fixes)

New or Modified

None

VI WSSv2 FAQ

New or Modified

None

VII. MS Articles

New or Modified

None

Note: All of the addresses of the KB / Articles - 2007 Products / MS / Non-MS Articles below were valid at the time I added them to the WSS FAQ
site and to this file. I can't guarantee that they still are.

(Items are added to the WSS FAQ throughout the week so you will find new items more quickly by checking at wss.collutions.com or www.wssfaq.com daily.)

From 14th - 20th December 2008

NOTE: Amendment to KB articles: Microsoft are now not amending the date of a KB article if the change made is marked as a version point change (so from 2.2 to 2.3 for instance).
This ought to mean that the amendment made is cosmetic rather than important as important text changes ought to result in a major version change (such as from 2.2 to 3.0).
Because of this change and to avoid unnecessary effort I will in future not amend the listings in the WSS FAQ sites if only a minor version change has taken place.
I will continue to amend both the date and version numbers of major version changes and of course will continue to add all relevant new KB articles that my RSS feeds and other sources give me.

I.1 2007 KB Articles    (*now only one section for WSS and MOSS*)

New

http://support.microsoft.com/default.aspx?scid=kb;en-us;956448

The CustomWorkflowActionsFiles rule in Pre-Upgrade Checker in Windows SharePoint Services 3.0 Service Pack 2 can warn that custom .ACTIONS files exist in the farm

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;956449

The ModifiedWebConfigWorkflowAuthorizedTypes rule in Pre-Upgrade Checker for Windows SharePoint Services 3.0 Service Pack 2 can warn that Web.config files contain modified authorized types for workflow

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;956447

The ModifiedWorkflowActionsFile rule in Pre-Upgrade Checker for Windows SharePoint Services 3.0 Service Pack 2 can warn that the default declarative workflow actions file was changed

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;956451

The CustomFieldType rule in Pre-Upgrade Checker in Windows SharePoint Services 3.0 Service Pack 2 can warn that customized field types will not be upgraded

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;956450

The CustomListView rule in Pre-Upgrade Checker can warn that customized list views that will not be upgraded

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;960577

List of all Windows SharePoint Services and SharePoint Server Pre-Upgrade Checker knowledge base articles

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;956201

The LargeLists rule in Pre-Upgrade Checker for Windows SharePoint Services 3.0 Service Pack 2 can warn about large lists circuit breaker

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;960314

Description of the Windows SharePoint Services 3.0 hotfix package (Wssmui.msp): December 16, 2008

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;959644

Description of the Windows SharePoint Services 3.0 hotfix package (Sts.msp): December 16, 2008

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;959637

Description of the SharePoint Server 2007 hotfix package (Coreserver.msp): December 16, 2008

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;960311

Description of the SharePoint Designer 2007 hotfix package (Spd.msp): December 16, 2008

17th December 2008

http://support.microsoft.com/default.aspx?scid=kb;en-us;960969

Error message when you try to save a site as a template in SharePoint Server 2007: "Failure decompressing data from a cabinet file"

16th December 2007

http://support.microsoft.com/kb/957243/en-us

Description of the update for InfoPath 2007 Help: December 9, 2008

12th December 2008

Modifed

http://support.microsoft.com/kb/950437/en-us

Expensive Transact-SQL queries are generated in the back-end instance of SQL Server when you perform a search in SharePoint Server 2007 (ver 2.0)

11th December 2008

I.b Forefront KB Articles

New or Modified

None

I.c InfoPath 2007 KB Articles

New

http://support.microsoft.com/kb/957243/en-us

Description of the update for InfoPath 2007 Help: December 9, 2008

12th December 2008

Modified

None

I.d SPD 2007 KB Articles

New or Modified

None

II. Articles - 2007 Products  (no longer with all links to articles for other Office 2007 and other 2007 Products)

New

A. Office 2007 Server Products

http://www.microsoft.com/downloads/details.aspx?familyid=795e5984-48a8-40e3-a553-0b975d340ab0&displaylang=en&tm

AD RMS Deployment in a Multiple Forest Environment Step-by-Step Guide

17th December 2008

http://www.microsoft.com/downloads/details.aspx?familyid=d7d005da-b5e4-4c2e-9d44-58b5594232be&displaylang=en&tm

AD RMS Deployment with Microsoft Office SharePoint Server 2007 Step-by-Step Guide

16th December 2008

http://msdn.microsoft.com/en-us/library/dd353265.aspx

Finding Developer Help for SharePoint Products and Technologies (Andrew Connell, Andrew Connell Inc.)

14th December 2008 (date added)

http://technet.microsoft.com/en-us/library/dd361733.aspx

Edit a noise word file (Office SharePoint Server) (Updated: 11th December 2008)

11th December 2008

http://technet.microsoft.com/en-us/library/dd361734.aspx

Edit a thesaurus file (Office SharePoint Server) (Updated: 11th December 2008)

11th December 2008

http://technet.microsoft.com/en-us/library/dd335963.aspx

Best Practices for capacity management (Updated: 4th December 2008)

4th December 2008

B. Other Office 2007 products

https://www.microsoft.com/downloads/details.aspx?familyid=760be44f-b0da-4e20-b483-6327f804dee1&displaylang=en&tm

Updates for Microsoft Office InfoPath 2007 Help

12th December 2008

C. Other relevant products

http://www.microsoft.com/downloads/details.aspx?familyid=3b6eb884-ec15-4288-a2a3-d0b47e057458&displaylang=en&tm

List Web Part for Microsoft Dynamics CRM 4.0

17th December 2007

http://www.microsoft.com/downloads/details.aspx?familyid=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en&tm

Microsoft SQL Server 2005 Service Pack 3

15th December 2008

http://www.microsoft.com/downloads/details.aspx?familyid=5d76230d-580d-4874-8c7d-93491a29db15&displaylang=en&tm

Microsoft SQL Server Management Studio Express Service Pack 3

15th December 2008

http://www.microsoft.com/downloads/details.aspx?familyid=d434dc36-a24d-44ee-937e-553c382557e3&displaylang=en&tm

Microsoft SQL Server 2005 Express Edition Toolkit Service Pack 3

15th December 2008

http://www.microsoft.com/downloads/details.aspx?familyid=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang=en&tm

Microsoft SQL Server 2005 Express Edition Service Pack 3

15th December 2008

http://www.microsoft.com/downloads/details.aspx?familyid=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en&tm

Feature Pack for Microsoft SQL Server 2005 - December 2008

15th December 2008

http://www.microsoft.com/downloads/details.aspx?familyid=b448b0d0-ee79-48f6-b50a-7c4f028c2e3d&displaylang=en&tm

Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3

15th December 2008
http://www.microsoft.com/downloads/details.aspx?familyid=e6fc3117-48c5-4fd1-a3d2-927eab397373&displaylang=en&tm

Microsoft System Center Essentials 2007 SP1 VHD

11th December 2008

https://www.microsoft.com/downloads/details.aspx?familyid=702f1b7f-7019-434a-8b18-bccc7e08469f&displaylang=en&tm

PerformancePoint Server 2007 SP2 (x86) Evaluation Version

11th December 2008

http://www.microsoft.com/downloads/details.aspx?familyid=99fa23a5-226a-4392-8ad4-b18e4c1c17f9&displaylang=en&tm

PerformancePoint Server 2007 SP2 (x64) Evaluation Version

11th December 2008

Modified

http://www.microsoft.com/downloads/details.aspx?familyid=5e94ad07-902c-422f-aadd-ff2bba9e540a&displaylang=en&tm

SharePoint Products and Technologies Protocol Documentation (ver 1208)

15th December 2008

http://www.microsoft.com/downloads/details.aspx?FamilyId=1e53f882-0c16-4847-b331-132274ae8c84&DisplayLang=en

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies (ver 9.00.4035)

15th December 2008

III WebCasts (+ PodCasts, On-Line courses) for 2007 Products

None

IV WSS v3 FAQ

New

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1641

VI.144 ASPxHtmlEditor for SharePoint (commercial - DevExpress)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1642

VI.145 ASPxGridView for Sharepoint (commercial - DevExpress)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1639

VII.12B Beginning SharePoint 2007 Administration: Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 (Wrox - ISBN 978-0-470-12529-8) (Chapter 5 - Configuring and Managing Office SharePoint Server 2007)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1640

VII.12C Beginning SharePoint 2007 Administration: Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 (Wrox - ISBN 978-0-470-12529-8) (Chapter 7 - Office integration)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1643

X.246 Monga - WSS - MOSS Deleted Files Recovery Tool (codeplex - "wlnaim")

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1644

X.247 SharePoint 2007 Developer and Administration Tools (codeplex - starznet)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1645

X.248 WSRP Toolkit for SharePoint 2007 (code gallery - "ClaudioC" [Microsoft?])

Modified

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1???

VII.12D Beginning SharePoint 2007 Administration: Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 (Wrox - ISBN 978-0-470-12529-8) (Chapter 8 *extract* Advanced Configurations - section on Searching in MOSS 2007)

(was VII.12B)

V WSSv2 KB Articles (plus SPS 2003 Hot fixes)

New or Modified

http://support.microsoft.com/kb/833714/en-us

Error message when you try to edit an Office document in a document library: "'Edit Document' requires a Windows SharePoint Services-compatible application" (ver 4.0)

13th December 2008

VI WSSv2 FAQ

New  or Modified

None

VII. MS Articles

New or Modified

None

 

I thought I was pretty clever.

I created a new web part page which contained some Federation Search web parts which got me results that were restricted to (the new) MSDN Forums and (the new) TechNet Forums respectively and stored it in the "Shared Documents" document library (OK, it would have been better to store it in a document library caled "SearchPages" but I was testing...). I then amended the standard search box so that it had two different icons (instead of one) such that clicking on the second icon sent the search string to my new web part page that then used the search string to give me the hits from the forums. It worked too (eventually).

BUT (as always there is a but) between me clicking on my second icon and getting my search results I got a screen saying that "This Page has been modified since you opened it. You must open the page again." which provided me with a "Refresh page" button, which when clicked on did go to that page and did provide me with my results.

Also when I was already located at that page and I did a new search again, I didn't get that intermediate (and thoroughly annoying) error page.

So I wasn't so clever after all. It annoyed me and try as I could, I couldn't get rid of it.

Meanwhile clicking on the first icon went to my standard resultspage (located in _layouts) directly with no error page in between.

Today, after many days of fighting the error page problem, I took a different tack.

Here are the details.

- I made a copy of my Shared Documents search results page and gave it an appropriate name (MSDNandTechNetsearchresults.aspx) (using the Windows Explorer link when in the document library).

- I discovered that although the page still had all the zones I had defined, it had no longer had any web parts, so I needed to add the ones "MSDN Forums" and "TechNet Forums" back in.

- I then needed to create a new control in addition to the NewsearchInputBox that I had previous created (with Sequence=90) when following http://msdn.microsoft.com/en-us/library/ms470880.aspx which is to amend the normal control and which thus preserves the Control's name.

This new version of mine had a new control name and sequence (Id="MikeSearchInputBox" Sequence="80") in the MikeSearchArea.xml file.

Note: You'll understand where all these files are when you read the above MSDN web page

- Then I needed to amend the MikeSearchArea.ascx file so that instead of going to the standard searchpages file, it went to my new web part page

SPHttpUtility.UrlPathEncode(web.Url + "/Shared Documents/MSDNandTechNetForumsSearch.aspx", false, false)

Note: I thought I'd play safe here and use 'Shared%20Documents' rather than 'Shared Documents'. That only led me to losing an hour as the search insisted on trying to go to a /Shared%2520Documents/MSDNandTechNetForumsSearch.aspx">http://<servername>/Shared%2520Documents/MSDNandTechNetForumsSearch.aspx page. Just use 'Shared Documents' and all is well.

(Other amendments to the files created by following the above article were only to make sure the names were matching [= all had Mike as a prefix instead of New])

- Then you need to run the three command line statements listed in the MSDN article (first time around without the -force)

stsadm -o installfeature -filename MikeSearchBox\Feature.xml -force

stsadm -o activatefeature -filename MikeSearchBox\Feature.xml -url http://wss30sp1 -force

iisreset

- Then you need to go into your new Search results page (here MSDNandTechNetsearchresults.aspx) with SharePoint Designer 2007 and change the search control so that it uses MikeSearchInputBox instead of SmallSearchInputBox.

- The final step is to create a link to your new Search results page. I did this going to Quick Launch (Site Actions / Site settings) and adding first a new heading "Search Pages" (I'm going to have more of these with different scopes now I know how to do it) and then creating a new link (MSDN and TechNet Forums Search) in that part of Quick Launch.

So now, even though I still have to make an extra click to get to the Search page, at least this extra click isn't caused by an error page. It's also much more easily extensible to add links to new search pages to the Search Pages part of Quick Launch than the system of continually adding new icons to the standard search function I was using before.

 

Note: All of the addresses of the KB / Articles - 2007 Products / MS / Non-MS Articles below were valid at the time I added them to the WSS FAQ
site and to this file. I can't guarantee that they still are.

(Items are added to the WSS FAQ throughout the week so you will find new items more quickly by checking at wss.collutions.com or www.wssfaq.com daily.)

From 7th - 13th December 2008

NOTE: Amendment to KB articles: Microsoft are now not amending the date of a KB article if the change made is marked as a version point change (so from 2.2 to 2.3 for instance).
This ought to mean that the amendment made is cosmetic rather than important as important text changes ought to result in a major version change (such as from 2.2 to 3.0).
Because of this change and to avoid unnecessary effort I will in future not amend the listings in the WSS FAQ sites if only a minor version change has taken place.
I will continue to amend both the date and version numbers of major version changes and of course will continue to add all relevant new KB articles that my RSS feeds and other sources give me.

I.1 2007 KB Articles    (*now only one section for WSS and MOSS*)

New

None

Modifed

None

I.b Forefront KB Articles

New or Modified

None

I.c InfoPath 2007 KB Articles

New or Modified

None

I.d SPD 2007 KB Articles

New or Modified

None

II. Articles - 2007 Products  (no longer with all links to articles for other Office 2007 and other 2007 Products)

New

A. Office 2007 Server Products

http://www.endusersharepoint.com/?p=1008

Why Can’t I Easily Port SharePoint Designer Workflow Solutions From One List to Another? Part 1 (EnduserSharePoint.com - Paul Galvin)

9th December 2008 (date added)

http://office.microsoft.com/en-us/help/HA103339651033.aspx

The SharePoint Shepherd's Guide for End Users extract: Create a document workspace from within a document

6th December 2008

http://office.microsoft.com/en-us/sharepointserver/HA103339681033.aspx

The SharePoint Shepherd's Guide for End Users extract: Connect your document to a SharePoint site or workspace

6th December 2008

http://office.microsoft.com/en-us/sharepointserver/HA103347451033.aspx

The SharePoint Shepherd's Guide for End Users extract: Remove a document workspace

6th December 2008

http://technet.microsoft.com/en-us/library/dd335970.aspx

Logging and auditing business data operations using the Business Data Catalog (Updated 4th December 2008)

4th December 2008

http://office.microsoft.com/download/afile.aspx?AssetID=AM103360091033

Poster: Architecture Example - Single School, Single Server

4th December 2008

http://www.devx.com/dotnet/Article/40007

Creating and Deploying SharePoint Solution Files (devx - Joydip Kanjilal)

24th November 2008

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032388934&EventCategory=5&culture=en-US&CountryCode=US

TechNet Webcast: Which Enterprise Search Solution Is Right for My Business? (Level 100) (Mei Lau)

7th November 2008

B. Other Office 2007 products

http://technet.microsoft.com/en-us/library/dd335961.aspx

Configure a dedicated front-end Web server for crawling (Search Server 2008) (updated 4th December 2008)

4th December 2008

http://technet.microsoft.com/en-us/library/dd335962.aspx

Configure a dedicated front-end Web server for crawling by using the user interface (Search Server 2008) (updated 4th December 2008)

4th December 2008

http://technet.microsoft.com/en-us/library/dd335960.aspx

Configure a dedicated front-end Web server for crawling by editing the Hosts file (Search Server 2008) (updated 4th December 2008)

4th December 2008

http://www.sharepointusecases.com/index.php/2008/10/configuring-scopes-in-microsoft-search-server-2008-part-2/

Configuring scopes in Microsoft Search Server 2008 Part 2 (Blog - Toni In)

20th October 2008

http://www.sharepointusecases.com/index.php/2008/10/configuring-scopes-on-microsoft-search-server-2008/

Configuring scopes in Microsoft Search Server 2008 Part 1 (Blog - Toni In)

19th October 2008

C. Other relevant products

None

 

Modified

http://technet.microsoft.com/en-us/library/cc263467.aspx

Deploy software updates for Office SharePoint Server 2007 (Updated 4th December 2008)

4th December 2007 (previous version 12th November 2008)

III WebCasts (+ PodCasts, On-Line courses) for 2007 Products

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032396510&EventCategory=5&culture=en-US&CountryCode=US

MSDN Webcast: SharePoint Products and Technologies for Internet Site Development: Getting Started (Level 100) (Todd S. Baginski, Advaiya)

2nd December 2008

IV WSS v3 FAQ

New

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1631

VI.137 SPSRollUpChart WebPart (commercial - SPSProfessional)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1632

VI.138 Navigation Web Parts (commercial - SPSProfessional)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1633

VI.139 SPSExplorer WebParts (commercial - SPSProfessional)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1634

VI.140 Cut Copy / Paste (commercial - SPSProfessional)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1635

VI.141 SPSRollUp (commercial - SPSProfessional)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1636

VI.142 SPSProfessional Site Creation Event Handler (commercial - SPSProfessional)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1637

VI.143 ActionDataBase (commercial - SPSProfessional)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1620

X.234 SmartTools.Charts (codeplex - Jan Tielens)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1621

X.235 ChartPart for SharePoint (codeplex - "wictor")

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1622

X.236 SharePoint PowerGUI Launcher 1.0 (codeplex - "cglessner")

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1623

X.237 Silverlight Blueprint for SharePoint (codeplex - "redmondhockey")

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1624

X.238 SharePoint AJAX RSS Aggregator WebPart (codeplex - Zlatan Dzinic)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1625

X.239 SharePoint RSS Aggregator Web Part (codeplex - Zlatan Dzinic)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1626

X.240 Active Directory Tools For SharePoint (codeplex - Burke Holland)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1627

X.241 Solutionizing for SharePoint (codeplex - "dahlbyk")

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1628

X.242 STSDev 2008 Version 1.1 (codeplex - dmcwee)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1629

X.243 Custom SharePoint Workflow template with Debugging (codeplex - Tobias Lekman)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1630

X.244 Content Type Toolbar v1.2 (free - James Milne)

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1638

X.245 SharePoint Language Store (for multi-lingual sites) (codeplex - Chris O'Brien)

Modified

None

V WSSv2 KB Articles (plus SPS 2003 Hot fixes)

New or Modified

None

VI WSSv2 FAQ

New or Modified

None

VII. MS Articles

New or Modified

None

 

It's not that long ago (this http://mikewalsh.bilsimser.com/PermaLink,guid,768c223a-4f27-479e-8f21-cbc822ae2250.aspx is the re-posted version of that post) that I posted about the strange situation that after installing Search Server 2008 Express on top of WSS 3.0, I had a set of search web parts available to me in both the Search Server site and in the (original) WSS 3.0 site but that they weren't able to be added (although listed) in the WSS 3.0 site.

I was documenting every change I made and then checking this and the situation was always the same. Yet I knew that in an identical installation (VM copy) something had "clicked" and suddenly I *could* add web parts in that VM copy's WSS 3.0 site. So I kept making a change and then trying but still nothing.

Well now I don't think I have made any change to the WSS 3.0 system but now I CAN add a search web part to my search results page that is stored in a document library in the WSS 3.0 site.

As far as I can see (and no guarantees on this because I've made such assumptions before and been proved wrong) the only change I have made since I last tried and failed to add a search web part to my search results page is the following.

On the home page (default.aspx) I added in the right-hand-column (above the WSS image) the Advanced Search box. To my surprise that worked.

I then immediately (and I mean that, I "ran") opened the search results page (in a document library in the WSS 3.0 site) and now I could add the Federation Search web part there.

I'm still in a state of shock and what's more important still somewhat disbelieving that that (adding the Advanced Search box) is the only change I've done. What I do remember is that I tried at one time to add the Federation Search web part to default.aspx and it failed and I even have a vague feeling that I've already tried to add just that Advanced Search box to default.aspx and it too failed.

So I'm wondering (and this is a sign of desperation because I don't want to have to do this entire installation again - I ran out of disk space and so I don't have yet another copy of the VM just after the installation of MSSX) whether the fact that my browser (IE7) crashed and I had to re-start it from zero had anything to do with this working now - i.e. some of my earlier server changes made the difference only IE wasn't letting me see them.

Anyway for now, I couldn't care less (which you Americans should note is the correct way to say this phrase :) ) because I'm going to start setting up my Foundation Search page !

 

As all of you will know one of the main advantages of WSS 3.0 (and MOSS 2007) over WSS 2.0 (or SPS 2003) was that users no longer saw things they couldn't do anything with.

This is officially known as "security trimming".

Now search has always had the problem that depending on the rights given to the indexing routine it could well be indexing stuff that you either don't want any non-Administrator to see or - more commonly - that you don't want a particular section of the user population to see.

That of course is where security trimming is supposed to come in. The user's search will filter out from the totality of hits all those documents (or areas of the site) that that particular user isn't allowed to see and will present to him/her only the ones he/she can look at.

That's the theory and in general it works.

But according to the search book's chapter (8) on "Securing your search results" there are some cases where that isn't the case.

One of those is if you have placed the Best Bets web part (which naturally isn't called the "Best Bets" web part - that would be too simple - it's actually called the "Search High Confidence Results" web part) on a page then the "results are not security trimmed".

The reason given is (and I don't understand it but you might) "SharePoint does not place ACLs on best bets, and best bets are shown in their own web part, separated from the search results. (That's a reason?)

Then there's the interesting suggestion that "The easiest way to secure your environment completely is to removed the Best Bets web part from your search page". 

Great. Give us a web part; don't tell us that it's flawed and then in a book most people won't buy recommend not using it. Did I mention in an earlier post that you should buy this book ?

Another case that gets a brief mention in a paragraph in this chapter is the fact that if you have a page that displays a (secured) list through a web part, then if you allow crawling of the page, the contents of the List will be available in the search results even for people who are not allowed to see the list! This just gets worse and worse ...

OK. Let's assume you know not to use the Search High Confidence Results web part and you exclude all pages with web parts containing secure lists, one way of securing data that is totally secure is to use Information Rights Management (IRM), right?

Actually yes, but in Search terms what we want is that people who do have the IRM rights to access the document will see the document in the list of documents returned by their searches and there's a snag there too which again is hidden away in a short section on IRM.  

The details taken from that (p191) are as follows.

Included in Search: You put a document into a SP Library and then make it IRM enabled ("by Sharepoint").

Not included in Search: You IRM enable a document locally and then upload it to a SP document library.

Now I don't know about you but I would have thought that IRM enabling the document before you add it to a SP library ought clearly to be the standard way of doing things as otherwise there is a time gap when the document is available on the SP site but not protected by IRM. Yet if you do that, that document isn't available to *anyone* (even people with rights to look at it) via the SP search routine.

[Later: a comment from Edgar Maucourant "About the IRM part, As far as I know when you enable IRM on a Document Library, all documents are stored unencrypted. When you request a document, SharePoint call the RMS server to encrypt the document and set the appropriate rights for you on the document based on the paramaters defined for the library and your rights. This way any documents are encrypted and secured on demand. I can't see any "time gap" but maybe I miss a point :) " cleared up this presumed problem which was caused by misreading (I prefer to call it poor wording) of the text in the chapter. That text said "the content must be IRM enabled by SharePoint after being put into a SharePoint library" which I took to mean that you upload a document ("content") and then "IRM enable" it (that single document).That to me is a reasonable interpretation of those words, but from Edgar's comment it seems that you first IRM enable the Document Library - and so when you add the document (="content") it's already covered. Maybe they could improve the text in the next printing (if that indeed is the case)!]

Anyway I haven't a clue how I can IRM enable a document that is in a SP library and they don't say so.

The point again is that you shouldn't need to buy a book to get this sort of information presented to you in a clear way (if visible only to people reading every single word of the book). But as it is in the book, again, it just adds to the reasons for buying it.

(However be warned that my usual method of buying a book; putting it on the shelf; and by magic knowing everything that is in it; won't work!)

 

There have often been questions in the forums about how to upgrade from SPS 2003 to WSS 3.0.

The snappy answer is that you can't, but that's not very helpful so the threads move on to the next level which is how you get the data from SPS 2003 to WSS 3.0.

There are two main routes

- move the data to WSS 2.0 and then upgrade the WSS 2.0 to WSS 3.0

- upgrade the SPS 2003 to MOSS 2007 and then move the data to WSS 3.0.

Both of these options have the same sort of problem, namely that SPS 2003 and MOSS 2007 both have more functionality than the equivalent WSS product so many methods of - in effect - "downgrading" won't work.

My preference is for moving the data to WSS 2.0 because in SPS 2003 there's a clear dividing line between the WSS 2.0 sites "layer" and the SPS "layer" and so the chances are that most "WSS" sites and lists will not contain any SPS functionality and so will be movable.

My next preference is to go right down to the lowest level of saving the data. By this I mean that I don't bother with backup/restores and smigrates but instead do a number of "Save List as Templates"s (with content) to save the data. It's quick, easy and as the lowest common denominator is the most likely in my view to not include any SPS functionality. Anyway, finding out if it does is simple - just try to create a WSS 2.0 list from such a template and if it works, fine. If it doesn't you'll have to use manual methods (typically involving Datasheet View) in order to transfer the *contents* of the List rather than the whole List.

Yesterday as part of the effort of moving content to the new (Mindsharp) hosted v3 WSS FAQ site, I needed to actually do that.

The (German) WSS FAQ site is actually a WSS 2.0 site in SPS 2003. It's a very simple one with nothing there that isn't in normal WSS 2.0 so I wasn't expecting any surprises when I created v2 templates from several of the lists there.

As I only have a v3 site in a VM, I then had to create a WSS 2.0 site from scratch which I haven't done for some time. This of course went into another VM.

The way I did this - and I'm sure the easiest way - was to get hold of the MSDN disk containing iso files for Windows Server 2003 R2. I first installed the product (Standard Edition) from the CD1 iso file and then was able to use the CD2 iso file to install WSS 2.0 (which required a bit of disconnecting/reassigning/connecting of an iso file to the CDROM "device" because that WSS 2.0 wanted access to CD1 but otherwise was straightforward).

Then I added the list templates to the List template gallery and created a list each from each template.

So that was the transfer from SPS 2003 to WSS 2.0 phase over.

The next step was to upgrade that to WSS 3.0.

The first step was to make sure I had done all the pre-requisites so I looked in the Installation view in my WSS FAQ site's "2007 Articles" list and found the TechNet web page starter page for upgrading to WSS 3.0

http://technet2.microsoft.com/windowsserver/WSS/en/library/91046a84-57a1-40cb-a32c-ff3395073dc91033.mspx?mfr=true

(There's also a downloadable version but I didn't want to read it in the bath and I knew that what I needed would be in a couple of web pages only)

I followed the various steps and only noticed a couple of things that didn't apply/work for me.

The first - didn't apply - was that I was told I needed to install WSS 2.0 SP2. I didn't need to because that was already installed when using the WSS 2.0 from Windows Server 2003 *R2* (as it told me after I *did* try to install it!)

The second - didn't work - was the preconfig.exe that I downloaded from the Internet to the VM's harddisk and ran from there as it said I should. Running that gave errors. However the technet web page said that you could also run pre-config after doing the installation of WSS 3.0 and before running the installation wizard (when you would be using a different preconfig.exe that w