October 12, 2011 at 3:38 pm
I'm going to upgrade a SQL server 2005 to 2008. Database engine and reporting service instance are both on the same server.
The thing I concerned is reporting service, we don't actually have any reports yet in the 2005, but we do have it installed, and would like to upgrade it to 2008.
I understand SQL 2008 reporting service doesn't use IIS, so shall I disable IIS service?
What is the recommendation and things need to pay attention to when upgrading reporting service?
I have to do the in-place upgrade because we don't have the option on another server.
Thanks.
October 13, 2011 at 1:16 am
The first thing you should do is download and run the Microsoft SQL Server 2008 Upgrade Advisor. Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 to help you prepare for upgrades to SQL Server 2008:
Upgrade Advisor does not change any configuration settings or data.
Upgrade Advisor can analyze remote instances of SQL Server, except for SQL Server Reporting Services. To analyze Reporting Services, Upgrade Advisor must be installed and executed on the report server.
Upgrade Advisor provides the UpgradeAdvisorWizardCmd command-prompt utility to help you more easily scan multiple instances of SQL Server. See the Upgrade Advisor documentation for additional information.
Uninstalling Upgrade Advisor requires the .NET Framework 2.0. Uninstall Upgrade Advisor before uninstalling the .NET Framework 2.0.
SQL Server 2008 Books Online: Using Upgrade Advisor to Prepare for Upgrades
Problems you might encounter:
Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account
Brent Ozar's War Story: Before you upgrade to SQL Server 2008…[/url]
Sagar Sonawane
** Every DBA has his day!!:cool:
October 13, 2011 at 3:05 am
sqlfriends (10/12/2011)
I'm going to upgrade a SQL server 2005 to 2008. Database engine and reporting service instance are both on the same server.The thing I concerned is reporting service, we don't actually have any reports yet in the 2005, but we do have it installed, and would like to upgrade it to 2008.
I understand SQL 2008 reporting service doesn't use IIS, so shall I disable IIS service?
What is the recommendation and things need to pay attention to when upgrading reporting service?
I have to do the in-place upgrade because we don't have the option on another server.
Thanks.
To be honest with you if you have no reports, etc published i would uninstall the current SSRS2005 instance first. You may remove the IIS management components if you wish.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2011 at 9:34 am
To be honest with you if you have no reports, etc published i would uninstall the current SSRS2005 instance first. You may remove the IIS management components if you wish.
From my previous experience for uninstall reporting service 2005 and install a new 2005 reporting service: even after uninstall reporting service, it leaves footprint everywhere, and If I install new reporting service on it, it will have some configuration complain.
What i had to do is to go registray to delete all the sql server related keys, then the install can be clean.
So this time I would like to be prepared to avoid the frustration.
October 13, 2011 at 2:12 pm
Just an update, I uninstall reporting service, stopped the report server IIS site. And then I did a new installation of reporting service 2008, it looks good so far.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply