Solved

Reporting Services: Personal Edition/Standard Edition?

Posted on 2006-11-27
5
294 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 500 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

705 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now