Upgrade SQL 2012 SP1 express to SP4 express from command prompt fails

Rathod, Shashi 21

Hi,

We have a project which requires 1500 machines to be upgraded to SQL 2017 from SQL 2012 SP1, for we which we have chosen 2 step upgrade i.e. 2012 SP1 - 2012 SP4 - 2017.

Currently we are trying to finalize on the silent commands which can be used to Upgrade SQL 2012 SP1 to SP4 and then to SQL 2017.

While trying to upgrade 2012 SP1 to SP4 i could observe that the EXE does not respond when executed from command prompt (run as administrator) but works fine when EXE is executed directly with Run As Administrator.

SQL Error Log inside temp folder ends with: Setup closed with exit code: 0x84C40013
Setup Bootstrap Log file only generates Global Rules file which shows result as: Passed

I have tried to execute with & without silent commands but the result is same.

Kindly revert if anyone have faced/solved such scenario.

2 answers

YufeiShao-msft 7,131 Reputation points

2021-09-22T03:13:44.027+00:00

Hi @Rathod, Shashi ,

Please check your error log for more information.
The error may be related to the .NET framework. .NET 4.0 is a requirement for SQL Server 2012, but .NET framework is not included in the SQL Server Express media, before you install, please check your .NET framework and install.
Someone is having the sane problem as you because the command is not written correctly, please check that your command. Like using the /Q or /QS must include the /IACCEPTSQLSERVERLICENSETERMS parameter.
https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15
Please sign in to rate this answer.
Rathod, Shashi 21 Reputation points

2021-09-22T08:33:46.097+00:00

Hey,

Thanks for responding.

When i try to install through Wizard either by

EXE with Run as Administrator or

EXE from command prompt with Run as Administrator using /UIMODE=Normal
SQL 2012 SP1 Express is upgraded to 2012 SP4 Express as expected, that confirms that all prerequisites are in place.

From the SqlSetup.log file i got following message,
Workflow COMPONENTUPDATE returned exit code: 0xC0000005
after which all entries were removed (refer attached file)134264-sqlsetup.log

Also, while upgrading SQL 2012 SP1 Express to 2012 SP4 Express, the ACTION should be INSTALL/UPGRADE/PATCH?

YufeiShao-msft 7,131 Reputation points

2021-09-22T09:26:50.453+00:00

from your log, only .Net version 3.5 and Net version 2.0 are installed, but SQL Server 2012 need .NET 3.5 SP1 or .NET 4.0
The Service Pack 4: https://www.microsoft.com/en-us/download/details.aspx?id=56042, you can download and install it directly.

and what does as expected mean?

Rathod, Shashi 21 Reputation points

2021-09-22T09:33:19.057+00:00

As expected means SQL 2012 SP1 express was upgraded to SQL 2012 SP4 express.

Please refer attached log file,134259-summary-in-rt-ut2300-99-20210920-192558.txt

This was generated when EXE was executed with Run as Administrator.

Rathod, Shashi 21 Reputation points

2021-09-22T09:41:19.937+00:00

Silent Command used to upgrade SQL 2012 SP1 express to SQL 2012 SP4 express,

SQLEXPR_x64_ENU.exe /QS /Action=Install /IACCEPTSQLSERVERLICENSETERMS /Features=SQLEngine,BC,Conn,SSMS,SDK /INDICATEPROGRESS /InstanceName=MSSQLSERVER /SECURITYMODE=SQL /SAPWD=***** /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /SQLSVCACCOUNT="NT AUTHORITY\System" /SQLSYSADMINACCOUNTS="Builtin\Administrators" /TCPENABLED=1 /NPENABLED=1 /FILESTREAMLEVEL=1

This command works while Installing SQL 2012 SP1 express.

I am not sure if "/Action=Install" is correct while upgrading SQL 2012 SP1 express to SQL 2012 SP4 express

Rathod, Shashi 21 Reputation points

2021-09-22T09:59:04.383+00:00

.Net Framework 3.5 SP 1 is installed.

YufeiShao-msft 7,131 Reputation points

2021-09-23T01:56:30.683+00:00

you can try to do silent installs of service packs to using the following syntax:

.\<SQLServicePack>.exe /q /action=patch /instancename="name" /IAcceptSQLServerLicenseTerms
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Rathod, Shashi 21 Reputation points

2021-09-24T08:52:11.75+00:00

Hi

I have tried following command,
"%~dp0SQLEXPR_x64_ENU.EXE" /Q /IACCEPTSQLSERVERLICENSETERMS /Action=Patch /INSTANCENAME=MSSQLSERVER /SkipInstallerRunCheck /SkipRules=AclPermissionsFacet

/SkipInstallerRunCheck: Required for SQL 2012 SP2 and later & SQL 2014
/SkipRules=AclPermissionsFacet: Rule was throwing error

which was successful first time but later when i tried on another machine i could see below attached error,

Error Info:
Inner exception type: System.IO.DirectoryNotFoundException
Message: Could not find a part of the path 'C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20210924_140805**MSSQLSERVER**\Datastore'.

The bold part in missing from the log folder (refer attached image).
Please sign in to rate this answer.
YufeiShao-msft 7,131 Reputation points

2021-09-24T09:11:58.46+00:00

There can be one of the two cause for this error:
Path is not correct, please check if path is correct
Restricted user access, you may not have enough permissions

Rathod, Shashi 21 Reputation points

2021-09-24T11:19:10.953+00:00

Path is prepared by SQL itself.

If user access was the concern then SQL would not upgrade when i tey to right click and run the EXE as Administrator.

YufeiShao-msft 7,131 Reputation points

2021-09-27T01:39:08.49+00:00

Your exception error message contains only file or directory names instead of fully qualified paths, then it is possible that your code does not have PathDiscovery permissions.

Rathod, Shashi 21 Reputation points

2021-09-29T08:03:26.56+00:00

Sorry could not reply as i was on leave:)

I am trying to install via a bat file which has silent commands, currently not using any code for testing purpose.

Once we are sure if bat file is upgrading the patch as expected then we would be adding the logic in the Installshield Package which would act as a Wrapper MSI to do multiple activities.

fyi, when i try to install through SQL wizard it works fine but running through silent commands throws this issue.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Upgrade SQL 2012 SP1 express to SP4 express from command prompt fails

2 answers

Your answer