need help for unattended installation for MS SQL Server 2005 SP2

  • Hi all,

    I have done unattended installation for MS SQL Server 2005 with the help of a script.

    But it did not install SP2. Can anyone tell me how to install that through the command prompt ?

    Thanks in advance,

    Rushabh

    DBA

  • Check the "Installing SQL Server" on BOL.

    Link: http://msdn.microsoft.com/en-us/library/ms143516.aspx

  • hi kishore,

    that was a great help for many other queries regarding the installation.

    but could not find anything related to sp2 installation..

    can you give some other document or give me the script to do that..

    i tried start /wait setupsp2.exe /quiet but it is asking me to press the next button..

    i want it to be done automatically.. because i have to install many servers.

    Thanks in advance,

    Rushabh

    DBA

  • Try and 'SLIPSTREAM' the SP2 installation file on to the SQL installation files. This will create new installation files for SQL with SP2 included.

    There are many websites providing a step-by-step on slipstreaming installations (most for Windows XP with SP2) but the approach is alike. Just google on "slipstream" and "sp2".

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • SQL 2005 SP2 is available online at

    http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en.

    I have installed it quietly with these flags

    SQLServer2005SP2-KB921896-x86-ENU.exe /instancename=MyInst /quiet /sapwd=MyPwd

  • The link in my previous post in turn offers a link for "setup documentation," which is a help file (.chm) that includes detailed documentation for installing from a command prompt.

  • hi dc,

    that was of great help..

    thanks a lot for this..

    Rushabh

    DBA

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

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