search

sous-chefs / sql_server

Development repository for the sql_server cookbook
https://supermarket.chef.io/cookbooks/sql_server
Apache License 2.0
63 stars 124 forks source link

X86 = False in _ConfigurationFile.ini.erb is not supported by SQL 2022 version due to which installation is getting failed. #194

Closed bhavya5491 closed 11 months ago

bhavya5491 commented 1 year ago

:speaking_head: Foreword

Thank for taking the time to fill this bug report fully. Without it we may not be able to fix the bug, and the issue may be closed without resolution.

:ghost: Brief Description

X86 = False in _ConfigurationFile.ini.erb is not supported by SQL 2022 version due to which installation is getting failed.

:pancakes: Cookbook version

'7.1.13'

:woman_cook: Chef-Infra Version

17

:tophat: Platform details

Windows 2022 VM

Steps To Reproduce

Steps to reproduce the behavior:

Install SQL 2022 using install resource. (Though I know currently 2022 is not supported by by using resource requirement can be met)

:police_car: Expected behavior

I expected SQL 2022 to be installed on Win 2022 VM but below error is being experienced: Exit message:                  The setting 'X86' specified is not recognized.

:heavy_plus_sign: Additional context

Overall summary:   Final result:                  Failed: see details below   Exit code (Decimal):           -2068578301   Exit facility code:            1204   Exit error code:               3   Exit message:                  The setting 'X86' specified is not recognized.   Start time:                    2023-03-30 00:13:32   End time:                      2023-03-30 00:13:33   Requested action:              Install

 

Machine Properties:   Machine name:                  XXXXXXXX   Machine processor count:       2   OS version:                    Microsoft Windows Server 2022 Standard (10.0.20348)   OS service pack:                  OS region:                     United States   OS language:                   English (United States)   OS architecture:               x64   Process architecture:          64 Bit   OS clustered:                  No

 

Package properties:   Description:                   Microsoft SQL Server 2022    ProductName:                   SQL Server 2022

bhavya5491 commented 1 year ago

@damacus, I saw your approval on one of the PRs related to SQL 2022 support but in that also I don't see if X86=False line is being commented out. This line is causing SQL 2022 to fail.

@kitchen-porter It is very urgent issue for us as we have committed to provide SQL 2022 to the customers and we already are delivering versions 2016 and version 2019 using this Cookbook to them.

damacus commented 1 year ago

@bhavya5491 if you have time feel free to submit a PR to correct this 👍🏼

bhavya5491 commented 1 year ago

@damacus New PR has been created:

https://github.com/sous-chefs/sql_server/pull/195

What would it take to be reviewed and if good then release asap please? As it is the top priority work for our org

damacus commented 11 months ago

Closed via #195