dsccommunity / dsccommunity/SqlServerDsc

Cannot install Reporting Services on Windows 2012 Server R2 Core

Open
#512 9 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:

After trying to install Windows 2016 Reporting Services on Windows Core Server the following message is received. Using the exact same configuring on a Windows GUI Server, SSRS installs perfectly. I'm hoping it's something simple in the resource that can be adjusted but it may just be that Microsoft doesn't support SSRS on Windows Core Servers. If that's the case, maybe the README.md can be updated to reflect this (I would love to do my first PR).

VERBOSE: [LABSERVER01]: LCM:  [ Start  Resource ]  [[xSQLServerSetup]SQLServerSetup]
VERBOSE: [LABSERVER01]: LCM:  [ Start  Test     ]  [[xSQLServerSetup]SQLServerSetup]
VERBOSE: [LABSERVER01]:                            [[xSQLServerSetup]SQLServerSetup] 2017-04-19_13-56-45: Using path: \\labfs01.lab.corp\SQLServer2016Developer$\setup.exe
VERBOSE: [LABSERVER01]:                            [[xSQLServerSetup]SQLServerSetup] 2017-04-19_13-56-45: Features found: ''
VERBOSE: [LABSERVER01]: LCM:  [ End    Test     ]  [[xSQLServerSetup]SQLServerSetup]  in 0.5940 seconds.
VERBOSE: [LABSERVER01]: LCM:  [ Start  Set      ]  [[xSQLServerSetup]SQLServerSetup]
VERBOSE: [LABSERVER01]:                            [[xSQLServerSetup]SQLServerSetup] 2017-04-19_13-56-45: Using path: \\labfs01.lab.corp\SQLServer2016Developer$\setup.exe
VERBOSE: [LABSERVER01]:                            [[xSQLServerSetup]SQLServerSetup] 2017-04-19_13-56-45: Using path: \\labfs01.lab.corp\SQLServer2016Developer$\setup.exe
VERBOSE: [LABSERVER01]:                            [[xSQLServerSetup]SQLServerSetup] 2017-04-19_13-56-45: Starting setup using arguments: /ACTION="Install" /INSTANCEDIR="C:\Program Files\Microsoft SQL Server" /IACCEPTSQLSERVERLICENSETERMS="True" /RSSVCPA
SSWORD="********" /RSSVCACCOUNT="LAB\sqlserviceaccount" /INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server" /QUIET="True" /INSTANCENAME="MSSQLSERVER" /FEATURES=RS /INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
VERBOSE: [LABSERVER01]:                            [[xSQLServerSetup]SQLServerSetup] 2017-04-19_13-56-46: Process matching path '\\labfs01.lab.corp\SQLServer2016Developer$\setup.exe' started in process ID 3032
VERBOSE: [LABSERVER01]:                            [[xSQLServerSetup]SQLServerSetup] 2017-04-19_13-59-32: Using path: \\labfs01.lab.corp\SQLServer2016Developer$\setup.exe
VERBOSE: [LABSERVER01]:                            [[xSQLServerSetup]SQLServerSetup] 2017-04-19_13-59-32: Features found: ''
VERBOSE: [LABSERVER01]: LCM:  [ End    Set      ]  [[xSQLServerSetup]SQLServerSetup]  in 166.9560 seconds.
Invoke-CimMethod : PowerShell DSC resource MSFT_xSQLServerSetup  failed to execute Set-TargetResource functionality with error message: Test-TargetResource returned false after calling set. 
At C:\LabDSC\SQLSSRS.ps1:20 char:5
+     Invoke-CimMethod -CimSession $ServerName -Name PerformRequiredCon ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Invoke-CimMethod], CimException
    + FullyQualifiedErrorId : ProviderOperationExecutionFailure,Microsoft.Management.Infrastructure.CimCmdlets.InvokeCimMethodCommand
    + PSComputerName        : LABSERVER01
 
VERBOSE: [LABSERVER01]:                            [] Consistency check completed.
Invoke-CimMethod : One or more partial configurations failed to apply. No configuration could be created. 
At C:\LabDSC\SQLSSRS.ps1:20 char:5
+     Invoke-CimMethod -CimSession $ServerName -Name PerformRequiredCon ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (root/Microsoft/...gurationManager:String) [Invoke-CimMethod], CimException
    + FullyQualifiedErrorId : MI RESULT 6,Microsoft.Management.Infrastructure.CimCmdlets.InvokeCimMethodCommand
    + PSComputerName        : LABSERVER01

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

xSQLServerSetup SQLServerSetup
{
    PsDscRunAsCredential = $Credential            
    SourcePath           = $Node.SQLSourcePath
    SetupCredential      = $Credential
    InstanceName         = $Node.SQLInstanceName
    Features             = 'RS'
    SQLSysAdminAccounts  = $Node.SQLSysAdminAccounts            
    InstallSharedDir     = 'C:\Program Files\Microsoft SQL Server'
    InstallSharedWOWDir  = 'C:\Program Files (x86)\Microsoft SQL Server'
    InstanceDir          = 'C:\Program Files\Microsoft SQL Server'
    SQLSvcAccount        = $Credential
    RSSvcAccount         = $Credential
    ForceReboot          = $True   
}

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

Server: Windows 2012 R2 (Update)
SQL Server: 2016 SP1 CU2
Powershell: 5.1

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

dev as of today

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 by reviewing the xSQLServerSetup resource and README.md, then reproduce the reported SSRS installation on Windows Server 2012 R2 Core using the configuration and verbose output in the issue. Determine whether the failure is resource-related or an unsupported platform; done means either the installation works or the support limitation is documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
powershell
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.