Post reply

What are the Visual Studio and ASP Licensing Requirements to use Reporting Services?

  • October 25, 2005 at 1:35 pm

    #165767

    hi all,

    This question is for SQL Server 2000 Standard running on Windows 2000 Server Standard:

    I've been asked to look into what the requirements would be to use Reporting Services.

    About all I know is that IIS must be running on the server where Reporting Services is installed. Lets assume for now that RS will be installed on our SQL Server server.

    So my questions are:

    1. Is IIS free$ ?

    2. As for the development tools... do I need Visual Studio.net 2003 ? Do I need to purchase a VS.net 2003 license for the server - or just a license for each developer? Will Visual Basic.net suffice (that's all we use - no C#, J#)

    3. How does ASP.net figure into this - is ASP.net part of Visual Studio.net 2003 ?

    I'm hoping that someone who is using Reporting Services can reply back.

    Thank You. John

  • October 25, 2005 at 10:37 pm

    #600004

    1. IIS is free (well, it's part of Windows 2000 Server). Just go to add/remove programs, and then Windows Components.

    2. Not sure on this, but I believe that it may be possible - something from report services (SDK? Developer Edition?) might need to be installed to get the designer integrated into VS. But, I just don't know. However, a license for Visual Studio is NOT needed for the server.

    3. ASP.NET is part of the .NET Framework (the SDK of which is installed with Visual Studio .NET 2003). Installing the .NET Framework on the Windows 2000 Server (AFTER IIS IS INSTALLED) will "configure" your IIS Server for ASP.NET. If the .NET Framework is on the server already, you can run "aspnet_regiis" to configure websites for ASP.NET.

    Hope this helps you (even a little!)

  • October 26, 2005 at 12:01 am

    #600014

    Save your money for 2005, most of the 2003 tools are all but dead. 2005 should be shipping in a couple of weeks...

    As others have shown, install IIS 5 from Windows 2000 CD and from XP CD for development, download .NET Framework v1.1 sp1, and don't forget to apply Patches.

    For Web site development, try Web Matrix:

    http://www.asp.net/webmatrix/download.aspx?tabindex=4

    Also a free download, and way easier to get results, limited I will admit, as compaired to VS 2003.

    Andy

     

  • October 26, 2005 at 12:25 am

    #600018

    I wouldn't say that the 2003 tools are "all but dead". There is a ton of stuff out there that's built on .NET 1.1, and you aren't going to be maintaining that code in VS 2005 (unless you want to migrate the whole project - not practical in all cases).

    Add to this the uptake of .NET 2.0. There will be plenty of companies out there that will wait a while before upgrading to 2.0.

    However, if you are starting out, then VS 2005 is the way to go.

  • October 26, 2005 at 10:58 am

    #600305

    Brendan and David, thanks very much for taking the time to help this DBA out.

    OK, I need to make sure I'm making the correct assumptions:

    (We don't even have any Visual Studio.NET edition but if VS 2003 is less expensive than VS 2005, this company will go with VS 2003, I'm sure.)

    1. By installing Visual Studio.NET 2003 on the Reporting Services server, that will also include .NET 1.1 Framework  AND  ASP.NET - correct ?

    2. If we only purchase Visual Basic.NET 2003 Standard ($100 U.S.), and not the full Visual Studio product ($700), will that include the .NET 1.1 Framework and ASP.NET ?

    3. Which of these components must be installed on each developer's PC ?

    I apologize if any of these questions seem "dense", but hey I'm a DBA

    Thanks. John

     

       

     

     

  • October 26, 2005 at 4:30 pm

    #600421

    No probs.

    1. The .NET Framework 1.1 (which really includes ASP.NET) is a free download from Microsoft. In fact, both the runtime and the SDK are free (it's the IDE that costs).

    2. Whatever version of Visual Studio you buy will come with .NET.

    3. The developer will just need Visual Studio, with the possibility of the SQL Server Developer Edition, along with Reporting Services - I think it is needed, as it installs the designers which are integrated with Visual Studio (I may be wrong on this one, so you should double check!).

    Instead of Visual Basic .NET 2003, check out the Express Editions of Visual Studio 2005. They'll be much cheaper, and possibly have more features. The only thing is that they'll be .NET 2.0.

    If you have any other questions, let us know.

    Cheers,

    Brendan.

  • October 31, 2005 at 10:14 am

    #601364

    Thanks Brendan.

    "Instead of Visual Basic .NET 2003, check out the Express Editions of Visual Studio 2005. They'll be much cheaper, and possibly have more features. The only thing is that they'll be .NET 2.0."

    I agree - but I don't think we're ready for 2005 yet. We're testing .NET 2.0 but sure about it yet.

    Does anyone know if I only purchase Visual Basic.NET 2003, will that include the IDE that is required to create Reporting Services reports?

    Thanks to everyone !

    John

     

     

     

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply