Post reply

unattended installation of sql sever 2008

  • January 27, 2009 at 3:50 am

    #127594

    Hi all,

    I have to install MS SQL Server 2008 on about 150 remote servers. Since doing this is a tedious task, I was wondering if there is a template script or a document on unattended installation of MS SQL Server 2008.

    Thanks a lot

    Niyala

  • July 28, 2009 at 5:00 pm

    #1031390

    Yes do a single installation with all the settings as u want them then take the ini file that it references and use a script the contains the following command line

    setup.exe /configurationfile="path to ini file referenced above"

    run once to test instatalltion if it is correct modify the ini file to allow silent install

    ; Setup will display progress only without any user interaction.

    QUIETSIMPLE="True"

    This has worked for me for a single instance although getting multiple instances is proving a bit more difficult

    alternating run setup /? and review the guidance for a command line install everything in the configuration file can be set via the command line

  • July 28, 2009 at 9:43 pm

    #1031441

    As well you can use powershell to cycle through the servers and kick off the installs.

    It's quite a lovely sight to see really.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • July 29, 2009 at 5:52 am

    #1031566

    Youi may find SQL FineBuild helpful. You can gt this either by following the link below or direct from CodePlex.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • July 29, 2009 at 6:03 am

    #1031574

    Hi,

    in fact I implemented long ago exactly as are suggesting. It works very well. I even gave the routines to a technician and he is running all the installation.

    Thanks indeed for your reply.

    Niyala

  • July 29, 2009 at 6:05 am

    #1031575

    Hi,

    I soloved this problems long ago. However, trying with PowerShell must a good idea. Do you such examples that you previously applied?

    Thanks indeed for your hints.

    Regards

    Niyala

  • April 2, 2013 at 7:18 am

    #1602784

    If I want to do unattended installation for SQL Server 2008 using configuration.ini with batch

    Setup.exe /ConfigurationFile=MyConfigurationFile.INI

    Certain parameters I want to assign on command prompt. Is it possible.

    If I want to do interactive installation What modification I should do on batch script

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

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