Upgrade SharePoint 2003 and SQL 2008

Question

We have SharePoint 2003 on one farm and we have a separate cluster running MS SQL 2005. We want to upgrade the SQL server to 2008 R2 befoer we upgrade the Sharepoint server. This will leave us in a situation where we will be running SharePoint 2003 with a SQL 2008 database. I have not been able to finad anything where MS says one way or the other if SharePoint 2003 will work with SQL 2008.

Does anyone know if Sp 2003 will work with SQL 2008 R2 or if there is a document that states it one way or the other?

Answer 1

 

Hi MXRacer99,

 

You cannot upgrade directly from Microsoft Office SharePoint Portal Server 2003 to Microsoft SharePoint Server 2010.

 

You can perform a series of database attach upgrades to first upgrade your content to Microsoft Office SharePoint Server 2007 and then to SharePoint Server 2010.

 

For more information about the detailed steps, please refer to the following article:

 

Upgrading from SharePoint Portal Server 2003 to SharePoint Server 2010

http://technet.microsoft.com/en-us/library/ee947141.aspx

 

For more information about migrating SharePoint portal DB to SharePoint 2007, please refer to the following articles:

 

Migrating SharePoint Portal 2003 Database to SharePoint 2007 using Content Database Migration

http://vspug.com/johnwpowell/2007/07/12/migrating-sharepoint-portal-2003-database-to-sharepoint-2007-using-content-database-migration/

 

http://farhanfaiz.wordpress.com/2008/05/23/sharepoint-upgrade-database-migration/

---

Regards, Rock Wang Microsoft Online Community Support

Answer 2

We have SharePoint 2003 on one farm and we have a separate cluster running MS SQL 2005. We want to upgrade the SQL server to 2008 R2 befoer we upgrade the Sharepoint server. This will leave us in a situation where we will be running SharePoint 2003 with a SQL 2008 database. I have not been able to finad anything where MS says one way or the other if SharePoint 2003 will work with SQL 2008.

Does anyone know if Sp 2003 will work with SQL 2008 R2 or if there is a document that states it one way or the other?

I have this question as well.  Not talking about upgrading the SharePoint itself, just the database from SQL 2000 to SQL 2008R2

Thanks

Answer 3

I have the same issue, I have only to upgrade the sql server, anyone have the solution for this?

Answer 4

Found this, hope this help.

How to move the databases that are used by SharePoint Portal Server 2003  to a  computer that is running SQL Server

http://support.microsoft.com/kb/894164

Answer 5

SQL Server 2008 (or newer) is not supported with WSS 2.0 or SharePoint Portal Server 2003.

See Hardware and Software Requirements (Windows SharePoint Services 2.0), Database Requirements:

Database Requirements

In addition to the operating system and Web server software, you must also have a database installed on your server (or on a separate server) to run Windows SharePoint Services 2.0. The following databases are supported:

• Microsoft SQL Server 2000 Standard Edition or SQL Server 2005 Standard Edition, with the latest service pack

• Microsoft SQL Server 2000 Enterprise Edition or SQL Server 2005 Enterprise Edition, with the latest service pack

• Microsoft SQL Server 2000 Workgroup Edition or SQL Server 2005 Workgroup Edition, with the latest service pack

• Microsoft SQL Server 2000 Desktop Engine (Windows) (WMSDE)

Important:
Microsoft SQL Server 2008 is not supported for use with Windows SharePoint Services 2.0.

---

Jason Warren

Infrastructure Architect

Habanero Consulting Group

habaneroconsulting.com/blog

Answer 6

Please I am having a serious issue we have sharepoint serve 2003 with sql server 2005 suddenly the sharepoint crash leaving behind the sql server can i install new sharepoint server 2007 and connect it to the sql server will that restore the site or any suggestion please