MSSQL Media specified in MSSQL Media Bucket is not getting installed because of hardcoded scripts/prepare-fci.ps1#L34

[ar33bm]

Thanks team for the great template.

We have noticed that when we want to specify MS SQL Standard version, by passing as parameters for the right .iso are not working because in the scripts/prepare-fci.ps1#L34 the value for MSSQL .iso is hardcoded. And it is always installing the MSSQL Express version.

[davmayd]

The script in question does not use the hard coded value for SQL ISO. The file name specified is for the ‘target file name’ when copied from S3. When passing the parameter the user need to define the SQL ISO file in S3 which gets copied to local system as ‘en_sql_server_2019_developer_x64_dvd_baea4195.iso'. Essentially, it is just a target file name as has nothing to do what edition of SQL.

[ar33bm]

When we are trying to use our MSSSQL Standard .ISO to be used as MSSQL Installation media as we already have MSSQL license which we want to use, we noticed that the QuickStart is not using the media specified during the stack launch. And in any case it is installing the MSSQL developer for FCI instances. If the script mentioned in the subject is not the cause for it, then please try to replicate the issue by using another MSSQL media (like standard or express or enterprise).