Error while using AWSEC2-CloneInstanceAndUpgradeSQLServer

0

How could the following error be resolved when upgrading SQL Server on EC2 from 2017 to 2019 using AWSEC2-CloneInstanceAndUpgradeSQLServer "Status": "Failed", "ResponseCode":1, "Output": "MSSQLSERVER MSSQL14.MSSQLSERVER?

asked a year ago254 views
1 Answer
0

Please review the following link for upgrade process and be sure about the prerequisite list

https://docs.aws.amazon.com/systems-manager-automation-runbooks/latest/userguide/automation-awsec2-CloneInstanceAndUpgradeSQLServer.html

and please provide more info about the error

profile picture
EXPERT
answered a year ago
  • Thanks for the respond @sdtslmn. I used the exact process you referenced and got the error below, even though I was upgrading from 2017 to 2019 VerificationErrorMessage Command dbe82ae6-e303-4ebb-9af2-de756a745210 returns unexpected invocation result: {Status=[Failed], ResponseCode=[1], Output=[MSSQLSERVER MSSQL14.MSSQLSERVER @{Version=14.0.1000.169; SP=0; SQLPath=c:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL; ProductCode={DED314CA-0EFE-4593-9D66-EF75E5289A4C}; SqlProgramDir=c:\Program Files\Microsoft SQL Server; FeatureList=SQL_Replication_Core_Inst=3 SQL_Engine_Core_Inst=3 SQL_DataFiles_Core_Inst=3 SQL_ENGINE_DB_CNI=3 SQL_Replication_CNI=3 SQL_Replication_FNI=3 SQL_CMDLINETOOLS_CNI=3 SQL_DUMPER_CNI=3 SQL_Engine_CNI=3 SQL_ENGINE_CORE_CNI=3 SQL_LEGACYTOOLS_CNI=3 SQL_SLP_ENGINE_SUPPORT_CNI=3 MPT_AGENT_CORE_CNI=3 MPT_AGENT_CORE_MNGD_CNI=3 SQL_AGENT_FNI=3 SQL_DATA_COLLECTOR_FNI=3 SQL_LEGACYTOOLS_FNI=3 SQL_MAIL_FNI=3 SQL_UPGRADESCRIPTS_FNI=3; PatchLevel=14.0.3023.8; SQLBinRoot=c:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn; Language=1033; checksum=System.Byte[]; ProductID=00394-30000-00000-AB625; DigitalProductID=System.Byte[]; EditionType=Standard Edition; Edition=Standard Edition; SQLGroup=S-1-5-80-3880718306-3832830129-1677859214-2598158968-1052248003; Collation=SQL_Latin1_General_CP1_CI_AS; SQLDataRoot=C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL; AGTGroup=S-1-5-80-344959196-2060754871-2302487193-2804545603-14661074

  • I am getting the same error. Have you found a solution?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions