Post reply

Installing SSIS, SSRS and SSAS

  • August 17, 2009 at 11:16 am

    #134870

    Hi,

    Our company has Site A and Site B. Each site has a Development and Production Environments with a bunch of SQL Server 2005 instances in each of these environments.

    Now could anyone tell me how many SSIS, SSRS and SSAS servers have to build for these environments i.e., Is it better to make

    1. One installation of SSIS, SSRS and SSAS per SQL Server Instance irrespective of the environments

    OR

    2. Create ONE SSIS, SSRS and SSAS server per environment i.e. SITE A DEV, SITE A PRD, SITE B DEV, SITE B PRD environments

    OR

    3. Create ONE SSIS, SSRS and SSAS server per site i.e. One per SITE A and One per SITE B

    Thank You,

    Yours,

    SQLBuddy

  • August 17, 2009 at 1:49 pm

    #1040455

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic772119-147-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 17, 2009 at 2:09 pm

    #1040479

    Sorry for the inconvinience!

    I did so because I was desperate for an advise

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply