Enable SSRS My Reports using Express edition

Question

Is there a way to enable the “My Reports” feature in SQL Server Reporting Services 2008 when I am using SQL Server 2008 Express edition with Advanced Services?

As I am using Express edition, I cannot connect SQL Server Management Studio to Reporting Services: -

"SQL Server Management Studio Express cannot be used to administer a report server".

I am using the Report Manager Browser interface for SSRS administration. The option to enable “My Reports” appears not to be in Report Manager for SSRS 2008 so is there another way to enable this option, command line maybe?

Answer 1

I believe you are looking for SQL Server Express Edition with Advanced Services.

Answer 2

This is, honestly, a guess as I don't have SQL 2008 Express to test this on - but it definitely works on SQL 2005 standard.

I think you can configure the property using rs.exe

Create a text file (I'm assuming you'll call it myReportsEnable.rss) and add the following text to it:

Public Overridable Sub Main()
    SetSystemProperties
End Sub

Private Sub SetSystemProperties()

    Dim Properties(0) As Microsoft.SqlServer.ReportingServices2008.[Property]
    Properties(0) = New Microsoft.SqlServer.ReportingServices2008.[Property]
    Properties(0).Name = "EnableMyReports"
    Properties(0).Value = "True"
    RS.SetSystemProperties(Properties)
End Sub

(I'm getting this from SQL2005, so I'm assuming that Microsoft.SqlServer.ReportingServices2008 is the right type to use - apologies if it's not)

Save the file, then execute it from a command line using rs.exe:

rs -i myReportsEnable.rss -s http://~YourServerName~/reportserver

Answer 3

Ed Harper's answer worked for me on an express edition instance of SRSS 2008, but only after I changed the names back to "ReportingServices2005".

I had also tried just changing the value for "enablemyreports" in the ConfigurationInfo table from "false" to "true", but that attempt just gave me an error in Report Manger.

Answer 4

I know this does not entirely answer the question I asked! However, I got around this issue by using SQL Server developer edition for my SQL Server installation used for training etc. Although not free like Express Edition, it is inexpensive.

Using SQL Server developer edition allowed me to enable the "My Reports" feature.