Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

Upgrade from SQL Server 2005 to SQL Server 2008 (where SSRS 2005 is in use)

Asked By: Jean French Date: Nov 22, 2008 Category: MOSS Views: 338

We have MOSS 2007 Server fram and database is SQL Server 2005. We are planning to move to SQL Server 2008. What steps should we follow to migrate database from SQL Server 2005 to SQL Server 2008. We have SSRS 2005 ReportingS ervcies Integrated with MOSS 2007. Do we need to uninstall Reporting 2005 Add-in from MOSS 2007 and then install Reporting Add-in 2008.

Tagged:upgrade from sql server 2005 to 2008 where ssrs is in use

2 Answers Found

Answer #1 Answered By: Indrajeet Patil Answered On: Nov 22, 2008

One post that I saw states that you can backup the databases in 05, install the new instance of 08, then restore the databases on the new instance of 08. Here is a post from the sql Server Side: www.packtpub.com/.../...erver-2008-in-three-steps. You will probably need to re-run the configuration wizard to detach and attach the databases to your SharePoint Farm. I am not 100% sure on SSRS, but I found this post: blog.tech4him.com/.../. Hopefully these are helpful.

Answer #2 Answered By: Xavier Hopkins Answered On: Nov 22, 2008

Check out this blog post by Mike Watson:
blogs.msdn.com/.../...vers-to-sql-server-2008.aspx

Didn't find what you were looking for? Find more on Upgrade from SQL Server 2005 to SQL Server 2008 (where SSRS 2005 is in use) Or get search suggestion and latest updates.