SharePoint 2003 and SQL Server 2008
Can theSharePoint 2003SQL Server 2000 database (backend) be migrated toSQL Server 2008? In other words, we want to useSharePoint 2003withSQL Server 2008. Thank you.
January 29th, 2009 10:40am

I doubt it. Even SQL Server 2005 required Service Pack 3 before it would work with WSS 2.0 / SPS 2003 WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2009 11:03am

Hi there I can confirm that SharePoint 2003 SQL Server 2000 Databases can be backed up and restored to SQL 2008 R2. Stop all services and web on your SharePoint server before the move. Backup all your SQL 2000 databases.Restore them on your new SQL 2008/R2 database serverSetup a SQL Alias (make sure you DONT set the alias to 'Dynamic Port' or you may get the error below) on the SharePoint servers and after restarting SharePoint everything worked 100%. Kind regards Riccardo Error if using Dynamic port on Alias . -- If you move the SharePoint Portal Server 2003 databases to another computer that is running SQL Server 2000, you may receive an error message that is similar to the following when you try to access the portal site: Array cannot be null. Parameter name: Source For example, you receive this error message when you click the link that is displayed on the Web Parts Maintenance page. This error message may not be caused by a Web Part issue. You may receive this error message in situations when the TCP port that SQL Server 2000 uses is different from the TCP port that SQL Server 2000 used on the original computer. Use Client Network Utility to verify that the port that SQL Server 2000 uses is correct. --- PS. Please remember to mark your question as answered if you got good advice.
August 31st, 2012 8:49am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics