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

Hello,
I am reviewing SQL Server 2000 Reporting Services for my company.
I have purchased the book "Hitchhikers Guide to SQL Server 2000 Reporting
Services". to help me and the tool seems amazing. Unfortunately, I cannot
setup my machine to install it.
Using my Universal Subcription, I downloaded "SQL Server 2000 Reporting
Services Service Pack 2 (English)"
Whenever I try to install, I get the following error:
"Microsoft SQL Server 2000 Reporting Services
Setup -- This edition of the Report Server Database
is not supported on the edition of SQL Server 2000 you have chosen. Please
choose another SQL Server that matches the requirements. "
I have a WinXP Pro Machine
Personal Edition SQL Server 2k SP4
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
I have read the requirements and I think I have the required versions to
install and run Reporting Services. Anyone help me?
Can SQL Svr 2k Reporting Services be deployed to a Win XP pro workstation?
Thanks,
Dan H.Look at,
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx
I think the issue is with SQLServer, not the OS.
Fred.
<DapperDanH@.nospam.nospam> wrote in message
news:u79%23vi1pFHA.3004@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I am reviewing SQL Server 2000 Reporting Services for my company.
> I have purchased the book "Hitchhikers Guide to SQL Server 2000 Reporting
> Services". to help me and the tool seems amazing. Unfortunately, I cannot
> setup my machine to install it.
> Using my Universal Subcription, I downloaded "SQL Server 2000 Reporting
> Services Service Pack 2 (English)"
> Whenever I try to install, I get the following error:
> "Microsoft SQL Server 2000 Reporting Services
> Setup -- This edition of the Report Server
> Database is not supported on the edition of SQL Server 2000 you have
> chosen. Please choose another SQL Server that matches the requirements. "
> I have a WinXP Pro Machine
> Personal Edition SQL Server 2k SP4
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows
> NT 5.1 (Build 2600: Service Pack 2)
> I have read the requirements and I think I have the required versions to
> install and run Reporting Services. Anyone help me?
> Can SQL Svr 2k Reporting Services be deployed to a Win XP pro workstation?
> Thanks,
> Dan H.
>
>|||Fred, Thanks for the response. As you point out, RS does not work with
Personal Edition.
The next thing I tried was Workgroup Edition on WinXP. Even the Workgroup
Edition did not work. I am downloading Developer Edition right now.
My target production machine is to use RS on a Windows XP Pro workstation.
My understanding is that for production version, there are only 3 SQL Server
Options: Entreprise, Standard and Workgroup. For Win XP, the only version
we can deploy is WorkGroup, the other 2 versions require a "server" machine.
Can SQL Server 2000 Reporting Services be deployed on a Win XP Pro with SQL
Server Workgroup SP4? I was unsuccessful at getting that to install but
perhaps I am not installing something properly...any help?
Thanks,
Dan
"Fred" <fredbp10@.tiscali.co.uk> wrote in message
news:%236Wzah2pFHA.272@.TK2MSFTNGP15.phx.gbl...
> Look at,
> http://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx
> I think the issue is with SQLServer, not the OS.
> Fred.
>
> <DapperDanH@.nospam.nospam> wrote in message
> news:u79%23vi1pFHA.3004@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I am reviewing SQL Server 2000 Reporting Services for my company.
>> I have purchased the book "Hitchhikers Guide to SQL Server 2000 Reporting
>> Services". to help me and the tool seems amazing. Unfortunately, I
>> cannot setup my machine to install it.
>> Using my Universal Subcription, I downloaded "SQL Server 2000 Reporting
>> Services Service Pack 2 (English)"
>> Whenever I try to install, I get the following error:
>> "Microsoft SQL Server 2000 Reporting Services
>> Setup -- This edition of the Report Server
>> Database is not supported on the edition of SQL Server 2000 you have
>> chosen. Please choose another SQL Server that matches the requirements. "
>> I have a WinXP Pro Machine
>> Personal Edition SQL Server 2k SP4
>> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
>> Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on
>> Windows NT 5.1 (Build 2600: Service Pack 2)
>> I have read the requirements and I think I have the required versions to
>> install and run Reporting Services. Anyone help me?
>> Can SQL Svr 2k Reporting Services be deployed to a Win XP pro
>> workstation?
>> Thanks,
>> Dan H.
>>
>|||RS 2000 only works with Standard and Enterprise. RS 2005 will work with
Express, Workgroup, Standard and Enterprise but for Express and Workgroup it
is only basic report. RS 2005 comes out in November. If you are evaluating
now, then by the time you go into production RS 2005 might be the way to go.
The first link shows what works with what edition.
RS 2005 feature / editions:
http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx
Some of the new RS 2005 features are shown in this whitepaper:
http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx
Product launch will happen in November 2005:
http://www.microsoft.com/presspass/misc/06-07flessner-teched05.mspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services.
<DapperDanH@.nospam.nospam> wrote in message
news:OYwFOn2pFHA.3888@.TK2MSFTNGP10.phx.gbl...
> Fred, Thanks for the response. As you point out, RS does not work with
> Personal Edition.
> The next thing I tried was Workgroup Edition on WinXP. Even the Workgroup
> Edition did not work. I am downloading Developer Edition right now.
> My target production machine is to use RS on a Windows XP Pro workstation.
> My understanding is that for production version, there are only 3 SQL
> Server Options: Entreprise, Standard and Workgroup. For Win XP, the only
> version we can deploy is WorkGroup, the other 2 versions require a
> "server" machine.
> Can SQL Server 2000 Reporting Services be deployed on a Win XP Pro with
> SQL Server Workgroup SP4? I was unsuccessful at getting that to install
> but perhaps I am not installing something properly...any help?
> Thanks,
> Dan
>
> "Fred" <fredbp10@.tiscali.co.uk> wrote in message
> news:%236Wzah2pFHA.272@.TK2MSFTNGP15.phx.gbl...
>> Look at,
>> http://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx
>> I think the issue is with SQLServer, not the OS.
>> Fred.
>>
>> <DapperDanH@.nospam.nospam> wrote in message
>> news:u79%23vi1pFHA.3004@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I am reviewing SQL Server 2000 Reporting Services for my company.
>> I have purchased the book "Hitchhikers Guide to SQL Server 2000
>> Reporting Services". to help me and the tool seems amazing.
>> Unfortunately, I cannot setup my machine to install it.
>> Using my Universal Subcription, I downloaded "SQL Server 2000 Reporting
>> Services Service Pack 2 (English)"
>> Whenever I try to install, I get the following error:
>> "Microsoft SQL Server 2000 Reporting Services
>> Setup -- This edition of the Report Server
>> Database is not supported on the edition of SQL Server 2000 you have
>> chosen. Please choose another SQL Server that matches the requirements.
>> "
>> I have a WinXP Pro Machine
>> Personal Edition SQL Server 2k SP4
>> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
>> 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition
>> on Windows NT 5.1 (Build 2600: Service Pack 2)
>> I have read the requirements and I think I have the required versions to
>> install and run Reporting Services. Anyone help me?
>> Can SQL Svr 2k Reporting Services be deployed to a Win XP pro
>> workstation?
>> Thanks,
>> Dan H.
>>
>>
>|||I have RS 2000 loaded with a SQL Server 2000 Developer edition. Works fine.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uGXZZk3pFHA.3980@.TK2MSFTNGP15.phx.gbl...
> RS 2000 only works with Standard and Enterprise. RS 2005 will work with
> Express, Workgroup, Standard and Enterprise but for Express and Workgroup
> it is only basic report. RS 2005 comes out in November. If you are
> evaluating now, then by the time you go into production RS 2005 might be
> the way to go. The first link shows what works with what edition.
> RS 2005 feature / editions:
> http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx
> Some of the new RS 2005 features are shown in this whitepaper:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx
> Product launch will happen in November 2005:
> http://www.microsoft.com/presspass/misc/06-07flessner-teched05.mspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services.
> <DapperDanH@.nospam.nospam> wrote in message
> news:OYwFOn2pFHA.3888@.TK2MSFTNGP10.phx.gbl...
>> Fred, Thanks for the response. As you point out, RS does not work with
>> Personal Edition.
>> The next thing I tried was Workgroup Edition on WinXP. Even the
>> Workgroup Edition did not work. I am downloading Developer Edition right
>> now.
>> My target production machine is to use RS on a Windows XP Pro
>> workstation. My understanding is that for production version, there are
>> only 3 SQL Server Options: Entreprise, Standard and Workgroup. For Win
>> XP, the only version we can deploy is WorkGroup, the other 2 versions
>> require a "server" machine.
>> Can SQL Server 2000 Reporting Services be deployed on a Win XP Pro with
>> SQL Server Workgroup SP4? I was unsuccessful at getting that to install
>> but perhaps I am not installing something properly...any help?
>> Thanks,
>> Dan
>>
>> "Fred" <fredbp10@.tiscali.co.uk> wrote in message
>> news:%236Wzah2pFHA.272@.TK2MSFTNGP15.phx.gbl...
>> Look at,
>> http://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx
>> I think the issue is with SQLServer, not the OS.
>> Fred.
>>
>> <DapperDanH@.nospam.nospam> wrote in message
>> news:u79%23vi1pFHA.3004@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I am reviewing SQL Server 2000 Reporting Services for my company.
>> I have purchased the book "Hitchhikers Guide to SQL Server 2000
>> Reporting Services". to help me and the tool seems amazing.
>> Unfortunately, I cannot setup my machine to install it.
>> Using my Universal Subcription, I downloaded "SQL Server 2000 Reporting
>> Services Service Pack 2 (English)"
>> Whenever I try to install, I get the following error:
>> "Microsoft SQL Server 2000 Reporting Services
>> Setup -- This edition of the Report Server
>> Database is not supported on the edition of SQL Server 2000 you have
>> chosen. Please choose another SQL Server that matches the requirements.
>> "
>> I have a WinXP Pro Machine
>> Personal Edition SQL Server 2k SP4
>> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
>> 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Personal
>> Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>> I have read the requirements and I think I have the required versions
>> to install and run Reporting Services. Anyone help me?
>> Can SQL Svr 2k Reporting Services be deployed to a Win XP pro
>> workstation?
>> Thanks,
>> Dan H.
>>
>>
>>
>|||Yes it works with Developer edition for development. The question revolved
around production where you are not supposed to use Developer edition.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dm1608" <dm1608@.spam.net> wrote in message
news:ed0Sm6DqFHA.616@.TK2MSFTNGP15.phx.gbl...
>I have RS 2000 loaded with a SQL Server 2000 Developer edition. Works
>fine.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uGXZZk3pFHA.3980@.TK2MSFTNGP15.phx.gbl...
>> RS 2000 only works with Standard and Enterprise. RS 2005 will work with
>> Express, Workgroup, Standard and Enterprise but for Express and Workgroup
>> it is only basic report. RS 2005 comes out in November. If you are
>> evaluating now, then by the time you go into production RS 2005 might be
>> the way to go. The first link shows what works with what edition.
>> RS 2005 feature / editions:
>> http://www.microsoft.com/sql/2005/productinfo/rsfeatures.mspx
>> Some of the new RS 2005 features are shown in this whitepaper:
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/2005ssrs.mspx
>> Product launch will happen in November 2005:
>> http://www.microsoft.com/presspass/misc/06-07flessner-teched05.mspx
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services.
>> <DapperDanH@.nospam.nospam> wrote in message
>> news:OYwFOn2pFHA.3888@.TK2MSFTNGP10.phx.gbl...
>> Fred, Thanks for the response. As you point out, RS does not work with
>> Personal Edition.
>> The next thing I tried was Workgroup Edition on WinXP. Even the
>> Workgroup Edition did not work. I am downloading Developer Edition
>> right now.
>> My target production machine is to use RS on a Windows XP Pro
>> workstation. My understanding is that for production version, there are
>> only 3 SQL Server Options: Entreprise, Standard and Workgroup. For Win
>> XP, the only version we can deploy is WorkGroup, the other 2 versions
>> require a "server" machine.
>> Can SQL Server 2000 Reporting Services be deployed on a Win XP Pro with
>> SQL Server Workgroup SP4? I was unsuccessful at getting that to install
>> but perhaps I am not installing something properly...any help?
>> Thanks,
>> Dan
>>
>> "Fred" <fredbp10@.tiscali.co.uk> wrote in message
>> news:%236Wzah2pFHA.272@.TK2MSFTNGP15.phx.gbl...
>> Look at,
>> http://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx
>> I think the issue is with SQLServer, not the OS.
>> Fred.
>>
>> <DapperDanH@.nospam.nospam> wrote in message
>> news:u79%23vi1pFHA.3004@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I am reviewing SQL Server 2000 Reporting Services for my company.
>> I have purchased the book "Hitchhikers Guide to SQL Server 2000
>> Reporting Services". to help me and the tool seems amazing.
>> Unfortunately, I cannot setup my machine to install it.
>> Using my Universal Subcription, I downloaded "SQL Server 2000
>> Reporting Services Service Pack 2 (English)"
>> Whenever I try to install, I get the following error:
>> "Microsoft SQL Server 2000 Reporting Services
>> Setup -- This edition of the Report Server
>> Database is not supported on the edition of SQL Server 2000 you have
>> chosen. Please choose another SQL Server that matches the
>> requirements. "
>> I have a WinXP Pro Machine
>> Personal Edition SQL Server 2k SP4
>> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
>> 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Personal
>> Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>> I have read the requirements and I think I have the required versions
>> to install and run Reporting Services. Anyone help me?
>> Can SQL Svr 2k Reporting Services be deployed to a Win XP pro
>> workstation?
>> Thanks,
>> Dan H.
>>
>>
>>
>>
>|||hi,
"DapperDanH@.nospam.nospam" wrote: Fred, Thanks for the response. As you
point out, RS does not work with Personal Edition.
"Bruce L-C [MVP] " wrote: RS 2000 only works with Standard and Enterprise.
I have some Questions, RS does not work with Personal Edition?
I have RS 2000 loaded with a SQL Server 2000 Personal edition on windows
2000. Works fine.
but, RS 2000 (anyone version) with a SQL Server 2000 Personal edition on
windows 2003, not working, that this happening ?
help me please. thanks
"DapperDanH@.nospam.nospam" wrote:
> Fred, Thanks for the response. As you point out, RS does not work with
> Personal Edition.
> The next thing I tried was Workgroup Edition on WinXP. Even the Workgroup
> Edition did not work. I am downloading Developer Edition right now.
> My target production machine is to use RS on a Windows XP Pro workstation.
> My understanding is that for production version, there are only 3 SQL Server
> Options: Entreprise, Standard and Workgroup. For Win XP, the only version
> we can deploy is WorkGroup, the other 2 versions require a "server" machine.
> Can SQL Server 2000 Reporting Services be deployed on a Win XP Pro with SQL
> Server Workgroup SP4? I was unsuccessful at getting that to install but
> perhaps I am not installing something properly...any help?
> Thanks,
> Dan
>
> "Fred" <fredbp10@.tiscali.co.uk> wrote in message
> news:%236Wzah2pFHA.272@.TK2MSFTNGP15.phx.gbl...
> > Look at,
> > http://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx
> >
> > I think the issue is with SQLServer, not the OS.
> >
> > Fred.
> >
> >
> > <DapperDanH@.nospam.nospam> wrote in message
> > news:u79%23vi1pFHA.3004@.TK2MSFTNGP15.phx.gbl...
> >> Hello,
> >> I am reviewing SQL Server 2000 Reporting Services for my company.
> >>
> >> I have purchased the book "Hitchhikers Guide to SQL Server 2000 Reporting
> >> Services". to help me and the tool seems amazing. Unfortunately, I
> >> cannot setup my machine to install it.
> >>
> >> Using my Universal Subcription, I downloaded "SQL Server 2000 Reporting
> >> Services Service Pack 2 (English)"
> >>
> >> Whenever I try to install, I get the following error:
> >> "Microsoft SQL Server 2000 Reporting Services
> >> Setup -- This edition of the Report Server
> >> Database is not supported on the edition of SQL Server 2000 you have
> >> chosen. Please choose another SQL Server that matches the requirements. "
> >>
> >> I have a WinXP Pro Machine
> >> Personal Edition SQL Server 2k SP4
> >> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> >> Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on
> >> Windows NT 5.1 (Build 2600: Service Pack 2)
> >>
> >> I have read the requirements and I think I have the required versions to
> >> install and run Reporting Services. Anyone help me?
> >>
> >> Can SQL Svr 2k Reporting Services be deployed to a Win XP pro
> >> workstation?
> >>
> >> Thanks,
> >> Dan H.
> >>
> >>
> >>
> >
> >
>
>|||We are on windows 2003 and SQl server 2000 SP3a. I tried to install Reporting
services on two server but was not successfull. When I try to invoke
http://localhost/Reports it throws a bunch of DLL errors. And also in the
installation I was unable to use the service account. I used the SQLs erver
acccount instead. ANy help will be greatly appreciated.
Thanks, Madhavi
"Arturo Alegria Palacios" wrote:
> hi,
> "DapperDanH@.nospam.nospam" wrote: Fred, Thanks for the response. As you
> point out, RS does not work with Personal Edition.
> "Bruce L-C [MVP] " wrote: RS 2000 only works with Standard and Enterprise.
> I have some Questions, RS does not work with Personal Edition?
> I have RS 2000 loaded with a SQL Server 2000 Personal edition on windows
> 2000. Works fine.
> but, RS 2000 (anyone version) with a SQL Server 2000 Personal edition on
> windows 2003, not working, that this happening ?
> help me please. thanks
> "DapperDanH@.nospam.nospam" wrote:
> > Fred, Thanks for the response. As you point out, RS does not work with
> > Personal Edition.
> >
> > The next thing I tried was Workgroup Edition on WinXP. Even the Workgroup
> > Edition did not work. I am downloading Developer Edition right now.
> >
> > My target production machine is to use RS on a Windows XP Pro workstation.
> > My understanding is that for production version, there are only 3 SQL Server
> > Options: Entreprise, Standard and Workgroup. For Win XP, the only version
> > we can deploy is WorkGroup, the other 2 versions require a "server" machine.
> >
> > Can SQL Server 2000 Reporting Services be deployed on a Win XP Pro with SQL
> > Server Workgroup SP4? I was unsuccessful at getting that to install but
> > perhaps I am not installing something properly...any help?
> >
> > Thanks,
> > Dan
> >
> >
> > "Fred" <fredbp10@.tiscali.co.uk> wrote in message
> > news:%236Wzah2pFHA.272@.TK2MSFTNGP15.phx.gbl...
> > > Look at,
> > > http://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx
> > >
> > > I think the issue is with SQLServer, not the OS.
> > >
> > > Fred.
> > >
> > >
> > > <DapperDanH@.nospam.nospam> wrote in message
> > > news:u79%23vi1pFHA.3004@.TK2MSFTNGP15.phx.gbl...
> > >> Hello,
> > >> I am reviewing SQL Server 2000 Reporting Services for my company.
> > >>
> > >> I have purchased the book "Hitchhikers Guide to SQL Server 2000 Reporting
> > >> Services". to help me and the tool seems amazing. Unfortunately, I
> > >> cannot setup my machine to install it.
> > >>
> > >> Using my Universal Subcription, I downloaded "SQL Server 2000 Reporting
> > >> Services Service Pack 2 (English)"
> > >>
> > >> Whenever I try to install, I get the following error:
> > >> "Microsoft SQL Server 2000 Reporting Services
> > >> Setup -- This edition of the Report Server
> > >> Database is not supported on the edition of SQL Server 2000 you have
> > >> chosen. Please choose another SQL Server that matches the requirements. "
> > >>
> > >> I have a WinXP Pro Machine
> > >> Personal Edition SQL Server 2k SP4
> > >> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> > >> Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on
> > >> Windows NT 5.1 (Build 2600: Service Pack 2)
> > >>
> > >> I have read the requirements and I think I have the required versions to
> > >> install and run Reporting Services. Anyone help me?
> > >>
> > >> Can SQL Svr 2k Reporting Services be deployed to a Win XP pro
> > >> workstation?
> > >>
> > >> Thanks,
> > >> Dan H.
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >