dsccommunity / dsccommunity/SqlServerDsc

SqlSetup: Feature request - integrated RServer

Open
#471 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement help wanted
Dominant language
PowerShell
Stars
385
Forks
224
PR merge metrics
No merged PRs in 30d

Description

Details of the scenario you try and problem that is occurring:
I am trying to install SQL Server database engine with integrated RServer. I am not installing scale out RServer.

When the Features includes AdvancedAnalytics:

  • Get should be modified to look for the service MSSQLLaunchpad or MSSQLLaunchpad$InstanceName
  • Set should throw an error if the version is less than 13
  • Set should add the setup argument IAcceptROpenLicenseTerms as a flag
  • The MRCacheDirectory should be able to be set as a parameter to enable offline installs otherwise SQL Install will automatically try to fetch the ROpen and RServer binaries from the internet. Alternativly if the MRCacheDirectory exists in the binary install path the MRCacheDirectory setup argument could be added.

The DSC configuration that is using the resource (as detailed as possible):

Mostly ommited.

xSQLServerSetup MyInstance
{

SourcePath = "\\FileServer\Software\SQL2016_EC"
ForceReboot = $true
Features = "SQLEngine,Replication,FullText,AdvancedAnalytics" # include RServer
InstanceName = $Node.SQLInstance
InstanceDir = "C:\Program Files\Microsoft SQL Server"

}

Version of the Operating System, SQL Server and PowerShell the DSC Target Node is running:
Windows Server 2016
SQL Server 2016
PowerShell 5.1

Version of the DSC module you're using, or 'dev' if you're using current dev branch:
6.0.0.0

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start with the SqlSetup resource and trace its Get and Set handling when Features includes AdvancedAnalytics. Verify the existing SQL Server version and setup-argument logic, then confirm that integrated RServer detection, version validation, license acceptance, and MRCacheDirectory support meet the requested behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
powershell
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.