Installing on multiple servers

• Rayven

  SSCarpal Tunnel

  Points: 4337

  More actions

  April 27, 2004 at 5:09 am

  #160856

  Has anyone yet tried installing on one SQL box and two IIS servers, or reinstalling on an IIS server?

  We are in the position where we have an established report server and we are setting up a second IIS server to replace the first.

  When SQLRS installs, it drops and recreates the databases.  We need to install SQLRS on a new IIS box connected to the live databases, and at a later date switch the original box off.

  At a later date we will be building several other IIS servers connecting to the same database, and I can forsee installing SQLRS being a problem here as well.

  We don't have a test bed we can currently use to try this out on, and we don't really want to lose the reports.

  Has anyone had any experience of installing SQLRS and connecting to an existing set of SQLRS databases?

  Any advice would be gateful before we go any further.

  
  ---------------------------------------
  It is by caffeine alone I set my mind in motion.
  It is by the Beans of Java that thoughts acquire speed,
  the hands acquire shaking, the shaking becomes a warning.
  It is by caffeine alone I set my mind in motion.
  

• mphelps

  Mr or Mrs. 500

  Points: 573

  More actions

  April 28, 2004 at 8:37 am

  #504518

  hopefully the following article will be of assistance 

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp