Automated SQL Server Installation

  • I have to install SQL Server over 20 boxes. I am considering the option of automated SQL Server Installation.

    Could anyone let me know  issues which I should take care while preparing the automated SQL Server Installation?

     

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • 20 isn't that many. You might spend more time figuring this out than just installing.

  • Actually, setting up an automated install isn't that bad. I did it a couple of years ago for about 15 servers. There is an article in BOL that tells how to do it: Performing an Unattended Install. Basically you use the installation wizard to create the ISS file. Then run the command setupsql.exe with a parameter pointing to your file. You can also automate the service pack installation.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • Steve,

    What would you like to say by your comments?

    It does not make any sense for me.

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • Basically it means that you install 1 server with the cd. Somewhere in the install you'll have an option to save the install to a script. Once the install is complete, you can use that script to install all 19 other instanses.

  •  I know some people that manage 200+ servers, for them 20 is small-ish

     

     


    * Noel

  • The only issues that I am aware of are covered in the following link:

    http://www.microsoft.com/downloads/details.aspx?familyid=9814AE9D-BD44-40C5-ADD3-B8C99618E68D&displaylang=en

    I am also assuming that you are installing SP3 in an automated fashion as well.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 7 posts - 1 through 7 (of 7 total)

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