Tag Archives: reporting service

How to Rename Your existing Report Server Database

Have you ever faced in a scenario where you are required to rename existing database. While dealing with one my client I have installed reporting server and during RS configuration I’ve chosen the default settings while creating the database so it created the reporting server dbname as ReportServer and ReportServerTempdb and RS working fine. Continue reading How to Rename Your existing Report Server Database

Download Export RDL files from Report Server

Few days back I was working with one of my colleague with reporting service. I dont have much exposure to RS however its a simple task, he asked me to download a RDL file from the report server, we are using RS2005 and couldnt find download or export button which is supposed to be in different name. In this article we are just going to see how to download or export the RDL from your reporting server.

Continue reading Download Export RDL files from Report Server

Configuring SQL Server Reporting Services

In my previous article we have covered installing reporting service. The next step in reporting service is to configure them according to your environment.

There are many options are available in reporting service configuration. You need to configure all these values with respect to your environment. There are two ways to configure reporting service a.) Using Reporting service configuration GUI and b.) Reporting service configuration command line utility (RSConfig.exe located @ C:Program FilesMicrosoft SQL Server90ToolsBinn directory). The reporting service GUI configuration tool is very simple to use and many prefer this. Lets configure reporting service using this GUI too.

Continue reading Configuring SQL Server Reporting Services