cannot reinstall sql reporting service

Question

cannot reinstall sql reporting service

sqlfriend

SSC Guru

Points: 52769
More actions
March 10, 2009 at 5:39 pm

#197903

I tried to install sql server 2005 6.4 bit on windows 2008 machine.
At first I installed it on C, realizing I should install it on another drive other than C.
So I uninstalled it from program features add /remove the program.
THen I reinstalled it. Everything went OK till last step. I got an error while doing reporting service installation:
An instance with the same name is already installed on this computer.
To proceed with SQL Server Setup, provide a unique instance name
It seems the reporting service is not totally uninstalled. Then I started my second try of uninstalling the whole program from remove programs, before uninstalling I stopped all the sql services and delete the reportserver application and application pool in IIS.
Then I restarted the server, I can still see the sql reporting service in windows service panel, although its status is stopped. Then I do another installation, I still get the above message.
It seems all other database services are intalled OK, but not for reporting service. It somehow stores the instance name. How can I remove the instance name for reporting service and do a successful reporting service install.
Please help.
Thanks

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

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

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

You have to manually remove just SSRS or the whole install, use the steps in the link below.

Then make sure IIS is installed and configured with all the features needed to run Asp.net before you run the installer.

http://support.microsoft.com/kb/909967

Kind regards,
Gift Peddie

sqlfriend SSC Guru Points: 52769 More actions · Answer 2

That sounds very complicated.

Is there a registry key I can remove for report server that stores the instance name?

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

You need to print out that file and read it and you will see what you need to do to remove the SSRS related features. You may not be able to install again if the installer is seeing SSRS in your system.

Please backup the registry before editing.

Kind regards,
Gift Peddie

sqlfriend SSC Guru Points: 52769 More actions · Answer 4

Thank you.

I see there is a key folder called legacy_report server, which include the devicedesc subkey with value something like ms sql reporting service mssqlserver. This key cannot be deleted.

Is it necessary to delete it?

Thanks

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

I think you need to do the easy things to remove SSRS first like deleting in IIS everything related to SSRS and check add remove program and remove it. But I think SSRS in 2005 is one of the none configurable components so you may have to install it in C drive. There is a list by Microsoft if I find it I will post it.

Here is the SQL Server components installation path guide SSRS is fixed path so it must be installed in C drive.

http://msdn.microsoft.com/en-us/library/ms143547(SQL.90).aspx

Kind regards,
Gift Peddie

sqlfriend SSC Guru Points: 52769 More actions · Answer 6

Thanks a lot. The information you provided is very helpful.

I was desparated, and ended up searching all the sql server registry key and removed them.

Then did another install, it works now.

My lesson is next time when doing the unistall, for reporting service I need to do additional steps like stop IIS and remove the virtual directory and application pool. also remove the registry before intallation.

I thought by removing from add/remove program would have taken care of everything, apparently not.

You are right, from the article I can see part of reporting service needs to be installed on c.

Thanks again for your help

Gift Peddie SSC Guru Points: 73570 More actions · Answer 7

I am glad I could help, thanks for the feedback

🙂

Kind regards,
Gift Peddie