Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Question about moving Sharepoint Instance

  Date: Sep 17    Category: Sharepoint    Views: 586

I've been tasked with moving my SharePoint database from SQL 2008 to SQL
Express 2008 R2. I was able to detach the database and attach the
databases to SQL Express 2008 R2. When I tried it, I kept getting
errors stating that I didn't have rights to the master database. I
checked and the account I was using has full rights to all the DBs -
even the master.

SQL Express is on a separate box from SharePoint.

Has anyone seen this before? If so, does anyone know how to fix this?



1 Answer Found

Answer #1    Answered On: Sep 17    

SharePoint can't use a copy of SQL Express that's located on a separate box.
If you are using SQL Express it has to be a standalone install with SQL
Express installed on the same box as SharePoint. I'm also not sure you will
be able to restore a regular SQL 2008 database to SQL Express 2008 r2. For
your environment you would need to stick with regular SQL.

Didn't find what you were looking for? Find more on Question about moving Sharepoint Instance Or get search suggestion and latest updates.