all groups > sql server reporting services > september 2004 >
You're in the

sql server reporting services

group:

Trouble installing Reporting Services


Trouble installing Reporting Services Mark Hackenberg
9/24/2004 12:49:50 PM
sql server reporting services:
Hi,

I did a fresh install on a windows 2003 server. I have
IIS installed with the default webiste running. I have
SQL Server 2000 installed with service packb3a. I have
Hotfix 859 installed as well.

When I try to install Reporting Services, I get an error
message:

"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 no clue what my next step should be. Is there
another patch I have to install? I hope someone can help.

Thanks,

Re: Trouble installing Reporting Services anonymous NO[at]SPAM discussions.microsoft.com
9/24/2004 1:44:23 PM
MS SQL Server 2000 Enterprise 8.00.859 Personal Edition
Windows NT 5.2 Build 3790

The version of reporting services is from June 2004. I
think I have to install it before I can install SP 1.



[quoted text, click to view]
Re: Trouble installing Reporting Services Daniel Reib [MSFT]
9/24/2004 1:52:41 PM
Personal edition of SQL is not a supported version. See below for supported
versions of SQL.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8jom.asp


--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Re: Trouble installing Reporting Services Bruce Loehle-Conger
9/24/2004 3:03:27 PM
Do this against SQL Server and post back the result (select @@version).
Usually when this happens it is because SQL Server edition is not supported.
It is not the version number but the database edition (standard versus
enterprise versus personal etc). Also, what edition of RS are you
installing?

Bruce L-C

[quoted text, click to view]

Re: Trouble installing Reporting Services - Personal Edition Don Miller
9/26/2004 12:16:02 PM
OK, I have SQL Server 2000 Standard Edition and since I have Win2K Pro (SP4)
on my development machine the Personal Edition (SP3) is the only edition I
*could* install. I installed the Standard Edition on my production server
with Win2K Server (on a dedicated server at a hosting location).

When I tried to add Reporting Services to my Win2K Pro development machine
(using the MS-supplied disk) I get the same message as below ("This edition
of...).

So, does this mean that one cannot do development using Reporting Services
on a Win2K Pro machine (even though I've done ALL my development with SQL
Server, ASP, VBCOM, ASP.NET, etc. on it previously)?

So now I'll have to acquire and develop on a machine with either on Win2K
Server or Win 2003 (so I can install a non-personal edition of SQLServer2000
that can be upgraded to include RS)?

Is that right? (this may force me to give up on RS and stick to Crystal
Reports).


[quoted text, click to view]

Re: Trouble installing Reporting Services - Personal Edition Don Miller
9/26/2004 3:49:01 PM
Thanks. Never heard about a developer version (found out it's $50, but
cheaper than converting OSs).

Since I already have SQL Server Personal Edition on my dev machine, does
anyone know what happens when you try to install the Developer version on
top of the Personal Edition? Will I lose all my dev databases, UDFs, DTS
packages, etc.????

[quoted text, click to view]

Re: Trouble installing Reporting Services - Personal Edition Bruce Loehle-Conger
9/26/2004 4:28:37 PM
The developer edition of SQL Server should install on Win 2K Pro. I'm pretty
sure that is what I had installed. I had a development web site on 2K Pro.

Also, remember, you do not have to have the server portion installed locally
to develop with (unless you need to test jump to URL which does not work
from within the preview window). The jump to URL does work from within the
preview of the development environment.

Bruce L-C

[quoted text, click to view]

Re: Trouble installing Reporting Services - Personal Edition Bruce Loehle-Conger
9/26/2004 6:07:42 PM
My guess is that it will upgrade but that is just a guess. It is safest to
do a database backup first just in case.

If it doesn't want to upgrade it, it should say so without hurting anything.
Again, to be safe do a database dump first.

Bruce L-C

[quoted text, click to view]

Re: Trouble installing Reporting Services - Personal Edition ISGADMIN
10/14/2004 3:33:04 PM
Hi Bruce, I just installed SQL Server 2000 Developer Edition on my machine
(although @@version sure doesn't indicate anything about it being the
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.0 (Build 2195: Service Pack 4)) and I the same error
when I tried to install Reporting Services Standard edition.

thoughts?

[quoted text, click to view]
Re: Trouble installing Reporting Services - Personal Edition ISGADMIN
10/14/2004 3:37:06 PM
I verified it is indeed Developer version:

Output from: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY
('productlevel'),
SERVERPROPERTY ('edition'): 8.00.760 SP3 Developer Edition

thx

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