Post reply

SQL Installation from CommandLine

  • July 3, 2017 at 6:14 am

    #322346

    Hello

    I am trying to perform SQL installation from command prompt

    I have created below 3 folders in D:\Patches\

    1)Setup -> contains SQL server 2014 setup file
    2)SP-->Contains Service Pack & Cumulative update(.exe files)
    3)Config-->Configuration.ini file

    Using below command to perform installation:-

    "D:\Patches\Setup\64-Bit\Setup.exe" /q /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /UpdateEnabled=TRUE /UpdateSource="D:\Patches\SP" /SQLSVCPASSWORD="Password1"  /AGTSVCPASSWORD="Password1" /SAPWD="password@123" /ConfigurationFile="D:\Config\ConfigurationFile.ini"

    Installation completed successfully. Service pack also applied,but NOT the cumulative update. Am I missing any additional parameter?

    Thanks in adavance

  • July 3, 2017 at 8:07 am

    #1949148

    An article here.  But from what you've written, I'd expect this to work. I'll have to test and see if this works for me or fails as well. This is SQL 2014, correct?

  • July 3, 2017 at 8:40 am

    #1949167

    Steve Jones - SSC Editor - Monday, July 3, 2017 8:07 AM

    An article here.  But from what you've written, I'd expect this to work. I'll have to test and see if this works for me or fails as well. This is SQL 2014, correct?

    Yes,SQL server 2014. I am trying to apply SP1 CU11 and I could find in logs that, it is a valid patch. But not applied for some reason.

    Slp: Package 'D:\Patches\SP\SQLServer2014-KB3106659-x64.exe' is a valid update.
    Slp: Inspecting update package 'D:\Patches\SP\SQLServer2014SP1-KB3058865-x64-ENU.exe'
    Slp: Workflow to execute: 'OUTERSETUPSTARTUI'

  • July 3, 2017 at 8:48 am

    #1949173

    Strange. You are applying SP1, not SP2? http://www.sqlservercentral.com/articles/SQL+Server+2014/101274/

  • July 3, 2017 at 10:44 am

    #1949203

    Steve Jones - SSC Editor - Monday, July 3, 2017 8:48 AM

    Strange. You are applying SP1, not SP2? http://www.sqlservercentral.com/articles/SQL+Server+2014/101274/

    Was testing cmd line installation with SP1 & CU's. Sometimes we will receive specific Patch level update from application team.Will test it with SP2

  • July 3, 2017 at 1:13 pm

    #1949225

    I was just worried you might have SP2 and CU11 for SP1. Or something similar. Can be confusing with the CUs since there is a CU1 for RTM, SP1, and SP2. Crazy.

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

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy