September 4, 2013 at 2:48 am
Two Questions about reporting services
1) Is it possible to rename the ReportServer database? I have just tried but change it as part of a migration, but then the reporting services was referencing objects within the database with the old database name. I guess all objects would also need to be changed if we were going to do this or is there any easier way?
2) Changing the service account for report services. I have inherited some servers which use Network Service account for reporting services. I prefer using AD accounts for all SQL Services. Where would I need to add this group to to enable reporting services to start up?
September 4, 2013 at 5:01 am
1. You should be able to rename it. I haven't done it myself, but I saw Report databases at a client with different names.
2. You can specify a service account in the Reporting Services Configuration Manager.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2013 at 5:18 am
Renaming a report server database is not supported, you can try it though.
You'll need to find any references to the original name in any procs, functions, views etc in both reportserver and reportservertempdb databases and change them to the new name.
Wouldn't fancy it myself but if there's no other way...
September 4, 2013 at 5:30 am
Done a bit of research: not supported, but possible. In other words, don't unless you really have to.
How to Rename Your existing Report Server Database[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 4, 2013 at 5:40 am
Why do you want to rename the database?
September 4, 2013 at 6:56 am
kevaburg (9/4/2013)
Why do you want to rename the database?
I was doing a migration from one instance which was soley for this application, to an instance which hosted multiple applications. One application already have a reportingServices database on there.
I agree its going to be a lot of work I just didnt know if there would be a quick fix. I will move it to a different instance 🙂
September 4, 2013 at 6:57 am
Koen Verbeeck (9/4/2013)
1. You should be able to rename it. I haven't done it myself, but I saw Report databases at a client with different names.2. You can specify a service account in the Reporting Services Configuration Manager.
On point 2. I know this :-] But what permission\roles does the service account need to have on the OS. I added the account to
SQLServerReportServerUser's group but obviously this wasnt enough.
I didnt want to just apply System admin.
September 4, 2013 at 6:58 am
Is there no way to merge the two reporting services databases so that the names don't have to be changed?
September 4, 2013 at 7:00 am
SQLSteve (9/4/2013)
Koen Verbeeck (9/4/2013)
1. You should be able to rename it. I haven't done it myself, but I saw Report databases at a client with different names.2. You can specify a service account in the Reporting Services Configuration Manager.
On point 2. I know this :-] But what permission\roles does the service account need to have on the OS. I added the account to
SQLServerReportServerUser's group but obviously this wasnt enough.
I didnt want to just apply System admin.
If you did it through the Reportin Services Configuration Tool, permissions should automatically be set.
Configure the Report Server Service Account
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 5, 2013 at 7:35 am
Easily done Via SSRS configuration tools.
If you want to keep the original SSRS dbs for rollback.
1 Backup the dbs with copy.
1a Backup SSRS encryption keys\cert.
2. Restore the dbs as NEW BD NAMES.
2a Restore Cert\keys
3. Use SSRS config tool to point SSRS to the new db.
4. Restart SSRS services.
5. If all working delete original dbs.
Something like that, Not sure if you need to stop SSRS services before step 3. A long time since I did it.
All my test SSRS serveres are running on renamed SSRS databases.
September 5, 2013 at 9:20 am
Talib123 (9/5/2013)
Easily done Via SSRS configuration tools.If you want to keep the original SSRS dbs for rollback.
1 Backup the dbs with copy.
1a Backup SSRS encryption keys\cert.
2. Restore the dbs as NEW BD NAMES.
2a Restore Cert\keys
3. Use SSRS config tool to point SSRS to the new db.
4. Restart SSRS services.
5. If all working delete original dbs.
Something like that, Not sure if you need to stop SSRS services before step 3. A long time since I did it.
All my test SSRS serveres are running on renamed SSRS databases.
perfect ill give it a try.. cheers
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply