Query to update permissions on wss 3.0?
So sooner or later I'd like to migrate our sharepoint server. It runs wss 3.0, and it authenticates through an older domain we don't use anymore. Our company merged and we have a new domain, but users still authenticate using the old domains credentials (i.e old_domain\user) I've already tested some things out like installed wss 3.0 on a virtual machine, and restoring a backup to it using the stsadm command -restore -overwrite option. This worked great it seems, however everyones old domain accounts are in sharepoint now and users theoritically can't authenticate using these anymore since this test machine is connected to our new domain. My question is, can I run some sort of query in sql express to update all rows that contain (old domain) with the new domain? So ...a query that would update OLD_DOMAIN\USER with NEW_DOMAIN\USER?
July 20th, 2010 5:58pm

Hi, If you want to clear the old users from old domain and connect to the new domain, I suggest you to give a try in terms of the following steps: 1. stsadm -o sync –listolddatabases 2. stsadm -o sync – deleteolddatabases 3. stsadm -o sync and reset IIS and then try again Hope it is helpful!Seven
Free Windows Admin Tool Kit Click here and download it now
July 21st, 2010 12:53pm

Seven Ma; Thanks, I tried that, but its says missing operation name or operation name invalid I believe or something. Maybe sync isn't a valid operation? I tried using the migrateuser parameter and it works. However I don't want to migrate 150 accounts manually line by line with this command.
July 22nd, 2010 7:43pm

Hi, Sorry, the sync operation is available to MOSS2007 but WSS 3.0. And after my research, there is no good way to meet your need. maybe you can upgrade to MOSS 2007. Hope it is helpful!Seven
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2010 9:33am

Well I noticed the migrateuser command, it works great! But I have to do the migration one by one, or account by account. Sux, but I guess theres no other way.
July 23rd, 2010 7:37pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics