Upgrade from sql 2005 standard sp4 to sql 2005 enterprise (RTM)

Question

Post reply

Upgrade from sql 2005 standard sp4 to sql 2005 enterprise (RTM)

sri2015

SSCrazy

Points: 2780
More actions
June 6, 2012 at 2:48 am

#150951

HI,
I am srinu working as a DBA. recetnly i got one problem in upgradation
in our Reproting Server (Standby) SQL Server 2005 SP4 (Version:9.0.5000) has installed, at present we want to upgrade to SQL Server 2005 Enterprise edition RTM (no Service packs, Version:9.0.1399).when i was upgrading this, it is prompting error as "existing components are later versions". To remove service packs in Reporting server there is no uninstall option in SQL Server 2005.
How can i resolve it? if you give solution for this i very appreciate you.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

RaviTeja Gullapalli SSC Enthusiast Points: 147 More actions · Answer 1

RaviTeja Gullapalli

SSC Enthusiast

Points: 147

June 6, 2012 at 5:25 am

#1497536

Are you trying the edition upgrade option ?

sri2015 SSCrazy Points: 2780 More actions · Answer 2

yes, when i install with setup.exe, its automaticlly promting upgrade message then i have selected

components to be upgrade.

or

is there any seperate option for edition upgrade option while upgrading with setup.exe

also i have tried upgradation with command prompt also, i am getting same error "existing components are later verion".

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

i believe the two options are, download the media which has SP4 built in to the setup.exe or uninstall / reinstall then service pack

sri2015 SSCrazy Points: 2780 More actions · Answer 4

can you give me the detailed information for "download the media which has SP4 built in to the setup.exe".

If you have download link for "SQL Server 2005 Enterprise edition+SP4 (SP4 built in)", can you send me please.

and there is no option to uninstall service packs in SQL Server 2005,

this option is available from Sql server 2008 SP1 only.

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

If you have a volume licensing subscription you should have access to MS's download website, if not you will need to uninstall reporting services then reinstall it. Not just the services packs, the whole of reporting services, just ensure you backup your encryption keys.

sri2015 SSCrazy Points: 2780 More actions · Answer 6

Hi Anthony ,

Thank for your information

In Microsoft download centre also not available.

This upgradation error (Existing components are later version) is coming for Database engine service,

clinent components, management tools, sql server native client also, not only reporting service.

Ant-Green SSC Guru Points: 113507 More actions · Answer 7

well if you want to upgrade everything and if you cannot get a hold of media which is built on SP4 then you will need to uninstall and reinstall everything. if just upgrading SSRS, then just uninstall SSRS and reinstall it.