Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Reporting Services: Personal Edition/Standard Edition?

Posted on 2006-11-27
5
Medium Priority
?
311 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
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Screencast - Getting to Know the Pipeline
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

927 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