Reporting services installation error... yes another

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?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
<jim.deveraux@.gmail.com> wrote in message
news:1154452369.301398.273620@.m73g2000cwd.googlegroups.com...
> 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?
>|||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.
Bruce L-C [MVP] wrote:
> 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
>