SqlServerDsc: Resources work with SqlServer v22.0.49-preview

[johlju]

Pull Request (PR) description

• SqlServerDsc
  • Workaround for missing SMO assemblies in SqlServer that supports SQL Server 2022.

This Pull Request (PR) fixes the following issues

None.

Task list

• [x] Added an entry to the change log under the Unreleased section of the file CHANGELOG.md. Entry should say what was changed and how that affects users (if applicable), and reference the issue being resolved (if applicable).
• [ ] Resource documentation updated in the resource's README.md.
• [ ] Resource parameter descriptions updated in schema.mof.
• [ ] Comment-based help updated, including parameter descriptions.
• [ ] Localization strings updated.
• [ ] Examples updated.
• [ ] Unit tests updated. See DSC Community Testing Guidelines.
• [ ] Integration tests updated (where possible). See DSC Community Testing Guidelines.
• [ ] Code changes adheres to DSC Community Style Guidelines.

---

This change is 

[codecov[bot]]

Codecov Report

Merging #1808 (e830ee7) into main (bed3b12) will increase coverage by 0%. The diff coverage is 100%.

@@         Coverage Diff          @@
##           main   #1808   +/-   ##
====================================
  Coverage    91%     91%           
====================================
  Files        71      71           
  Lines      7272    7303   +31     
====================================
+ Hits       6620    6654   +34     
+ Misses      652     649    -3     

Flag	Coverage Δ
unit	91% <100%> (+<1%)	:arrow_up:

Impacted Files	Coverage Δ
source/DSCResources/DSC_SqlRS/DSC_SqlRS.psm1	99% <100%> (+<1%)	:arrow_up:
...sources/DSC_SqlReplication/DSC_SqlReplication.psm1	65% <100%> (+3%)	:arrow_up:
...urce/DSCResources/DSC_SqlScript/DSC_SqlScript.psm1	96% <100%> (+<1%)	:arrow_up:
...sources/DSC_SqlScriptQuery/DSC_SqlScriptQuery.psm1	96% <100%> (+<1%)	:arrow_up:
...dules/SqlServerDsc.Common/SqlServerDsc.Common.psm1	98% <100%> (+<1%)	:arrow_up:

[johlju]

This attempt to use latest preview version of SqlServer didn't fair well with the integration tests.

[github-actions[bot]]

Labeling this pull request (PR) as abandoned since it has gone 14 days or more since the last update. An abandoned PR can be continued by another contributor. The abandoned label will be removed if work on this PR is taken up again.

[johlju]

This PR now uses dbatools, to see if that works.

[johlju]

Dbatools is missing the assemblies for Analysis Services.

PowerShell DSC resource DSC_SqlSetup  failed to execute Test-TargetResource functionality with error message: System.InvalidOperationException: Failed to connect to Analysis Services instance 'APPVEYOR-VM\DSCMULTI'. 
(SQLCOMMON0021) ---> System.Management.Automation.PSArgumentException: Cannot find type [Microsoft.AnalysisServices.Server]: verify that the assembly containing this type is loaded.
   at System.Management.Automation.MshCommandRuntime.ThrowTerminatingError(ErrorRecord errorRecord)
   --- End of inner exception stack trace --- 
    + CategoryInfo          : InvalidOperation: (root/Microsoft/...gurationManager:String) [], CimException
    + FullyQualifiedErrorId : ProviderOperationExecutionFailure
    + PSComputerName        : localhost

[johlju]

A new preview version of SQL Server was just released, reverting to testing that.

[johlju]

PoC of using SqlServer v22.0.49 is done, all tests pass. There are some breaking changes in v22 that need to be addressed a bit cleaner. Need to add an optional Encrypt parameter to SqlRS, SqlScript and SqlSciptQuery.