Installing(Adding) feature(SSRS) to an existing SQL Installation!

In this post, let’s see how one can add a new feature to your existing SQL Installation. I’ve chosen SSRS(Single Server Deployment, not scaled out) to be Installed on my machine. This Server already has DB Engine and SSIS Installed on it. Please do not do the same on your Production environment unless you clearly understand all the odds of doing the same on an already busy SQL Server.(This is for my Lab purposes) Below Screenshot shows the current status at a very high level of my Server which I’m going to Install SSRS on.

Insert your SQL Server 2008 Media and DC setup.exe, Now navigate to Installation tab and click on 1st link(New Standalone Installation or add features to an existing Installation…) as shown below.

Support Rules/Run check will be kicked off automatically by Installation Wizard. Fix any Errors/Warnings and click on “OK”. The next phase will be installing “Setup Support Files” by SQL Server Installation wizard. This might take couple of minutes.

Now, make sure to select Add features instead of “New Installation” as shown below.

Select SSRS in features(see below) and click Next.

Now, select your Service account(I’ve chosen Network Service) as shown below and click Next.

Now, the Interesting part of SSRS Installation process pops up.(See below Screenshot for available Options we’ve)

Since I’m installing on a machine which already has SQL Server Instance(In other words, adding feature to existing Named Installation of my SQL Server) Option 1 is greyed out for me. Also, Since I don’t have MOSS, Option 2 is greyed Out. So, at this point Report Server S/W will be Installed, but we’ve to manually configure SSRS by navigating to SSRS Config Manager.

After couple of mins, I was greeted with the below Screen 🙂

So, are we done with Configuring SSRS? Nope! Not yet. We are just done with the Installation, not the configuration. For configuring SSRS Service, you’ve to go to Reporting Services Configuration manager under your Configuration tools.

Once Web Service URL has been setup, navigate to Database tab, select on Change Database Button. This is the place where you can select the Database(s) aka Report Catalogs names and select your Instance and respective credentials. I’m going to select SREEDR Instance.  At this moment, there are no databases on this Instance and no SSRS related Logins!

Step1: select Create a New RS Database(Since, this is my first Installation).

Step2: Select your SQL Server(For Named Instance, you’ve to specify ServerName\SQLInstance)

Step3: Enter your preferred DB Name and your Mode.(I left it to default)

Step4: Enter Credentials how SSRS Service will communicate with your Backend Databases. Since both my SSRS and DB Service are running on a same box, I can leave it to default(Service Credentials). Any ways, I’ve a domain account(It can also be a SQL Server Login) which I can use, for this purpose.

Once everything goes Green, You should see the Databases being Created on the Selected Instance and also the Login will be created automatically with the required Permissions as well, which is awesome:)

Now, go to report Manager URL and click Apply! That’s it… Now your Basic SSRS is all setup and configured. As you can see now, I can open my Report Manager URL!

Tada…Yes, it’s that Simple 🙂

Snapshots in Report History/ ReportServer Database Growing Big!

This is going to be a small blog post, where I’ll be showing how can you control the size of your ReportServer Database. Most of the times I’ve seen Report Server Administrators ignoring a very useful setting and screaming – “Not sure why Report Server Catalog is growing out of control in size!!…”

There’s a setting called “Number of Snapshots in Report History” which by default will be “Unlimited“.

What are these Snapshots in Report History? These are nothing but read only view of your Reports at that particular point of time when the report was stored in history – Very similar to Database Snapshots. Whatever changes you make to your report after the time where snapshot was taken will not be applied to your snapshots.

So where do these Snapshots get stored?? In your ReportServer Database!

Where can i Change this Setting?

In your Report Manager or from SSMS(connecting to to your SSRS Server).

From Report Manager:

You can change your Site Settings(Global) – applies to all the Reports or You can override this site level setting at individual Report level as well. Please see the screenshot below.

From SSMS:

Connect to your SSRS Instance and Right click on the Instance and navigate to Properties. Choose History Tab as shown below and you can change these settings at Site Level.

Hope this helps and if you are not aware of this setting and i strongly recommend you to look into this option. In fact you can create a Job which removes Snapshots from your Report Catalog based on number of days you’ve defined. I’ve seen many companies using 60-90 days. Your requirement may vary!