Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Installation - Create a new report server database Expand / Collapse
Author
Message
Posted Wednesday, March 19, 2014 9:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:12 PM
Points: 8, Visits: 91
I am configuring Reporting Services 2008 R2
and I am following the instructions from my predecessor.

In the SSRS Configuration Manager, I am supposed to Select the "Change Database" and Create a new report server database.

My question is why would I create a new report server database instead of using the one installed during the installation process? I've searched for the advantage NOT using the reportserver and reportservertempdb.

Thanks for information on the advantage of changing the report server database.
Post #1552660
Posted Wednesday, March 19, 2014 9:12 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 927, Visits: 5,900
If you had the wizard configure SSRS for you, you're all set. Are you using thee installation to learn or to work? If it's for work, they may have a configuration script you can use.
Post #1552668
Posted Wednesday, March 19, 2014 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, December 15, 2014 1:12 PM
Points: 8, Visits: 91
I am setting it up for work.
I am creating a new SSRS Server and I plan to replicate the production database to this server and then run reports on this server.

My predecessor DBA set up the original SSRS on the same server as our application database, and in his instructions, he changes the report server database to APPLICATION_ReportServer. What are the advantages of changing the Report Server Database?

Thanks!
Post #1552673
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse