search

dsccommunity / SqlServerDsc

This module contains DSC resources for deployment and configuration of Microsoft SQL Server.
MIT License
360 stars 224 forks source link

SqlRSSetup: fails on subsequent runs #1736

Closed jeremiahmoree-adot closed 2 years ago

jeremiahmoree-adot commented 2 years ago

Problem description

I used the example in the documentation to install SSRS using SqlRSSetup. ie. https://www.powershellgallery.com/packages/SqlServerDsc/12.5.0.0/Content/Examples%5CResources%5CSqlRSSetup%5C1-InstallReportingServices.ps1

The first run works but subsequent runs of Start-DSCconfiguration using the same path fail. Given that DSC is supposed to set everything to a desired state shouldn't subsequent runs be possible?

Generally, after about 10 minutes of testing the jobs complete successfully. Is this a problem with the install running in the background and the failures are due to that? If so, how are we supposed to know that and how would we programmatically check that the install is finished if it is going to say Completed before it's really done? Or perhaps the services are not fully started?

The RunAS account is in the local administrators group. also tested without it which is documented to run as SYSTEM. Installed the latest version of sqlserverdsc from psgallery using install-module. Furthermore I tried looking for logs in the %TEMP% location and found none. Also I tried setting LogPath and still could not get logs out of the process. Where are the logs? $debugpreference and $verbosepreference = continue doesn't show any more output anywhere I can see.

I have recreated this problem multiple times by installing and uninstalling SSRS on multiple fresh systems. One of them is never successful but SSRS is installed. Seems that automatic installs of SSRS are wicked hard. Given that critical options such as ssl are not even included in DSC I've been trying to roll my own installer but having trouble with that also. Likely related to encryption key.

Verbose logs

PS C:\InstallMedia> Install-Module -Name SqlServerDsc -Repository PSGallery

NuGet provider is required to continue
PowerShellGet requires NuGet provider version '2.8.5.201' or newer to interact with NuGet-based repositories. The NuGet provider must be available in 'C:\Program
Files\PackageManagement\ProviderAssemblies' or 'C:\Users\jmoree\AppData\Local\PackageManagement\ProviderAssemblies'. You can also install the NuGet provider by running
'Install-PackageProvider -Name NuGet -MinimumVersion 2.8.5.201 -Force'. Do you want PowerShellGet to install and import the NuGet provider now?
[Y] Yes  [N] No  [S] Suspend  [?] Help (default is "Y"):

Untrusted repository
You are installing the modules from an untrusted repository. If you trust this repository, change its InstallationPolicy value by running the Set-PSRepository cmdlet. Are you sure you want
to install the modules from 'PSGallery'?
[Y] Yes  [A] Yes to All  [N] No  [L] No to All  [S] Suspend  [?] Help (default is "N"): A
PS C:\InstallMedia> Configuration Example
{
    [CmdletBinding()]
    param
    (
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [System.Management.Automation.PSCredential]
        $SqlInstallCredential
    )

    Import-DscResource -ModuleName 'SqlServerDsc'

     node localhost
     {
         SqlRSSetup 'InstallDefaultInstance'
         {
             InstanceName         = 'SSRS'
             IAcceptLicenseTerms   = 'Yes'
             SourcePath           = 'C:\InstallMedia\SQLServerReportingServices.exe'
             Edition              = 'Development'

             PsDscRunAsCredential = $SqlInstallCredential
         }
     }
}
PS C:\InstallMedia> new-item -path HKLM:\SOFTWARE\Microsoft\PowerShell\3 -name DSC -Force | out-null
PS C:\InstallMedia> new-itemProperty -path HKLM:\SOFTWARE\Microsoft\PowerShell\3\DSC -name PSDscAllowDomainUser -Value $true -Force | out-null
PS C:\InstallMedia> new-itemProperty -path HKLM:\SOFTWARE\Microsoft\PowerShell\3\DSC -name PSDscAllowPlainTextPassword -Value $true -Force | out-null
PS C:\InstallMedia> Example

cmdlet Example at command pipeline position 1
Supply values for the following parameters:
SqlInstallCredential

    Directory: C:\InstallMedia\Example

Mode                LastWriteTime         Length Name
----                -------------         ------ ----
-a----         1/6/2022  11:27 AM           2424 localhost.mof

PS C:\InstallMedia> $install = Start-DscConfiguration -Path .\Example\ ; $install

Id     Name            PSJobTypeName   State         HasMoreData     Location             Command
--     ----            -------------   -----         -----------     --------             -------
1      Job1            Configuratio... Running       True            localhost            $install = Start-DscCo...
PS C:\InstallMedia> sleep $whatever
PS C:\InstallMedia> $install

Id     Name            PSJobTypeName   State         HasMoreData     Location             Command
--     ----            -------------   -----         -----------     --------             -------
1      Job1            Configuratio... Completed     True            localhost            $install = Start-DscCo...

PS C:\InstallMedia> $install2 = Start-DscConfiguration -Path .\Example\ ; $install2

Id     Name            PSJobTypeName   State         HasMoreData     Location             Command
--     ----            -------------   -----         -----------     --------             -------
3      Job3            Configuratio... Running       True            localhost            $install = Start-DscCo...

PS C:\InstallMedia> $install2

Id     Name            PSJobTypeName   State         HasMoreData     Location             Command
--     ----            -------------   -----         -----------     --------             -------
3      Job3            Configuratio... Failed        True            localhost            $install = Start-DscCo...

PS C:\InstallMedia>

DSC configuration

Configuration Example
{
    [CmdletBinding()]
    param
    (
        [Parameter(Mandatory = $true)]
        [ValidateNotNullOrEmpty()]
        [System.Management.Automation.PSCredential]
        $SqlInstallCredential
    )

    Import-DscResource -ModuleName 'SqlServerDsc'

    node localhost
    {
        SqlRSSetup 'InstallDefaultInstance'
        {
            InstanceName         = 'SSRS'
            IAcceptLicenseTerms   = 'Yes'
            SourcePath           = 'C:\InstallMedia\SQLServerReportingServices.exe'
            Edition              = 'Development'

            PsDscRunAsCredential = $SqlInstallCredential
        }
    }
}

Suggested solution

no

SQL Server edition and version

SSRS 2019

SQL Server PowerShell modules

NA - not using any.  Not listed as required and seems to work without them so far.

Operating system

OsName               : Microsoft Windows Server 2019 Datacenter
OsOperatingSystemSKU : DatacenterServerEdition
OsArchitecture       : 64-bit
WindowsVersion       : 1809
WindowsBuildLabEx    : 17763.1.amd64fre.rs5_release.180914-1434
OsLanguage           : en-US
OsMuiLanguages       : {en-US}

PowerShell version

Name                           Value
----                           -----
PSVersion                      5.1.17763.2268
PSEdition                      Desktop
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}
BuildVersion                   10.0.17763.2268
CLRVersion                     4.0.30319.42000
WSManStackVersion              3.0
PSRemotingProtocolVersion      2.3
SerializationVersion           1.1.0.1

SqlServerDsc version

Name         Version Path
----         ------- ----
SqlServerDsc 15.2.0  C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\SqlServerDsc.psd1
johlju commented 2 years ago

On the second run, can you please run Start-DscConfiguration with -Wait -Verbose to get more information. Might help to see the cause.

jeremiahmoree-adot commented 2 years ago

Still testing on this. Will need to stand up a few more fresh servers. The current one refused to install ssrs with DSC from the start but the error was not helpful. I waited like before but still nothing and again there is nothing in the temp folder (%TEMP%) that relates to this.

After I install using the GUI DSC reports success every time.

PS C:\InstallMedia>  Start-DscConfiguration -Path .\Example\ -Verbose -Wait -Force; get-date
VERBOSE: Perform operation 'Invoke CimMethod' with following parameters, ''methodName' = SendConfigurationApply,'className' = MSFT_DSCLocalConfigurationManager,'namespaceName' = root/Microsoft/Windows/DesiredStateConfiguration'.
VERBOSE: An LCM method call arrived from computer SSRSD00011 with user sid S-1-5-21-XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX.
VERBOSE: [SSRSD00011]: LCM:  [ Start  Set      ]
VERBOSE: [SSRSD00011]: LCM:  [ Start  Resource ]  [[SqlRSSetup]InstallDefaultInstance]
VERBOSE: [SSRSD00011]: LCM:  [ Start  Test     ]  [[SqlRSSetup]InstallDefaultInstance]
VERBOSE: [SSRSD00011]:                            [[SqlRSSetup]InstallDefaultInstance] Determines if the Microsoft SQL Server Reporting Service instance is installed.
VERBOSE: [SSRSD00011]:                            [[SqlRSSetup]InstallDefaultInstance] Could not find a Microsoft SQL Server Reporting Service instance.
VERBOSE: [SSRSD00011]:                            [[SqlRSSetup]InstallDefaultInstance] Expected version '15.0.7961.31630' to be installed.
VERBOSE: [SSRSD00011]: LCM:  [ End    Test     ]  [[SqlRSSetup]InstallDefaultInstance]  in 1.2200 seconds.
VERBOSE: [SSRSD00011]: LCM:  [ Start  Set      ]  [[SqlRSSetup]InstallDefaultInstance]
VERBOSE: [SSRSD00011]:                            [[SqlRSSetup]InstallDefaultInstance] Using executable at 'C:\InstallMedia\SQLServerReportingServices.exe'.
VERBOSE: [SSRSD00011]:                            [[SqlRSSetup]InstallDefaultInstance] Starting executable using the arguments: /Edition=Dev /IAcceptLicenseTerms /Quiet
VERBOSE: [SSRSD00011]:                            [[SqlRSSetup]InstallDefaultInstance] Started the process with id 1056 using the path 'C:\InstallMedia\SQLServerReportingServices.exe', and with a timeout value of 7200 seconds. (SQLCOMMON0017)
VERBOSE: [SSRSD00011]:                            [[SqlRSSetup]InstallDefaultInstance] Executable exited with code '1603'.
VERBOSE: [SSRSD00011]: LCM:  [ End    Set      ]  [[SqlRSSetup]InstallDefaultInstance]  in 3.5180 seconds.
PowerShell DSC resource DSC_SqlRSSetup  failed to execute Set-TargetResource functionality with error message: System.Exception: Please see the log file in the %TEMP% folder.
    + CategoryInfo          : InvalidOperation: (:) [], CimException
    + FullyQualifiedErrorId : ProviderOperationExecutionFailure
    + PSComputerName        : localhost

VERBOSE: [SSRSD00011]: LCM:  [ End    Set      ]
The SendConfigurationApply function did not succeed.
    + CategoryInfo          : NotSpecified: (root/Microsoft/...gurationManager:String) [], CimException
    + FullyQualifiedErrorId : MI RESULT 1
    + PSComputerName        : localhost

VERBOSE: Operation 'Invoke CimMethod' complete.
VERBOSE: Time taken for configuration job to complete is 6.03 seconds

Thursday, January 13, 2022 10:32:27 AM
jeremiahmoree-adot commented 2 years ago

stood up fresh EC2 with win 2019. This time I also ran DSC with -Verbose and -Debug and set corresponding session variables to 'continue'. I am running powershell as ADministrator.

Using the steps documented above i cannot get a successful dsc ssrs install and Logs are not getting written anywhere. The small amount of output tells me to check the logs that don't exist (same as above). The key problem seems to be that the installer for SSRS fails with exit code 1603 which could be a number of issues but none apply to me based on my research. When I run the installer using the same commands that the output shows then SSRS installs. i.e. 

&'C:\InstallMedia\SQLServerReportingServices.exe'  /Edition=Dev /IAcceptLicenseTerms /Quiet

Now when I try to run DSC it gives new errors but suggests I try -UseExisting or -Force. -Force works at this point but I'll need to create another fresh server and see if -force works from the start. 

PS C:\InstallMedia> Start-DscConfiguration -path .\Example\ -Wait -Verbose -Debug
VERBOSE: Perform operation 'Invoke CimMethod' with following parameters, ''methodName' = SendConfigurationApply,'className' = MSFT_DSCLocalConfigurationManager,'namespaceName' = root/Microsoft/Windows/DesiredStateConfiguration'.
VERBOSE: An LCM method call arrived from computer JMORESSRSD00012 with user sid S-1-5-21-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.
VERBOSE: [JMORESSRSD00012]: LCM:  [ Start  Set      ]
VERBOSE: [JMORESSRSD00012]: LCM:  [ End    Set      ]
A configuration is pending. If you are in Pull mode, please run Update-DscConfiguration to pull a new configuration and apply it. If you are in Push mode, please run Start-DscConfiguration command with -Force parameter to apply a new configuration or run
Start-DscConfiguration command with -UseExisting parameter to finish the existing configuration.
    + CategoryInfo          : ResourceExists: (root/Microsoft/...gurationManager:String) [], CimException
    + FullyQualifiedErrorId : MI RESULT 11
    + PSComputerName        : localhost

VERBOSE: Operation 'Invoke CimMethod' complete.
VERBOSE: Time taken for configuration job to complete is 0.202 seconds
PS C:\InstallMedia> Start-DscConfiguration -path .\Example\ -Wait -Verbose -Debug -UseExisting
Start-DscConfiguration : Parameter set cannot be resolved using the specified named parameters.
At line:1 char:1
+ Start-DscConfiguration -path .\Example\ -Wait -Verbose -Debug -UseExi ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Start-DscConfiguration], ParameterBindingException
    + FullyQualifiedErrorId : AmbiguousParameterSet,Microsoft.PowerShell.DesiredStateConfiguration.Commands.StartDscConfigurationCommand

PS C:\InstallMedia> Start-DscConfiguration -path .\Example\ -Wait -Verbose -Debug -Force
VERBOSE: Perform operation 'Invoke CimMethod' with following parameters, ''methodName' = SendConfigurationApply,'className' = MSFT_DSCLocalConfigurationManager,'namespaceName' = root/Microsoft/Windows/DesiredStateConfiguration'.
VERBOSE: An LCM method call arrived from computer JMORESSRSD00012 with user sid S-1-5-21-xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx.
VERBOSE: [JMORESSRSD00012]: LCM:  [ Start  Set      ]
DEBUG: [JMORESSRSD00012]:                            [DSCEngine] File C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\Modules\DscResource.Common\0.10.3\en-US\DscResource.Common.psd1 not found
DEBUG: [JMORESSRSD00012]:                            [DSCEngine] Found C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\Modules\DscResource.Common\0.10.3\en-US\DscResource.Common.strings.psd1
DEBUG: [JMORESSRSD00012]:                            [DSCEngine] File C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\Modules\SqlServerDsc.Common\en-US\SqlServerDsc.Common.psd1 not found
DEBUG: [JMORESSRSD00012]:                            [DSCEngine] Found C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\Modules\SqlServerDsc.Common\en-US\SqlServerDsc.Common.strings.psd1
DEBUG: [JMORESSRSD00012]:                            [DSCEngine] File C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\DscResources\DSC_SqlRSSetup\en-US\DSC_SqlRSSetup.psd1 not found
DEBUG: [JMORESSRSD00012]:                            [DSCEngine] Found C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\DscResources\DSC_SqlRSSetup\en-US\DSC_SqlRSSetup.strings.psd1
VERBOSE: [JMORESSRSD00012]: LCM:  [ Start  Resource ]  [[SqlRSSetup]InstallDefaultInstance]
VERBOSE: [JMORESSRSD00012]: LCM:  [ Start  Test     ]  [[SqlRSSetup]InstallDefaultInstance]
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] File C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\Modules\DscResource.Common\0.10.3\en-US\DscResource.Common.psd1 not found
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] Found C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\Modules\DscResource.Common\0.10.3\en-US\DscResource.Common.strings.psd1
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] File C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\Modules\SqlServerDsc.Common\en-US\SqlServerDsc.Common.psd1 not found
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] Found C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\Modules\SqlServerDsc.Common\en-US\SqlServerDsc.Common.strings.psd1
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] File C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\DscResources\DSC_SqlRSSetup\en-US\DSC_SqlRSSetup.psd1 not found
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] Found C:\Program Files\WindowsPowerShell\Modules\SqlServerDsc\15.2.0\DscResources\DSC_SqlRSSetup\en-US\DSC_SqlRSSetup.strings.psd1
VERBOSE: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] Determines if the Microsoft SQL Server Reporting Service instance is installed.
VERBOSE: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] Found Microsoft SQL Server Reporting Service instance named 'SSRS'.
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0000003 Trying provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MetaProvider.PowerShell.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0022112 Trying provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MsiProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0002419 Trying provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MsuProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0005937 Trying provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.CoreProviders.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0011037 Trying provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.ArchiverProviders.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0040205 Attempting loading of assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MetaProvider.PowerShell.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0042797 Attempting loading of assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.ArchiverProviders.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0018491 Trying provider assembly: C:\Program Files\PackageManagement\ProviderAssemblies\nuget\2.8.5.208\Microsoft.PackageManagement.NuGetProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0061928 Attempting loading of assembly: C:\Program Files\PackageManagement\ProviderAssemblies\nuget\2.8.5.208\Microsoft.PackageManagement.NuGetProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0082494 Attempting loading of assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MsiProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0087871 Acquiring providers for assemblyC:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MetaProvider.PowerShell.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0095400 Attempting loading of assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MsuProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0109334 Attempting loading of assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.CoreProviders.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0146195 Acquiring providers for assemblyC:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MsiProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0159054 Acquiring providers for assemblyC:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.CoreProviders.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0168958 Acquiring providers for assemblyC:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MsuProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0182662 Acquiring providers for assemblyC:\Program Files\PackageManagement\ProviderAssemblies\nuget\2.8.5.208\Microsoft.PackageManagement.NuGetProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0211089 Acquiring providers for assemblyC:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.ArchiverProviders.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.0874166 Registering providers via metaproviders for assembly Microsoft.PackageManagement.MetaProvider.PowerShell.Internal.PowerShellMetaProvider
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1204638 Initializing provider 'NuGet'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1222970 Initializing provider 'msi'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1285942 Initializing provider 'Bootstrap'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1341823 Initializing provider 'WebDownloader'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1394149 Initializing provider 'Programs'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1575090 Calling 'Programs::InitializeProvider'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1575642 Provider 'Programs' Initialized
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1576023 Using Package Provider Programs
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1580397 Calling 'msi::InitializeProvider'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1580946 Provider 'msi' Initialized
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1581209 Using Package Provider msi
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1745224 Provider 'WebDownloader' Initialized
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1745808 Using Downloader Provider WebDownloader
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1750413 Calling 'NuGet'::'InitializeProvider'.
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1750785 Provider 'NuGet' Initialized
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1751135 Using Package Provider NuGet
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1783481 Initialize Bootstrapper
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1810595 Initializing provider 'zipfile'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.1891929 Initializing provider 'msu'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2167026 Calling 'Programs::GetFeatures'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2177391 The provider 'Programs' is imported
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2188446 Calling 'msu::InitializeProvider'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2188817 Provider 'msu' Initialized
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2189145 Using Package Provider msu
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2191362 Provider 'Bootstrap' Initialized
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2191637 Using Package Provider Bootstrap
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2246532 Calling 'NuGet'::'GetFeatures'.
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2272083 The provider 'NuGet' is imported
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2284998 SUCCESS provider assembly: C:\Program Files\PackageManagement\ProviderAssemblies\nuget\2.8.5.208\Microsoft.PackageManagement.NuGetProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2297422 Calling 'msi::GetFeatures'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2306244 The provider 'msi' is imported
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2309888 SUCCESS provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MsiProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2311656 Calling 'WebDownloader::GetFeatures'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2352737 Provider 'zipfile' Initialized
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.2353691 Using Archiver Provider zipfile
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3323337 Calling 'msu::GetFeatures'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3324200 The provider 'msu' is imported
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3329024 SUCCESS provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MsuProvider.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3425817 Trying to register metaprovider
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3432820 Calling 'Bootstrap::GetFeatures'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3434915 The provider 'Bootstrap' is imported
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3438567 SUCCESS provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.CoreProviders.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3522014 Initializing PowerShell MetaProvider
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3522474 Calling 'zipfile::GetFeatures'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3528022 SUCCESS provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.ArchiverProviders.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3839869 Calling 'WebDownloader::DownloadFile'
'https://go.microsoft.com/fwlink/?LinkID=627338&clcid=0x409','C:\Users\svc_AnySQLServer\AppData\Local\Temp\Microsoft.PackageManagement\e12av0nn.xvg','40000','False'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.3865403 Attempting to load PowerShell Provider Module [C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1]
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.8778806 Calling 'WebDownloader::DownloadFile'
'https://onegetcdn.azureedge.net/providers/nuget-2.8.5.208.package.swidtag','C:\Users\svc_AnySQLServer\AppData\Local\Temp\Microsoft.PackageManagement\whgrt3cf.sus','40000','False'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.9056013 Calling 'WebDownloader::DownloadFile'
'https://onegetcdn.azureedge.net/providers/psl-1.0.0.210.package.swidtag','C:\Users\svc_AnySQLServer\AppData\Local\Temp\Microsoft.PackageManagement\cleqfiqs.2oy','40000','False'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.9271880 Calling 'WebDownloader::DownloadFile'
'https://onegetcdn.azureedge.net/providers/ChocolateyPrototype-2.8.5.130.package.swidtag','C:\Users\svc_AnySQLServer\AppData\Local\Temp\Microsoft.PackageManagement\swlnkua2.z50','40000','False'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.9861465 Loaded PowerShell package provider: '[C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1]'.
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.9944545 Loaded PowerShell Provider: PowerShellGet
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:00.9968537 Initializing provider 'PowerShellGet'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0055831 Calling New() : MethodName = 'InitializeProvider'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0056328 ErrorAction: SilentlyContinue
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0056428 Verbose: False
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0056504 Name: Microsoft SQL Server Reporting Services
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0094109 INVOKING PowerShell Fn Initialize-Provider with args  that has length 0
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0331765 In PowerShellGet Provider - 'Initialize-Provider'.
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0334891 PowerShell Script 'PSModule' Function 'Initialize-Provider' returns null.
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0350806 Done calling powershell «Initialize-Provider» «PSModule»
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0351332 Provider 'PowerShellGet' Initialized
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0351471 Using Package Provider PowerShellGet
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0416743 Calling New() : MethodName = 'GetFeatures'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0417064 ErrorAction: SilentlyContinue
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0417186 Verbose: False
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0417303 Name: Microsoft SQL Server Reporting Services
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0427515 INVOKING PowerShell Fn Get-Feature with args  that has length 0
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0532956 In PowerShellGet Provider - 'Get-Feature'.
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0667661 Done calling powershell «Get-Feature» «PSModule»
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0668558 The provider 'PowerShellGet' is imported
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.0684090 SUCCESS provider assembly: C:\Program Files\WindowsPowerShell\Modules\PackageManagement\1.0.0.1\Microsoft.PackageManagement.MetaProvider.PowerShell.dll
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.6245432 Calling 'Programs::GetDynamicOptions' 'Provider'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.6282924 Calling 'Programs::GetDynamicOptions' 'Install'
DEBUG: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] 00:00:01.7274842 Calling 'Programs::GetInstalledPackages' 'Microsoft SQL Server Reporting Services','','',''
VERBOSE: [JMORESSRSD00012]:                            [[SqlRSSetup]InstallDefaultInstance] The Microsoft SQL Server Reporting Service instance is version '15.0.7961.31630'.
VERBOSE: [JMORESSRSD00012]: LCM:  [ End    Test     ]  [[SqlRSSetup]InstallDefaultInstance]  in 3.0810 seconds.
VERBOSE: [JMORESSRSD00012]: LCM:  [ Skip   Set      ]  [[SqlRSSetup]InstallDefaultInstance]
VERBOSE: [JMORESSRSD00012]: LCM:  [ End    Resource ]  [[SqlRSSetup]InstallDefaultInstance]
VERBOSE: [JMORESSRSD00012]: LCM:  [ End    Set      ]
VERBOSE: [JMORESSRSD00012]: LCM:  [ End    Set      ]    in  4.3660 seconds.
VERBOSE: Operation 'Invoke CimMethod' complete.
VERBOSE: Time taken for configuration job to complete is 6.1 seconds
github-actions[bot] commented 2 years ago

This issue has been automatically marked as stale because it has not had activity from the community in the last 30 days. It will be closed if no further activity occurs within 40 days. If the issue is labelled with any of the work labels (e.g bug, enhancement, documentation, or tests) then the issue will not auto-close.

johlju commented 2 years ago

If there is an issue with subsequent runs then the function Get-TargetResource and Test-TargetResource need to be debugged to see why it starts the installation (why Set-TargetResource is called) when there are already an instance installed.

jeremiahmoree-adot commented 2 years ago

This project has been put on hold since it is taking much longer to get working than anticipated. I will return to debugging this in the future. I assume the issue will will get auto closed. I will reopen if I make any progress.

github-actions[bot] commented 2 years ago

This issue has been automatically marked as stale because it has not had activity from the community in the last 30 days. It will be closed if no further activity occurs within 40 days. If the issue is labelled with any of the work labels (e.g bug, enhancement, documentation, or tests) then the issue will not auto-close.

github-actions[bot] commented 2 years ago

This issue has been automatically closed because it is has not had activity from the community in the last 40 days. If this issue was wrongly closed, for a issue author please comment and re-open it, if you are not the issue author comment with a reason for it to be reopened and tag a maintainer in the comment.