How to Rename Your existing Report Server Database

Written by VidhyaSagar. Posted in Reporting Services

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.

VN:F [1.9.14_1148]
Rating: 3.3/5 (3 votes cast)
VN:F [1.9.14_1148]
Rating: +1 (from 1 vote)

Download Export RDL files from Report Server

Written by VidhyaSagar. Posted in General, Reporting Services

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.

VN:F [1.9.14_1148]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.14_1148]
Rating: 0 (from 0 votes)

Configuring SQL Server Reporting Services

Written by VidhyaSagar. Posted in DBA, 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.

VN:F [1.9.14_1148]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.14_1148]
Rating: 0 (from 0 votes)

Recent Comments

Praveen

|

Hi Sagar, Your script is working great. Thanks ton

DotNetShoutout

|

SQL-Articles » Script to get data file usage and autogrowth details…

Thank you for submitting this cool story – Trackback from DotNetShoutout…

VidhyaSagar

|

Saeed,
I don’t think so you can stop it in SMO, instead you need to turn off password policy for that login

VidhyaSagar

|

Thanks Ashish, I’ve updated the script.