Tuesday, March 11, 2008

SharePoint MOSS 2007 - Moving a content database

I was struggling to move a content database from a default single server install to a SQL 2005 enterprise database server. A quick backup and restore got the database physically moved, but adding the new content database settings in the Central Admin had me stumped. Using the Central Administrator to create (though, its more a SQL server "Attach") the new content database with Windows Authentication caused an "Unknown error" in SharePoint. A quick look at the event viewer showed that the central admin was trying to connect to the SQL server via some default windows account of "MYSERVER\Sqlserver", which isnt a valid account on my SQL Server. Unfortunately I couldn't find a way to change the account being used by the central admin.

To work around this, I logged into my SharePoint server console via RDP as the user account with SQL Server admin rights, then used Stsadm to create the content database.

Instructions for moving the content database, using either the central admin or stsadm, can be found here: http://technet.microsoft.com/en-us/library/cc262018.aspx

No comments: