View MOSS list in datasheet view

One of the powerful things about WSS / MOSS is editing list in datasheet view.   It’s like working with a spreadsheet except it’s on the site.   I recently got a new laptop and couldn’t do this.  The error listed below came up.

“The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled. 

My laptop has IE 7.0, Windows XP, Office 2003 professional, OneNote 2007, Visio 2007.    I hadn’t tested this functionality before installing the 2007 products.   After I ran a repair on Office 2003, this resolved my issue.   Hope this helps others.

PS: Many posts mention upgrading to 2007 resolves the issue.   From what I can determine, the COM entries to this feature gets updated when installing 2007 based products while mixing with Office 2003.


MOSS, multiple forests and one-way trusts

I ran into an issue when working on a MOSS farm with the December update for MOSS.   Before applying the update,  I was running a basic x64 install with SP1.  The farm with MOSS had a one-way trust to a user-based domain.  The user-based domain didn’t trust the resource domain where MOSS was installed.   I needed to use the syntax of stsadm -o setproperty -pn peoplepicker-searchadforsts -pv “,Username,Password” as the article mentioned below since I had a one-way trust.

This article also helped with the syntax.

I strongly suggest you test this in a sandbox environment before applying or attempting to do your production environment. 

Hope this helps.

530 User cannot log in, home directory inaccessible, FTP 7.0 user isolation and Process Monitor

I was trying to reproduce an issue posted on the forums @ (   As with many posts, I mention use Process Monitor.  Here is a perfect example. 

  • Find out what PID (process ID) in task manager

  • Open Process Monitor and isolate the PID (This helps cutdown on noise)

  • Reproduce the issue. (In my case, notice the highlighted line, it’s looking for c:domainsftprootssuser1).  I have the FTP 7.0 service running on a domain controller.  It means I need to create the SS (NetBIOS name) as a virtual directory for user isolation.  I don’t recommend running FTP on a domain controller, so this is for demo purposes.  PS: Once I added the SS virtual directory, I was able to use FTP user isolation.


Here is an article how to setup FTP 7.0 

I thank Mark for creating Process Monitor!


Steve Schofield
Microsoft MVP – IIS


Bob Fox Backup and Restore Video

I’m coming up to speed on MOSS and Bob Fox has a straight-forward 20 minute video on backup and restore for MOSS.   He shows how use stsadm and the UI.    It was a good overview for those coming up to speed on MOSS.

Here is another link with great information on Technet.