IT Support in Seattle

Enter Your Information Below To

Book a Complimentary Review.

CyberStreams will never sell or rent your contact information. Your info is secure with us.

Migrating a MOSS or WSS 3.0 from SQL Express to SQL 2005.

By:Christine Fettinger

This blog entry details the steps of migrating a SharePoint SQL backend from SQL Express to SQL 2005. I would like to say this was an easy deal, but it wasn’t, there were many hiccups that I did not expect to encounter and I have documented them all and how to fix each one that I have encountered (all registry hacks to prayers ;-))
Here we go…


– Install SQL 2005 on your secondary Server or VM (microsoft does not recommend to Virtualize SQL, but it has worked for some ;-))

– Install SQL SQL Management Studio or SQL Management Studio Express (click to download)

Backup all Custom Solutions, Web Parts and Templates


1.) Backup the Content Database associated with your SharePoint site within your SQL Server Express installation

2.) Copy to new server

3.) Restore the Content Database within your new Installation of SQL Server 2005

SharePoint TASKS:

1.) Disconnect the existing SharePoint server from the farm

• If a single server installation , In registry navigate to: KEY_LOCAL_MACHINE/Software/Microsoft/Shared Tools/Web Server Extensions/12.0/WSS
• Change the ServerRole from “Singleserver” to “Application”

3.) I used “Spadmin” as the service account for SharePoint so create the user account in AD “spadmin” account to local administrators group of the SharePoint server as well as adding to all the IIS worker process groups (IIS_WPG ,WSS_WPG, WSS_Admin_WPG, WSS_RESTRICTED_WPG)

4.) Run the SharePoint products and technologies wizard and connect your new SQL server

IF ERROR!: If Fails @ step 7 stating that the provisioning of Central administration failed.

Check to find if SharePoint central administration already existing in IIS Unprovision IIS using the command “psconfig -cmd adminvs -unprovision”
Stop the Central administration web site in IIS
Provision New Central administration site on port 49999 using the following command – “psconfig.exe -cmd adminvs -provision -port 49999″
Test to see if you can browse the Central administration

5.) Then create a new web application on port 80 with SSL

Create a new web application on port 80 with team site collection
Test if you can browse to the site
Then deploy the certificate on the site

6.) In Alternate Access Mappings within the Central Admin Console add:

• https://SHAREPOINTSITE in intranet zone
• in custom zone

7.) In IIS we added the host header “” for the site http://SHAREPOINTSITE

IF ERROR!:You try to browse the site it was prompts for the user credentials and does not permit the user to access

Open Registry and navigat to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Ls
Under Lsa, created a new DWORD Value with the name “DisableLoopbackCheck”,
Modify the Value data box, and give the value as 1, OK.
Restart the Sharepoint Server
Test if you can browse the site

8.) Import all Application Templates and Solutions using the commands you used during your first installation like the “Fab 40″ (click here to download)

If you forgot here is how to do so:

9.) Remove the new content database for the web application from “Content databases” in central administration

10.) Add the migrated production database using the following command:
stsadm -o addcontentdb -url http://SHAREPOINTSITE -databasename ContentDB

11.) Test Site Access – SUCCESS!

Additional Recommendations/Reference links:

Configuring ISA Server with SharePoint

Configuring Kerberos Authentication with SharePoint

Site collection quotas and locks

Manage site quotas and locks

Office SharePoint server 2007

Moss Architecture and shared service provider

Configure Alternate Access Mapping

Record Center

Record center file processing

Configure Navigation Inheritance

Managing Site Groups and Permissions

Plan Site Security

White paper: Evaluation guide for search in Office SharePoint Server

Plan to deploy index and query servers

SharePoint Administration Toolkit (Office SharePoint Server)