SqlRS: Does this resource support Microsoft SQL Server 2017 Reporting Services?

[johlju]

Details of the scenario you tried and the problem that is occurring:
In SQL Server 2017 Reporting Services are no longer a part of SQL Server, but a separate install Microsoft SQL Server 2017 Reporting Services.

Does this, and should this, resource support Microsoft SQL Server 2017 Reporting Services?

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

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

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

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

[stale]

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

[stale]

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 10 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]

I suggest adding a new resource SqlRSSetup that downloads (either from URL, UNC or file) and installs RS, for the other resource to be able to configure it.

Labeling this as resource proposal, and help wanted so that anyone in the community can run with this.

[bozho]

Only slightly related: modifying SqlRs resource to support configuring installed SSRS 2017 instance seems to involve only three changes:

• related SQL Server version Registry key for SSRS is on a different path
• the name of the Windows service is different
• the name of the SSRS Windows account is different

I have a patch for this, I'm happy to submit a pull request under different issue.

Also, apologies for letting several of my suggestions and questions go stale, I'm hoping I'll have more time in 2019 to work on DSC stuff :)

[johlju]

@bozho Please send in a PR for the proposed change, and please reference this issue.

There is already another issue #865 for creating a new resource SqlRSSetup. Relabeling this issue to enhancement.