February 1, 2017 at 7:10 am
We have a corporate production server that hosts reportserver databases. We need to install third party application that comes with their own SSRS databases. Can we install that on our corporate server? Report server manager will be configured on a separate web server
ReportServer
ReportServerTempDB
ReportServer_app1
ReportServerTempDB_app1
We are trying to save on licence by hosting reportserver databases on a single server
Thanks
Suezy
February 1, 2017 at 8:01 am
Suezy - Wednesday, February 1, 2017 7:10 AMWe have a corporate production server that hosts reportserver databases. We need to install third party application that comes with their own SSRS databases. Can we install that on our corporate server? Report server manager will be configured on a separate web serverReportServer
ReportServerTempDB
ReportServer_app1
ReportServerTempDB_app1We are trying to save on licence by hosting reportserver databases on a single server
Thanks
Suezy
That depends on what you mean by can it be done. Its not easily done but there are some steps some have used to rename the SSRS databases. This is one of the articles on this:
How to Rename Your existing Report Server Database
But keep in mind is that it is not supported by Microsoft as the databases themselves are considered internal components.
Read the section "Naming Conventions for the Report Server Databases" in Microsoft's documentation:
Administer a Report Server Database
So you are basically on your own if you choose to try to do this.
February 1, 2017 at 8:23 am
Sue_H - Wednesday, February 1, 2017 8:01 AMThat depends on what you mean by can it be done. Its not easily done but there are some steps some have used to rename the SSRS databases. This is one of the articles on this:
How to Rename Your existing Report Server Database
But keep in mind is that it is not supported by Microsoft as the databases themselves are considered internal components.
Read the section "Naming Conventions for the Report Server Databases" in Microsoft's documentation:
Administer a Report Server DatabaseSo you are basically on your own if you choose to try to do this.
The way I read those articles is that changing the database name from the default at installation time is supported, but renaming an existing SSRS database isn't. If I'm right about that, and the third-party application hasn't been installed yet, it should be OK to put the databases all on one server.
John
February 1, 2017 at 8:42 am
John Mitchell-245523 - Wednesday, February 1, 2017 8:23 AMThe way I read those articles is that changing the database name from the default at installation time is supported, but renaming an existing SSRS database isn't. If I'm right about that, and the third-party application hasn't been installed yet, it should be OK to put the databases all on one server.John
Good point - unless the third party app is the one that needs ReportServer and ReportServerTempdb. Guess I was thinking about the rename as well as the naming part of the temp db.
I thought even on install all you could do was create a new name for the ReportServer database only and the temp database would be created with some naming convention to follow for SSRS to work correctly.
Sue
February 1, 2017 at 8:47 am
Sue_H - Wednesday, February 1, 2017 8:42 AMJohn Mitchell-245523 - Wednesday, February 1, 2017 8:23 AMThe way I read those articles is that changing the database name from the default at installation time is supported, but renaming an existing SSRS database isn't. If I'm right about that, and the third-party application hasn't been installed yet, it should be OK to put the databases all on one server.John
Good point - unless the third party app is the one that needs ReportServer and ReportServerTempdb. Guess I was thinking about the rename as well as the naming part of the temp db.
I thought even on install all you could do was create a new name for the ReportServer database only and the temp database would be created with some naming convention to follow for SSRS to work correctly.Sue
I think you can change the name of both databases. Indeed, I seem to recall that if you install SSRS as named instance, the database names default to (something like) ReportServer_INSTANCENAME and ReportServerTempDB_INSTANCENAME.
John
February 1, 2017 at 10:50 am
John Mitchell-245523 - Wednesday, February 1, 2017 8:47 AMI think you can change the name of both databases. Indeed, I seem to recall that if you install SSRS as named instance, the database names default to (something like) ReportServer_INSTANCENAME and ReportServerTempDB_INSTANCENAME.John
That's weird. I was just tried a couple installs and I was unable to name the temp db. I was only given the option to name the ReportServer database. It was the same if I tried to change the database through Report Server Configuration manager.
All of mine were named with TempDB on the end - e.g. <SSRSDBName>TempDB
Sue
February 1, 2017 at 8:37 pm
Even if I can re name my reportserver and reportservertempdb ( http://sql-articles.com/reporting-services/how-to-rename-your-existing-report-server-database/ )
it seems that I can only have one set of Reportserver databases per instance. So it seems that I need to install another SQL instance/Report services to host vendor reports.
Or make vendor use our existing reporting databases for their application.
February 1, 2017 at 9:03 pm
Suezy - Wednesday, February 1, 2017 8:37 PMEven if I can re name my reportserver and reportservertempdb ( http://sql-articles.com/reporting-services/how-to-rename-your-existing-report-server-database/ )
it seems that I can only have one set of Reportserver databases per instance. So it seems that I need to install another SQL instance/Report services to host vendor reports.
Or make vendor use our existing reporting databases for their application.
The point you may want to start from though might be solidifying what the vendor needs first.
Do they have requirements of certain names for the Report Server databases? Do they require default names? Would they be able to use the existing report server? How do they implement the security on the Report Server? Do they have hardware specs, requirements of the Report server? What is the expected volume of reports, how often are they likely to be executed, what kind of resources do they use, etc. Probably try to get a good handle on all of their requirements and go from there.
If they don't have many reports, nothing too weird for security requirements and one that's easy to work into the existing report server and it's not much of a performance hit on the Report Server, it might make more sense to be on the existing one anyway.
Sue
February 2, 2017 at 8:05 am
Thanks Sue. I will get more information from vendor
February 8, 2017 at 9:27 am
you can absolutely have multiple Reportserver databases on a single instance, that's why you get the option to supply a unique name for the Reportserver database instead of just accepting the default
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2017 at 9:58 am
You can certainly have multiple report server databases on the same instance.
I have 3 different report server databases in the same server. Dev, QA, and stage all live in the same instance.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply