dsccommunity / dsccommunity/SqlServerDsc
SqlSetup: Feature request - integrated RServer
Nobody has claimed this yet.
- 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
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- 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