Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Reporting Services: Personal Edition/Standard Edition?

Posted on 2006-11-27
5
Medium Priority
?
309 Views
Last Modified: 2008-02-01
Hi Experts,

I currently have SQL Server 2000 Personal Edition installed on my computer.

While trying to install Reporting Services, some warnings/alerts came up saying:

IIS is not configured for server component
ASP.NET is not installed with Webserver
Visual Studio. NET is not installed

I went ahead anyways to install Reporting Services and installation was completed successfully.

- I read that Reporting Services can only be installed on SQL Server 2000 Standard Edition, is that true? If so, can I install Standard Edition on top of Personal Edition? OR do I need to uninstall Personal Edition before I can install Standard Edition?

- Based on the warning/alerts I got, can I still launch Reporting Services to at least get a feel of what Reporting Services can do?

- If what I have already done (Personal Edition + Reporting Services) should allow me to launch Reporting Services, then how do I launch Reporting Services?

I'm pretty confused so any help in the right direction will help.
I hope the above made sense.
Thanks!!!
0
Comment
Question by:salesprod
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 21

Accepted Solution

by:
Yurich earned 2000 total points
ID: 18023518
I don't think you'll be able to start Reporting Services. The first three things (IIS and etc.) are prerequesites and they're necessary to install Reporting Services. I'm not sure exactly about 2000, but for 2005, it would just not let you proceed unless you have all pre-requesites installed...

The better way would be uninstall Reporting Services (whatever you installed now), then uninstall the personal edition, and then install the standart edition, and finally install Reporting Services. Make sure that you installed .NET Framework (ASP.NET) and IIS (can be installed only on WinXP Pro - you can't install it on Home version).

I'm not sure about Visual Studio as I had it preinstalled and when you install 2005, it will install visual studio but only for business intelegence (reporting services), but I'd suggest that you'd get it if you do it in proper order with proper editions.

Good luck,
Yurich
0
 

Author Comment

by:salesprod
ID: 18024470
Hi Yurich,

Thanks for clearing things up. I will try to uninstall Reporting Services, Personal Edition and then reinstall Standard Edition and then Reporting Services.

However, 1 problem still exists. I tried installing IIS but unfortunately I do not have the WinXP Pro CD (though I do have WinXP Pro installed on my PC). Is there anyway I can get IIS installed without having a disc? Are there any other ways I can get it installed on my PC?

Thanks again!
0
 
LVL 21

Expert Comment

by:Yurich
ID: 18026778
Hello there,
To my understanding, IIS is not on WinXp Pro CD. It's a part of SP2 if I remember correct. BUT you still need WinXP Install CD as while installing, it will request to update some of your system files and for this you need your WinXP CD.

That's the link for SP2:

http://www.microsoft.com/windowsxp/sp2/default.mspx

BE AWARE THOUGH!! SP2 is vey big even for broadband - it's over 600 Megs and it's been issued a lot on CDs, so ask your friends, they may have it.

I can't advise anything about not having WinXP CD - you won't find any legal downloads online, but if you bought machine from a shop, they had to provide you with OEM version of WinPro - some assemblers (they call themselves "manufactures") cheat a lot, selling computers with no disk and selling disk seperately, but you can give a call and either ask for a disk, or at least of some assistance to install IIS.

Good luck,

0
 

Author Comment

by:salesprod
ID: 18029642
Hi Yurich,

Thanks again.

I will be getting the WinXP Pro CD in a couple of days.

In the mean time, having uninstalled the existing Personal Edition, I thought I would go ahead and install Standard Edition. I ran into an error/alert msg whilst doing this:

Microsoft SQL Server 2000 Standard Edition Server Component is not supported on this operating system. Only Client components will be available for installation.

- What would have caused this message to pop up. Is it because I am not running Windows Server on this computer? What are some of the options, if I am not going to get Windows server installed? Can I still use Reporting Services?

At this moment, I'm only trying to get Reporting Services installed so that I can get a feel of whether it is the appropriate solution for my current needs. What are you suggestions?

Thanks!
0
 
LVL 21

Expert Comment

by:Yurich
ID: 18031529
hmm... you actually need to install server components, not just client components. it's been a long time since I installed sql server on my machines - but somehow I remember seeing this message somewhere. are you sure you have win xp pro installed, not home? i have a feeling that i've seen this message when i tried to install sql server on my son's machine it's got win xp home... please confirm that you have win xp pro installed.

regs,
yurich
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question