SqlRs: Reporting services are not initialized

Details of the scenario you tried and the problem that is occurring:

I encountered this issue while continuing on my quest to configure a standalone SSRS server that uses the SQLEngine on a different server.

Two server setup:

• Server One running "SQLENGINE" and "SSMS" features (FQDN is DB.mydomain.com)
• Server Two running only "RS" feature with Service Account set to NT AUTHORITY\NETWORK SERVICE (FQDN is SSRS.mydomain.com)
• xSQLServerRSConfig has the PsDscRunAsCredential set to the credentials of a Domain Admin

The xSQLServerRSConfig resource gets as far as creating the databases on the remote server (DB.mydomain.com) and then fails with a non-informative error message. However, prior to the error, there is a verbose log that says Reporting services DB.mydomain.com\MSSQLSERVER are not initialized. That message seems odd because Reporting services is running on SSRS.mydomain.com

Also worth noting is that once the databases are created, rerunning the config fails due to their presence. There is another issue (#860) logged that also mentions that. Interestingly, the second bullet in that issue also seems relevant (where it mentions that isInitialized is checked and fails, but perhaps needs to wait longer). Perhaps this second bullet is describing the situation I am in as well?

Here is the verbose output from Start-DscConfiguration:

VERBOSE: [SSRS]: LCM:  [ Start  Resource ]  [[xSQLServerRSConfig]DefaultConfiguration]
VERBOSE: [SSRS]: LCM:  [ Start  Test     ]  [[xSQLServerRSConfig]DefaultConfiguration]
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Importing the module MSFT_xSQLServerRSConfig in force mode.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Importing the module MSFT_xSQLServerRSConfig in force mode.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] 2017-12-05_10-13-06: Reporting services DB.mydomain.com\MSSQLSERVER are not initialized.
VERBOSE: [SSRS]: LCM:  [ End    Test     ]  [[xSQLServerRSConfig]DefaultConfiguration]  in 1.4060 seconds.
VERBOSE: [SSRS]: LCM:  [ Start  Set      ]  [[xSQLServerRSConfig]DefaultConfiguration]
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Importing the module MSFT_xSQLServerRSConfig in force mode.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Importing the module MSFT_xSQLServerRSConfig in force mode.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] 2017-12-05_10-13-07: Initializing Reporting Services on DB.mydomain.com\MSSQLSERVER.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Preferred module SqlServer found.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Importing PowerShell module SqlServer.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'msdb'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'master'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServerTempDB'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServerTempDB'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'master'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'msdb'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServerTempDB'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServerTempDB'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServerTempDB'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServerTempDB'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Caution: Changing any part of an object name could break scripts and stored procedures.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServerTempDB'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Warning! The maximum key length is 900 bytes. The index 'IX_Schedule' has maximum length of 1040 bytes. For some combination of large values, the insert/update operation will fail.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Caution: Changing any part of an object name could break scripts and stored procedures.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] The module 'CreateRdlChunk' depends on the missing object 'CreateSegmentedChunk'. The module will still be created; however, it cannot run successfully until the object exists.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] The module 'CreateRdlChunk' depends on the missing object 'CreateChunkSegment'. The module will still be created; however, it cannot run successfully until the object exists.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServerTempDB'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'master'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServerTempDB'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'msdb'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'master'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Changed database context to 'ReportServer'.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Getting Reporting Services service information.
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Reporting Services service restarting.
WARNING: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Waiting for service 'SQL Server Reporting Services (MSSQLSERVER) (ReportServer)' to stop...
WARNING: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Waiting for service 'SQL Server Reporting Services (MSSQLSERVER) (ReportServer)' to stop...
WARNING: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Waiting for service 'SQL Server Reporting Services (MSSQLSERVER) (ReportServer)' to start...
WARNING: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] Waiting for service 'SQL Server Reporting Services (MSSQLSERVER) (ReportServer)' to start...
VERBOSE: [SSRS]:                            [[xSQLServerRSConfig]DefaultConfiguration] 2017-12-05_10-13-40: Reporting services DB.mydomain.com\MSSQLSERVER are not initialized.
VERBOSE: [SSRS]: LCM:  [ End    Set      ]  [[xSQLServerRSConfig]DefaultConfiguration]  in 34.2420 seconds. PowerShell DSC resource MSFT_xSQLServerRSConfig  failed to execute Set-TargetResource functionality with error
message: Test-TargetResource returned false after calling set.
    + CategoryInfo          : InvalidOperation: (:) [], CimException
    + FullyQualifiedErrorId : ProviderOperationExecutionFailure
    + PSComputerName        : SSRS

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

xSQLServerRSConfig DefaultConfiguration
{
    InstanceName = $SqlData.InstanceName
    RSSQLServer = $sqlServerNodeName
    RSSQLInstanceName = $SqlData.InstanceName
    ReportServerVirtualDirectory = $SqlData.ReportServerVirtualDirectory
    ReportsVirtualDirectory = $SqlData.ReportsVirtualDirectory
    PsDscRunAsCredential = $DomainAdminCreds
    DependsOn = "[xSqlServerSetup]InstallSql", "[File]InstallSqlServerModule"
}

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

Windows Server 2012R2, SQL Server 2014 SP2, PowerShell5.1

What module (SqlServer or SQLPS) and which version of the module the DSC Target Node is running:

SqlServer 21.0.17199

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

9.0.0.0

Start at the xSQLServerRSConfig entry point and reproduce the configuration with Start-DscConfiguration using the two-server setup described. Trace why the resource reports the remote Reporting Services instance as uninitialized after database creation and service restart; done means initialization succeeds and a subsequent configuration run does not fail because the databases already exist.