SQL Server Performance

Newbie Implementation

Discussion in 'SQL Server Reporting Services' started by kbachelder, Sep 16, 2004.

  1. kbachelder New Member

    Hi all,

    I am the network admin for our small company and we just recently upgraded from SQL 7.0 to SQL 2000. I am trying to get a handle on what Reporting Services may be able to do. Will I be able to create and run reports with just the Reporting Services software or will I need to purchase additional software like Visual Studio and then learn how to program it?

    Thanks in advance for your help,

    Kevin
  2. Luis Martin Moderator

    It depends on what are your needs.
    I suggest to donwload Microsoft articles about Reporting Services and see if is usefull to you.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  3. kbachelder New Member

    Thanks for the reply Luis.

    I just want to know if Visual Studio or some other programming component is required to create and run Reporting Services reports. In other words do I need to buy and learn an additional product or can I just dig in with Reporting Services in order to do some basic reports.

    Thanks,

    Kevin
  4. Luis Martin Moderator

  5. Akthar New Member

    Hi Kevin,

    according to my informations, to install the report server and the report manager, you need only reporting services, but for report desingning you will require Visual Studio.

    Akthar
  6. Logicalman New Member

    quote:Originally posted by kbachelder

    Thanks for the reply Luis.

    I just want to know if Visual Studio or some other programming component is required to create and run Reporting Services reports. In other words do I need to buy and learn an additional product or can I just dig in with Reporting Services in order to do some basic reports.

    Thanks,

    Kevin

    Kevin,

    You will need a server with SQL installed (SQLRS requires a SQL instance to store it's 2 DBs on) and the server will need to be a web server also. Install RS on this server (client tools not required on this server).
    On a developer machine having VS.NET installed, install the client components of RS.
    You can develop until your hearts content on the development machine, and once you are satisfied with the result you simply deploy it to the Reporting Server.

    Note: For RS you do not require a license if installed on the same box as a licensed version of SQL Server. Licenses are not required for any client tools, as they require a licensed copy of VS.NET to be used (at present).

    Hope this assists,

    Tony

Share This Page