Reporting Services in SQL 2000

I would like to learn/more, practice creating and using reports but I don't know if I can do that on my home laptop with version 2000. I know, I know... upgrade to 2005. Can't do that due to technical difficulties on my other pc. Can I do this with my current setup?

thx

Kat

Yes you can. For SQL 2000, Reporting Services came as an add on component rather that being part of main install package.

You will need to have Windows 2000 or XP Professional which comes with IIS. This is required for running Reporting Services.

|||

here are some links that will be helpful to you:

Download of Reporting Services for SQL Server 2000
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en

Reporting Services for SQL Server 2000 documentation
http://www.microsoft.com/downloads/details.aspx?FamilyID=5e550d73-8f35-435e-bb71-c8573a1cdbdb&DisplayLang=en

White papers and Technical articles about Reporting Services for SQL Server 2000
http://www.microsoft.com/technet/prodtechnol/sql/2000/technologies/rptsvcs.mspx

hope this helps,

Tai Yee
SQL Server

|||

It looks like I can't do this on a standalone pc, but need to have a server that I'm using... frustrating!

Kat

|||

Hi,

Do you have the SQL Server 2000 is installed on your computer? As I remember, Reporting Services needs at least a Standart Edition for SQL2K

If you have SQL Server, then you need the IIS also installed on your pc.

If you want to create reports, you need also the VS.Net 2003 installed on your pc.

I can all run them on my laptop which is an XP SP2. Your machine does not need to be a server :)

Eralper

http://www.kodyaz.com

|||That's right. But I believe you need XP Professional and not XP Home edition because you don't get IIS with XP Home.|||

I only have 2000 Professional Edition. Looks like I'll have to wait for my other laptop to be repaired and then I'll try again.

I HOPE, I HOPE, I HOPE it works!

thx

Kat

|||Windows 2000 Professional should work just fine.|||

Hi,

I should get my xp professional laptop back this next week and I will have the Developer edition of SQL Server 2000 soon to be upgraded to 2005. You say I need IIS installed which I understand, but is VS.Net 2003 a free product or does this have to be paid for?

thx,

Kathleen