28 June 2007

Domain migrations and SPUserUtil

Although SharePoint Server 2007 is here there might still be people out there using SharePoint 2003 who will want to migrate users into another AD domain. Keith Richie has created the excellent SPUserUtil for this and there is plenty of information about using this utility to migrate domain users.

I ran into an issue while testing a domain migration and using SPUserUtil where certain stored procedures could not be found that should have been installed by the hotfix or SP2. Comments to a post on BlueDogLimited describes the same issue: "Could not find stored procedure 'dbo.sps_hMigrateAreaContactSids'."

The most likely reason that these stored procedures (there seem to be 4 of them) are not available is that the SITE database that contains the Portal site was originally created on SPS SP1 and then restored into a SP2 environment. The stored procedures are only created when you create a new portal on SP2. You can find the stored procedures in the portal site database when you create a new portal on your SPS2003 SP2 environment. These are the missing procedures:

Orgle_UpdateOrgleRulesWithMigratedAccounts (Profile database)
profile_UpdateUserProfileSID (Profile database)
sps_hMigrateAreaContactSids (Portal site database)
sps_hMigratePersonListingSids (Portal site database)