Solved

Reporting Services: Personal Edition/Standard Edition?

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

12 Experts available now in Live!

Get 1:1 Help Now