SharePoint 3.0
Since using BASIC and playing Star Raiders on an Atari 400 in 1979, only SharePoint is my first Killer App.
I recently upgraded a corporate SharePoint v2 installation to version 3.0. Here are my upgrade notes.
Backup v2
cd Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN
stsadm.exe -o backup -url http://hostname/ -filename z:\sharepoint2.dat -overwrite
install Dot.net 2.0
Verify that ASP.NET v2.0 appears in the Web Service Extension column and that the status is Allowed.
enable Dot.net 2.0
C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
Aspnet_regiis.exe -I -enable
Force upgrade to Dot.net 2.0
c:\Program Files\Common Files\Microsoft Shared\web server extensions\60\BIN
stsadm.exe -o upgrade -forceupgrade -url http://hostname
install Dot.net 3
install Dot.net 3.5
run prescan.exe
install Sharepoint 3 SP1
Run the SharePoint Products and Technologies Configuration Wizard
Backup Sharepoint 3 SP1
cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
stsadm.exe -o backup -url http://hostname/ -filename z:\sharepoint3_first.dat -overwrite
Error fixes, if you need them
Uninstall SQL 2005 Embedded Edition SSEE
If you need to reinstall, SQL 2005 Embedded does not uninstall cleanly. Try this:
Go to key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\ CurrentVersion\Uninstall
Find “Microsoft SQL 2005 embedded Edition”
Copy value of Key “UninstallString”
Append CALLERID=OCSETUP.EXE so it looks like this:
msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB} callerid=ocsetup.exe\
Run it and reboot.
even after you do this and the services are removed, SQL still leaves the database files in the %windir%\SYSMSI\SSEE folder. Search for mdf/ldf files and delete them.
SharePoint Products and Technologies Configuration Wizard process stopped at step 5 with this error:
runtime.interopservices.comexception was thrown, could not access the search service
Fix:
1. On the Start menu, click Run. In the Open box, type regedit and then click OK.
2. In the Registry Editor, navigate to the following subkey, and then delete it:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\WSS\Services\Microsoft.SharePoint.Search. Administration.SPSearchService
3. Run the SharePoint Products and Technologies Configuration Wizard again.
Inherit security error
One site had independant permissions that would not change to inherited permissions. I did this to break inheritance:
Change URL path from _layouts/user.aspx to _layouts/role.aspx to break inheritance. You will end up on permissions levels page.
Calendar expand fix
In SharePoint 3.0 month view the calendar displays only 3 items and has a "more items" link to expand the items. I changed mine to display 8 items. Here is how:
Within the CONTROLTEMPLATES directory i.e.
C:\Program Files\Common Files\Microsoft Shared\web server
extensions\12\TEMPLATE\CONTROLTEMPLATES
You'll find a file called DefaultTemplates.ascx (make sure you make a backup of this before making any changes to it). Open this file in NotePad & find the section for CalendarViewmonthChrome, this helps controls how the Monthly calendar view is rendered. Within this section you'll find a declaration for the MonthlyCalendarView which should look like this
SelectedDate='<%# DataBinder.Eval(Container,"SelectedDate","") %>'
ExpandedWeeks='<%# SPHttpUtility.HtmlEncode(
DataBinder.Eval(Container,"ExpandedWeeks","")) %>'
ItemTemplateName="CalendarViewMonthItemTemplate"
ItemAllDayTemplateName= "CalendarViewMonthItemAllDayTemplate"
ItemMultiDayTemplateName= "CalendarViewMonthItemMultiDayTemplate"
TabIndex=2
All you need to do is add in the property MaxVisibleEvents & set it's value to what you want, i.e. to get it to show 10 events before the expand arrow appears you'd use:
SelectedDate='<%# DataBinder.Eval(Container,"SelectedDate","") %>'
ExpandedWeeks='<%# SPHttpUtility.HtmlEncode(
DataBinder.Eval(Container,"ExpandedWeeks","")) %>'
ItemTemplateName= "CalendarViewMonthItemTemplate"
ItemAllDayTemplateName= "CalendarViewMonthItemAllDayTemplate"
ItemMultiDayTemplateName= "CalendarViewMonthItemMultiDayTemplate"
TabIndex=2
MaxVisibleEvents=10
Once you've saved the file you'll need to do an IISReset for it to take effect.