Getting started?

Hi,
I'm looking to implement Reporting Services for the first time and have a
couple quiestions, which I hope someone can answer for me. Or database is
SQL Server 2000, currently with sp1. We do have a license for SQL Server
2005 but our business application does not support it yet.
Someone has recommended that we use RS from the SQL 2005 because of it's
better features than the previous version.
Reading the prerequisits for installation I see that SQL Sever 2000 should
be at sp3a, how hard a requisit is this? Can I get by with sp1?
Regarding the report designer, do I really have to have Visual Studio .NET
2003 to use the designer? I don't have it yet so could I get by with Visual
Studio Express?
I guess those are the two biggest questions I have right now.
Thanks in advance,
LinnOn Oct 16, 1:03 pm, "Linn Kubler" <lkub...@.chartwellwisc2.com> wrote:
> Hi,
> I'm looking to implement Reporting Services for the first time and have a
> couple quiestions, which I hope someone can answer for me. Or database is
> SQL Server 2000, currently with sp1. We do have a license for SQL Server
> 2005 but our business application does not support it yet.
> Someone has recommended that we use RS from the SQL 2005 because of it's
> better features than the previous version.
> Reading the prerequisits for installation I see that SQL Sever 2000 should
> be at sp3a, how hard a requisit is this? Can I get by with sp1?
> Regarding the report designer, do I really have to have Visual Studio .NET
> 2003 to use the designer? I don't have it yet so could I get by with Visual
> Studio Express?
> I guess those are the two biggest questions I have right now.
> Thanks in advance,
> Linn
I would suggest upgrading to SP3a, it has added functionality since
SP1 in terms of SQL Server. You might be able to get away w/VS Express
w/Advanced Services temporarily; however, SSRS Express Edition does
not have all the functionality that SSTS Std Edition has (http://
www.microsoft.com/sql/prodinfo/features/compare-features.mspx ). Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1192586314.331811.84030@.e9g2000prf.googlegroups.com...
> On Oct 16, 1:03 pm, "Linn Kubler" <lkub...@.chartwellwisc2.com> wrote:
>> Hi,
>> I'm looking to implement Reporting Services for the first time and have a
>> couple quiestions, which I hope someone can answer for me. Or database
>> is
>> SQL Server 2000, currently with sp1. We do have a license for SQL Server
>> 2005 but our business application does not support it yet.
>> Someone has recommended that we use RS from the SQL 2005 because of it's
>> better features than the previous version.
>> Reading the prerequisits for installation I see that SQL Sever 2000
>> should
>> be at sp3a, how hard a requisit is this? Can I get by with sp1?
>> Regarding the report designer, do I really have to have Visual Studio
>> .NET
>> 2003 to use the designer? I don't have it yet so could I get by with
>> Visual
>> Studio Express?
>> I guess those are the two biggest questions I have right now.
>> Thanks in advance,
>> Linn
>
> I would suggest upgrading to SP3a, it has added functionality since
> SP1 in terms of SQL Server. You might be able to get away w/VS Express
> w/Advanced Services temporarily; however, SSRS Express Edition does
> not have all the functionality that SSTS Std Edition has (http://
> www.microsoft.com/sql/prodinfo/features/compare-features.mspx ). Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Hi Enrique,
Did you mean SSRS Std Edition? Not sure what SSTS is. Assuming that's the
case, I do have SQL Server 2005 Standard Edition, it is the Visual Studio I
don't have currently so was wondering about the free version of that. From
the article you linked it looks like Advanced Services is a component of
Reporting Services out of SQL Server Express Edition.
First hurdle is to install SQL Server 2000 sp3a though.
Thanks for the help,
Linn