July 12, 2013 at 9:42 am
Correct me if I'm wrong but it's not possible to have to instance of Reporting Service under one SQL instance. I know you can create serveral Reporting Service databases. If I have a SQL instance name ACCT-Test which is running Reporting Service (Report Server & Report ServiceTempDB) and want to compare my ACCT-DEV reports.
July 12, 2013 at 11:30 am
you have have mutliple instances of reporting services, but I don't believe that means on one database engine.
http://msdn.microsoft.com/en-us/library/ms403426(v=sql.90).aspx
July 14, 2013 at 9:49 pm
A single SQL Server instance can be used for multiple reporting services instances. The reporting services database (ReportServer, ReportServerTEMPDB) will include the reporting services instance name.
e.g. I have a reporting services instance "SQL2008R2". The 2 databases for this are called "ReportServer$SQL2008R2" and ReportServer$SQL2008R2Tempdb".
July 15, 2013 at 12:34 pm
SSCrazy,
Is is it possible to have one set of reports going into your ReportServer database and another set of reports going to a different database, if you have one Reporting Service instance?
July 15, 2013 at 9:51 pm
In a single instance of reporting services, there is one and only one ReportServer database and one ReportServerTempDB database.
The reports definitions are stored in the ReportServer database.
The data source(s) for reports in an instance of reporting services can access any database on any instance (subject to security etc). These data sources can be in any instance of SQL Server or OLEDB source.
July 16, 2013 at 2:13 pm
Runnning under Sharepoint Integrated mode, I thought it is possible to have two instance of SSRS (2008) running under the same database server But I guess it's not. I would like to have DBServerA with one instance of Reporting Service used for Test and another instance of Reporting Srevice2 used for development. But it seem like I have to have DBServerA with the SSRS running for test And DBServerA\Dev (another instance of SQL Server) running Reporting Service for the second instance which is for Development. Is that correct?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply