I need to set up a report server in SQL Server for SSRS.  How do I do that?

Posted on 2014-08-15
Last Modified: 2014-11-13
I need to set up a report server in SQL Server for SSRS.  How do I do that?  I am running the SQL Server 2000 express and have the SQL Server Data Tools 2012 on my computer too.
Question by:vbnetcoder
    LVL 37

    Expert Comment

    As you're running SQL 2000 Express I assume you're looking for a free version of the SSRS server?  Perhaps you can look into SQL Server 2014 Express Edition with Advanced Services.  It doesn't support all SSRS features but it does have the server and designer parts.

    More details on what it supports: Features Supported by the Editions of SQL Server 2014

    The download is available here:

    Author Comment

    I have SQL Server 2012 express
    LVL 37

    Accepted Solution

    There a similar "with advanced services" version of SQL Server 2012 Express as well: Features Supported by the Editions of SQL Server 2012

    You can download it from here:

    It's the 1.3GB file that you'd be interested in downloading...

    Author Comment

    I downloaded it.  When i open sql server data tools i get the following error:

    "Operation is not valid due to the current state of the object"

    Author Comment

    When I am in SQL server managment studio and try to connect to a reporting services database there isn't anything there under server name that i can connect to.

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now