Sunday, 9 December 2007

Moving Windows Sharepoint Services Databases in SQL 2005

I was migrating an old WSS 2.0 site on SQL 2000, to WSS 3.0 on SQL 2005, and didn't like where the default databases were being created.

I detached the databases, moved them to thier new location, and re-attached them.
This changed the owner from "NT Authority\Network Service" to my account.

I used the following SQL code to change the owner back:
  USE whichever_database
  EXEC sp_changedbowner 'NT Authority\Network Service'

Thanks to Kalen Delaney for that!

No comments:

Post a comment