Groups | Blog | Home
all groups > sql server reporting services > august 2006 >

sql server reporting services : Reporting services installation error... yes another


jim.deveraux NO[at]SPAM gmail.com
8/1/2006 10:12:49 AM
Hi all,

I've seen this error a ton in the groups, but no solutions for a lot of
them. I'll try anyway.

I have recently installed MS SQL Server 2000 Developer's Edition on my
XP machine. I am trying to install Reporting Services, which is also
2000 Dev. Ed. At one screen, I get the dreaded error msg:

"This edition of the Report Server Database is not supported on the
edition of SQL Server 2000 you have chosen."

And it won't install any further. In the query analyzer, I put:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY
('productlevel'), SERVERPROPERTY ('edition')
go

select @@version
go

And get:

8.00.760 SP3 Developer Edition

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer
Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

Oddly enough, my computer is not running NT but XP instead. Anyway, I
am sure the RS is Dev. Ed. It even says so during installation. The
only thing I can think of is that I also have MSDE on the machine from
earlier, and Control Panel says it is not working properly in the
Add/Remove Programs bar. Any suggestions?
Bruce L-C [MVP]
8/1/2006 1:20:33 PM
It sounds like you have identified the problem. It seems to me that it is
detecting the MSDE. Its been a long time since I messed around with MSDE. I
would see about removing that and seeing if that clears up the problem.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Jim Deveraux
8/4/2006 9:37:29 AM
Yes, you were right Bruce. For the others out there who encounter this,
the MSDE needed to be uninstalled, and MS SQL Server 2000 reinstalled
all over again. Then everything worked.

[quoted text, click to view]
AddThis Social Bookmark Button