Problems with SQL SP2 Installation

Question

Problems with SQL SP2 Installation

CrazyMan

SSChampion

Points: 12560
More actions
September 2, 2008 at 11:27 am

#192220

Hi All
I got a new machine which has got SQL RTM on it, i am trying to install SP2 for this 64 bit server, when installing i found out that there is an reporting server with the other instance name on it, how can i remove that reporting server from SQL and install SP2
Please post your comments
Cheers
🙂

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

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

GSquared SSC Guru Points: 260824 More actions · Answer 1

I'm not sure I follow you completely.

It sounds like you have two instances of SQL Server on one computer. You are trying to upgrade one of the instances to SP 2. The other instance has Reporting Services on it, and you want to get rid of that. Is that correct?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

CrazyMan SSChampion Points: 12560 More actions · Answer 2

Thanks for your post, exactly, when i see the screen for Authentication there is one instance name (say XX) for MSSQL and other instance name for reporting server ( say YY/ReportServer), the second one gives me an error stating it cant log into this instance of reporting server

Cheers

🙂

GSquared SSC Guru Points: 260824 More actions · Answer 3

In that case, you should be able to uninstall it from Windows Control Panel. You'll want to check around and make sure, first, that nobody is actually using it.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

CrazyMan SSChampion Points: 12560 More actions · Answer 4

Thanks G-Squard

There is no such instance on control panel, so i cant unstall that instance, in this case what can i do to avoid that instance of report server being picked up

Cheers

🙂

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

when you launch the installer (via cd or control panel) you get the option to modify an existsing instance. You select an instance then elect to uninstall components from that instance

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

CrazyMan SSChampion Points: 12560 More actions · Answer 6

Thanks White

I have just found out that he old instance has been configured with the old server, i changed that reporting server to point to new database, and then problem has been cleared.

Thanks for all your Posts

Cheers

🙂