Migrating users in WSS 2.0

WSS 2.0 does not synchronise itself with Active Directory. This means that if a user account is renamed or has been moved to another domain, it can no longer log in to SharePoint. You can of course add the new account to SharePoint to grant access but then you end up with two accounts representing the same user which is not ideal for clarity in history, etc.

The correct solution is to update the username across all the content databases. With Service Pack 2 a new API was introduced and with that a new operation for stsadm.exe called 'migrateuser' which does exactly that.

For example, if a user account has been moved to a new domain, it can be migrated with the following command:

stsadm -o migrateuser -oldlogin domain1\joebloggs
-newlogin domain2\joebloggs

BSPUG: Excel Services

To follow up on my presentation last week at the Brisbane SharePoint User Group, here are some links to my slide decks as well as good starting points for learning more about Excel Services:

• My slide decks can be downloaded here.
• Excel Services Technical Overview on MSDN. This technical article includes a good introduction to exactly what Excel Services is.
• Creating Custom Solutions with Excel Services on MSDN. Here you can find links to information about the Excel Web Services and how to use them to develop custom applications.