microsoft / ReportingServicesTools

Reporting Services Powershell Tools
MIT License
452 stars 212 forks source link

Set-RSDatabase SSRS 2019 #329

Open Ranger30 opened 3 years ago

Ranger30 commented 3 years ago

Do you want to request a feature or report a bug?

Bug ?

What is the current behavior?

When using the Set-RSDatabase cmdlet I get the following error.

Are you sure you want to perform this action ? Performing the operation "Configure to use SSDB-YYY-SQL19A\INSTA as the database, using the ServiceAccount runtime authentication and setup authentication" on target "localhost (SQLServer2016)\SSRS".

Yes Yes to all No No to all Suspend

Where are the "localhost (SQLServer2016)\SSRS" details extracted from ?

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.

This is attempting to configure the report Server database and report tempdb on another SQL Server. That server is SQL 2019 and OS 2016

What is the expected behavior?

It would work ..please. The manual configuration of the remote database works ok via the Report Configure manager tool.

Which versions of Powershell and which OS are affected by this issue? Did this work in previous versions of our scripts?

PS version 5.1.14393.3866 OS version of target for SSRS database : Windows 2016 SQL version on remote : 2019

The script routines have worked perfectly before when deploying SSRS 2016.

I just would like to know how to configure a SSRS 2019 automated deployment. If anyone has examples would they be kind enough to supply a script ?

many thanks for any advice given.

bd-arman-tursunkhanov commented 2 years ago

Hello, did you get a chance to find automated way of creating ReportServer database for SSRS2019?