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

Posted on 2014-08-15
Medium Priority
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
  • 4
  • 2
LVL 37

Expert Comment

ID: 40267576
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: http://msdn.microsoft.com/en-us/evalcenter/dn434042.aspx

Author Comment

ID: 40279054
I have SQL Server 2012 express
LVL 37

Accepted Solution

ValentinoV earned 2000 total points
ID: 40279226
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: http://www.microsoft.com/en-us/download/details.aspx?id=29062

It's the 1.3GB file that you'd be interested in downloading...
Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.


Author Comment

ID: 40279552
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

ID: 40279559
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

ID: 40441032

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

840 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