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

SSRS Re-Install, Application Re-Install !!!! Expand / Collapse
Author
Message
Posted Friday, May 24, 2013 3:38 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:19 AM
Points: 108, Visits: 449
Hi All,

I have reporting services application running on a server. Due to some reason, this application needs to be reinstalled (Some corruption in .Net Framework assemblies and not able to launch report server url) . SQL Server reporting Services needs to be reinstalled as well.
Now I need some help here on how to go about this?
If I may put in steps my understanding, it is as below.

1) Take the back up of the ReportServer database on some other machine. (for all RDL backups)
2) Install the .NetFramework and reinstall SQl Server 2008 (reporting component only), while doing so report server url is configured.
3) Install ReportServer Database on the machine and get all the reports backup and deploy the same to Report Server.

Is this understanding correct ?

OS - Windows Server 2003,
SQL Server 2008.

Regards,
Athar Iqbal
Post #1456350
Posted Monday, June 3, 2013 4:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 9:16 AM
Points: 9, Visits: 102
When you go to install RS, I'd pick to do it manually, not let the install configure. Then, you'll have the option of walking through each part of the config yourself using the config tool after the install is done. When you get to the database step, you can tell it to use your existing db and not have to create a new one. This would save you having to restore the backup.
Of course, having a backup is a great idea, just in case, and if you do need to restore it, it will bring back any of the security settings you've already configured.
Brenda
Post #1459494
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse