| Groups | Blog | Home |
sql server reporting services : Report Server Database is not supported on the edition of SQL Server 2000 you have chosen
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 [quoted text, click to view] "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. [quoted text, click to view] <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. >>> >>> >>> >> >> > >
Look at,
http://www.microsoft.com/sql/reporting/productinfo/sysreqs.mspx I think the issue is with SQLServer, not the OS. Fred. [quoted text, click to view] <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.
[quoted text, click to view] "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 [quoted text, click to view] "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 [quoted text, click to view] "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 [quoted text, click to view] "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. > > >> > > >> > > >> > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |