Nov29
Categories:
WSS is great and Search Server Express is great, put the two together and you have an awesome collaboration and search solution in one.
But Search Server Express includes WSS so why install both of them?
Answer: If you don't already own a full SQL Server license then you Search Server Express provides MSDE which is limited to 4Gb of storage where as WSS include SSEE which is only limited by your local disk capacity (content database and concurrent user load effects on performance aside). So install both products and get (almost) unlimited WSS storage and Search Server Express MOSS like search capability.
I wanted to install this configuration for my church office as it represents good value for money.
They already had a W2K3 Server license + Windows CAL's but no SQL Server. So I installed the following:
- WSS SP1 in Basic mode – provides unlimited storage SSEE database in single server only solution (no 4Gb limit like Express or MSDE)
- Upgrade to Search Server Express – adds SQL Server 2005 Express for the SSP Content and Search db (this gives you MOSS search functionality for WSS sites, web sites and Network Shares)
Note: due to memory requirements of 2 SQL instances and WSS Web Application you will need to tweak some memory setting but if you have more than 50 users you will probably need a minimum of 4 Gb, preferably 8Gb, of memory which implies 64Bit Windows.
Problems with default WSS Install
There are a few strange WSS settings when you install in Basic Mode. Most notably:
- No domain accounts used
- "SharePoint – 80" IIS Web Site created (default IIS web site is also on port 80)
- Web application on "SharePoint – 80" default zone security is set to Kerberos
Problem: if you change the AAM from the server netbios name to a friendly DNS name and add the host header to IIS, users can't login to the site.
Solution: Change the security provider for the Web Application Default zone to NTLM
Next, upgrade to Search Server Express following these instructions http://technet.microsoft.com/en-us/library/cc297193.aspx#UpgradeBasic
The SSE upgrade instruction state that:
By default, the Search Server 2008 upgrade wizard creates the default Search Center site on port 80. If there is an existing SharePoint site on that port, the Overwrite Default SharePoint Site screen appears. On this screen, click one of the following options:
- Yes, overwrite the existing site with a new default SharePoint site.
- No, do not overwrite the existing site. Create a new SharePoint site.
- No, do not create a default site.
Problem: I do not get this prompt and the Configuration Wizard fails trying to create the sample data.
Solution: Delete the "SharePoint – 80" then using Central Admin:
- re-run the Configuration Wizard which will create a new "SharePoint – 80" web application
- delete the default search site collection created in the root of the new "SharePoint – 80" web application
- create a Collaboration site collection in the "SharePoint – 80" web application
- change the AAM settings if you don't want to use the server name + add IIS host header to "SharePoint – 80"
- configure the SSP search settings as required
Now you go to the Site Settings page of your new site on the "SharePoint – 80" web application and:
- create a new sub site using the Enterprise Search template
- set the site collection search settings to use the new search site
The last problem, if you used a host header, is that the crawler is blocked from accessing IIS regardless of the crawl account or Web Application Policy. Follow these steps to resolve http://support.microsoft.com/kb/896861
Nov29
Categories:
With all the talk about Web 2.0, Social Computing and now the economic crisis, it is time to turn back to productivity and knowledge management.
If you are an employee and as part of your job you start researching the Internet or Intranet for resources, you eventually find something and add it to your browser favourites. That is great for you but there are probably other people in your organization that could benefit from your research so you do one of 3 things:
- Keep the link to yourself, why share?
- Email everyone the link with a short synopsis as to why you think they may be interested in it
- Share the link using some social tagging solution
We all know what is wrong with the first two options. There are several good public solutions for #3 like Del.icio.us but what if this research that you performed as part of your job contributes to the intellectual property of your organization? You would want to keep this information within the enterprise. Microsoft Office SharePoint Server 2007 has provided this capability since it was released in 2006 through the My Links feature (in fact Portal Server 2003 even had this capability).
Figure 1: SharePoint My Links feature
The only real weakness in this solution is the lack of multiple tagging or tying the grouping to enterprise taxonomy. Lets hope this is improved in the next version, otherwise I see great potential for swapping this out for a 3rd party solution.
Figure 2: Tagging a link using the Grouping feature
I have posted a solution previously to allow users to add links while they are browsing non SharePoint sites from a browser favourite link here http://www.wssdemo.com/Blog/Lists/Posts/ViewPost.aspx?ID=62
Back to Knowledge Management... Combining the My Links that an expert has gathered and categorised along with his user profile, other users are more likely to discover these resources when they are searching for a particular topic.
Figure 3: User Profile fields to assist in KM
You could either have a SharePoint site per specialist subject area and use search results web parts (Core Results and People results parts) to exposes the people and information relevant to the topic, or a tab in the search centre for KM with customized web parts.
Back to productivity... Helping people find relevant information and authoritative resources quickly will increase productivity.
I can see this scenario being built in one of my demo images...
Just don't try and use one of those analysts ROI statements on the cost of time spent searching for information to justify a new purchase of anything, this post is intended for organizations that already own SharePoint Server but are not getting the full potential of its capability to deliver on productivity and KM.
Nov29
Categories:
SharePoint provides rich integration between content and users (Office Communicator presence information and a hyperlink to display user details). This can be seen everywhere a user name is assigned to a piece of content which can be:
- Created/Modified By details for any item display page or view that includes these columns
- Site group membership from settings page or web part
- People & Group column added to any list/library
- Workflow and version details
For Microsoft Office SharePoint Server 2007, some customers find that clicking on a user name takes them to the My Site persondetails.aspx page while others only see the simple WSS userdisp.aspx page. Why is that?
All people links go to http://SiteCollectionURL/SiteURL/_layouts/userdisp.aspx?ID=17&Source=... And this page decides whether to redirect to the My Site provider defined in the SSP that the Web Application containing the content site collection is assigned to based on one of the following rules:
- Host name of the My Site web application matches the site from where userdisp.aspx is called (i.e. both web applications are running on different port numbers)
- The site collection where userdisp.aspx is called from has a Portal Connection setting which is set to the My Site url (this would add the My Site to the start of the breadcrumb navigation for OOTB master pages which most customers don't want)
Figure 1: WSS simple user details page (happy Adam?)
I found many references to this problem searching on the web and several proposed solutions that were flawed so, here is a solution that works and has been tested in a medium farm environment of 3 WFE's and 14,000 users in the profile db(thanks to my colleague Craig for refining my solution down to the 4 lines of code).
The solution would be for Microsoft to fix this. It is obvious based on the Intranet Web Application -> SSP -> MySite relationship that they are trusted.
My solution involves modifying the userdisp.aspx page in the 12\templates\layouts directory so you should review this article first http://support.microsoft.com/kb/944105
This solution doesn’t even require users to have a physical My Site or even permissions to create a My Site. All you have to do is verify that the public page has the correct permissions by browsing to the permissions page on the My Site Host.
Add the following line to the start of the first line in userdisp.aspx
<%@ Assembly Name="Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
Add the rest of this code just before the final </asp:Content> tag at the bottom of the page
<%
// Changes to redirect User Display to My Site if the user has a profile in the SSP
try
{
UserProfileManager profileManager = new UserProfileManager(ServerContext.Default);
bool userExists = profileManager.UserExists(this.UserListForm.Item["Account"].ToString());
if (userExists)
{
Response.Redirect(profileManager.MySiteHostUrl + "/Person.aspx?accountname=" + this.UserListForm.Item["Account"].ToString());
}
}
catch
{
// do nothing, original userdisp content will be displayed
}
%>
There is a scenario not covered by this customization or the OOTB userdisp page and that is when the user has been deleted from AD, removed from the SPS User Profile and deleted from the Site Collection. The OOTB userdisp.aspx page just shows an error but in some customer environments there may be historical information about people who have left for auditing purposes (like their job title, cost center, termination date or manager were) which would be useful to display.
Nov28
Categories:
Microsoft has just published this whitepaper to give you guidance on automating the installation of SharePoint. Although some might say "Others have already done this" or "I have a much better solution" it provides a good description of the process and, even better, has a good diagram showing the process.

Some of my tips:
- I build the Application Server first which makes it the Central Administration Server (may just be an error by the author)
- Use Powershell (bring on the day we deprecate the CMD shell. Unfortunately I know, it will never happen;-)
-
Think about all the default things that probably should be changed and automate the settings (adsutil.vbs is very handy)
- log file locations (for IIS and SharePoint), SharePoint Data location and index files.
- IIS Compression settings
- Web Proxy settings in web.config
- Don't install .Net 3.5sp1 as the base install (which includes 2.0 & 3.0 as opposed to 3.0) as there are a few issues, trust me. You can upgrade to 3.5 SP1 after SharePoint is installed.
-
Evaluate some of the CodePlex projects to automate configuration and administration.
- Search managed properties (use a dummy stp site template with all the list/library columns you want to index , run a full crawl, then script the creation of managed properties and scopes)
- User profile configuration (I had a customer with lots of custom AD attributes they wanted to import and display in the user profile. The SSP web UI is painfully slow to add and order these
- ULS Log viewer
We can build a 3 WFE + App server farm from the basic OS in about 1 hour including deployment of custom wsp solutions. It is worth the effort so get scripting...
Nov26
Categories:
An interesting comparison of my site stats vs Joel Olsen.
Thanks to Joel for publishing some of his Google Analytics details. I noticed a few subtle differences between my stats (all of wssdemo.com, including blog) and Joel's.
- Direct vs Google are swapped around, hence the title of this post! (this is for one day...). As far as the keywords go, I'm just not famous :-(
Compare to Joel's traffic sources
- Non Search Engine referrals, the LinkedIn referrals relate to job offers from recruitment companies that want me to work in obscure places
Compare to Joel's Referrals
- Search Traffic (1 week) – I had a total of 16 search engines although I had never heard of 11-16
Compare to Joel's Search Traffic
- Technical Profile – almost identical
Compare to Joel's technical profile
- Global Reach – India is higher up for me, I think that might be all the MS PSS & PFE people there who click on my internal email signature when I answer their internal request for help emails.
Compare to Joel's Global Visitors
If Joel could install the CKS:EBE then his RSS feed issues would be solved. My Feed Burner subscribers per day are > 700.
Nov20
Categories:
For those who were at Sydney partner training I delivered yesterday, this is the application I said should be available any day;-)
StickySorter is an Office Labs sponsored spare-time project by two Microsoft employees, Julie and Sumit. The idea sprung from the need for project teams all over the world to gather and organize data using a collaborative process known as affinity diagramming. Since its inception, StickySorter has evolved into a desktop application so anyone can use it to collaborate and organize ideas electronically, using a familiar sticky note interface.
This could be an excellent tool to help capture document template and taxonomy requirements for your SharePoint Project
You can also define fields in the notes and all of the data captured can be exported to a CSV file.
Think; Tablet, Projector, remote users via Live Meeting...
Get it here http://www.officelabs.com/projects/stickysorter/Pages/default.aspx
Nov3
Categories: SharePoint document libraries support enforcing check out to make any changes to a document or its metadata. This is set in the Version Settings menu of the document library settings.
You might think that this option should be on by default but there are some downsides to doing this. The biggest impact to requiring check out is that you can't use the bulk editing Datasheet View. If require checkout is enabled, the Datasheet View will display "This view is read-only" message at the bottom.
Note: the Read-only indicator on the right is field specific.
If you don't enable the "Require Check Out" option then users need to be aware of how SharePoint prevents duplicate editing of a file (the following assumes Office 2007).
Explicit Check-Out
This happens when a user selects this option from the item actions drop-down menu.
There are three problems with this
- Assumption that the user knows to do this
- The drop down may not be available in the current view
- The document name is a hyperlink so the user may click on in their hast to edit it
(In WSS v2 and SPS 2003, selecting this option didn't actually open the document which confused users even more)
Implicit Check-out
If a user just click on the file name, the file will be implicitly checked out for a period of time dependant on the client OS (see my technical blog post on what happens when a user clicks on a hyperlink)
OS | Timeout |
Windows XP | 15 minutes |
Vista | 60 minutes |
If someone else clicks on the file during this time, they will see the following message...
As soon as a user closes a file that is implicitly checked out, the lock will be released (regardless of whether they save their changes or not) allowing another user to edit the file.
Note: if Office crashes or there is a network outage or RAS disconnect, the lock may remain in place and you either have to wait for the timeout or initiate an IIS reset on the server that the user opened the document from (hard to determine in an NLB environment).
In a nutshell, a quick document edit doesn't require users to explicitly check-out a document (MS obviously realised that 15 minutes was a bit too short for XP for a quick document editing session).
Why give the users so many choices? Wait for my next post on the different reasons why documents are stored in SharePoint.
Nov2
Categories:
Nov1
Categories: IIS 7 Smooth Streaming + Silverlight + Akamai distributed network!
Even in little old New Zealand, at the end of the Internet, this looks fantastic! Check it out http://www.smoothhd.com/
Oct30
Categories: It also provides valuable reporting capability.
The critical conditions that the SharePoint Management Pack monitors are summarized in the following reports that can be easily viewed through the System Center reporting console. Rules can be defined to alter how and when data is gathered, influencing the contents of these reports.
- Alerts Report
- Most Common Alerts Report
- Event Analysis Report
- Most Common Events Report
- .NET CLR Data Performance Report
- .NET CLR Memory Performance Report
- ASP .NET Applications Performance Report
- Indexing Service Performance Report
- Logical Disk Performance Report
- Memory Performance Report
- MOSS Search Performance Report
- Network Interface Performance Report
- Paging File Performance Report
- Physical Disk Performance Report
- Process Performance Report
- Processor Performance Report
- System Performance Report
- Web Service Performance Report across your SharePoint environments.

To help SharePoint teams meet and report on service level targets, the Service Level Dashboard for Operations Manager, a solution accelerator available as a download, provides the ability to monitor availability and performance for the entire SharePoint service from both the user's perspective and from a backend perspective. Top-level views and drill down capabilities let administrators investigate and resolve problems before they affect service levels.
If you want assistance with Monitoring Service for SharePoint 2007 with System Center Operations Manager 2007 might be what you need. (OK, I am an MCS consultant but I'm not desperate for work, just letting you this option is available;-)
Next >>