Unable to install SQL Server Business Intelligence Development Studio

Question

Post reply

Unable to install SQL Server Business Intelligence Development Studio

Benki Chendu

SSCrazy Eights

Points: 8051
More actions
January 5, 2012 at 5:52 am

#144861

We have a clustered SQL Instance which has SQL Server 2005 standard edition with SP2 and a security update 3077.
Now, customer wanted BIDS to be installed and we are getting the following errors.
I tried running both Standard edition setup as well as enterprise edition setup
we are seeing the following errors:
Name: Microsoft SQL Server 2005 Tools
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
This is very urgent. Immediate help will be extremely appreciated 🙂

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

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

Benki Chendu SSCrazy Eights Points: 8051 More actions · Answer 1

Benki Chendu

SSCrazy Eights

Points: 8051

January 5, 2012 at 8:23 am

#1429054

Can somebody help us here:crying:

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 2

Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.

I am not able to put it in better words but ‘What's unclear in the error message’?

Benki Chendu SSCrazy Eights Points: 8051 More actions · Answer 3

Dev (1/5/2012)
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
I am not able to put it in better words but ‘What's unclear in the error message’?

But How do I overcome this issue now?

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

itsamarnath (1/5/2012)
Dev (1/5/2012)
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
I am not able to put it in better words but ‘What's unclear in the error message’?
But How do I overcome this issue now?

(God, please forgive me for this bad suggestion)

Please take a backup of your databases & all dependencies (logins, jobs etc.). Uninstall SQL Server & then install it full. Restore database back. Verify it.

Once verified, apply SP2 as well (not necessarily, immediately).

Lowell SSC Guru Points: 323518 More actions · Answer 5

i'm guessing someone may have installed the full version of Visual Studio, which would supercede the BIDS version...could that be true?

in that case, there's nothing to do...just open visual studio 2008.

when you do File...New project, you should have a Project Type Selector with "Business Intelligence Projects"

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Benki Chendu SSCrazy Eights Points: 8051 More actions · Answer 6

Dev (1/5/2012)
itsamarnath (1/5/2012)
Dev (1/5/2012)
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
I am not able to put it in better words but ‘What's unclear in the error message’?
But How do I overcome this issue now?
(God, please forgive me for this bad suggestion)
Please take a backup of your databases & all dependencies (logins, jobs etc.). Uninstall SQL Server & then install it full. Restore database back. Verify it.
Once verified, apply SP2 as well (not necessarily, immediately).

😀

So, we are in a hopeless situation now..