MigrateSPUsers: Sharepoint 2003 user account migration tool

January 30, 2008   9:10

At my current Sharepoint 2003 to 2007 migration project, we have to migrate Sharepoint 2003 users to a different domain server. On my world wide web search I bumped into an utility called “SPUserUtil” that was part of the “SharePoint Utility Suite”, but unfortunately the author decided to take the project offline and it is no longer available.

This blog post from Alexander Windel provided enough information about the process of migrating Sharepoint users. For WSS sites you can use the “stsadm -o migrateuser” command, but this is not enough for a Sharepoint 2003 Portal Server. The problem is that you’ll also need to use code to call the function PortalAccountMigrationManager.MigrateAccount() in the object model.

Last evening I created a small Sharepoint user migration utility, to make our life a bit easier. It will run both commands for you and it will allow you to migrate a larger batch of Sharepoint users at once.

(more…)

Posted in SharePoint, Tools | Permalink | Read 7 comments

Troubleshoot disconnected SQL Server users

July 3, 2007   12:15

If you move a database export to a new server, you might experience login problems inside your applications.

The exported database will contain your users, but they are no longer connected to valid SQL Server logins. Even if the same users are existing on the new SQL Server, their ID’s might be different. One of the options is to just recreate and configure the users, but sometimes this is not an option; You might have a lot of users or complicated user rights that you don’t want to check, test and document.

SQL Server contains stored procedure in the Master database to connect your database users with the available SQL Server users. This stored procedure is called “sp_change_users_login”. Just take the steps below to attach your users:

1. Create the (new) required login in the Security database if it doesn’t exist.
2. Run the following SQL and replace the coloured items with your values:
   USE [Your database]
   go
   EXEC sp_change_users_login ‘Update_One’, ‘Original username‘, ‘SQL Server user name‘

Narayana Vyas Kondreddi has written more detailed information about this subject at his website which contains a handy stored procedure “ShowOrphanUsers” which provides you with a list of all unconnected users.

Documentation about the “sp_change_users_login” stored procedure can be found at the MSDN website.

Posted in SQL Server | Featured url | Permalink | Post first comment