Windows Server 2003 Access-based Enumeration

Ever wanted to hide the files and folders that a user did not have access too (just like them old NetWare days?), well now you can with Windows Server 2003 Access-based Enumeration.

Thanks to Brian McCann for this one.

Download the Admin tool.
Download the readme here.

Citrix ICA Web Client

This client needs either local administrator or power users rights to run correctly on the workstation. To allow normal users to run it, edit the permissions on this registry key:
HKLM\Software\Microsoft\MSLicensing - Users - Full control

You could this either manually or through group policy.

Installing Windows Sharepoint Services v2 to use SQL Server

You need to do two things:

1. Extract files to temp directory:
stsv2 /c /t:c:\temp\wssv2

2. Install to use external SQL:
c:\temp\wssv2\setupsts remotesql=true

Upgraded to CS v1.1

I've upgraded the Server to CS v1.1.

It wasn't without problems - The main one was that the tables aspnet_Membership, aspnet_Users and cs_Userprofile did not agree with each other before the upgrade.

Thanks to Derek Larkin for the answer! He also has a blog here.

MOM 2005 error SQL Server 2000 SP3 or later not detected

Trying to install MOM 2005 on a test 2003 Server only to receive the error message "SQL Server 2000 SP3 or later not detected".

Because I have SQL 2000 SP4 installed as an upgrade of an earlier MSDE incidence (and it seems MOM 2005 install does not detect SQL 2000 SP4 correctly) I had to temporarily change the following reg key:

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSDE\MSSQLServer\CurrentVersion"
CSDVersion REG_SZ change from "8.00.2039" to "8.00.761"

Do not be confused by the MSDE term - This was what the incidence was called before being upgraded to SQL Server 2000.

Don't forget to change it back!