Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Set-RsDatabase failing for SSRS 2022 for "ReportingServicesTools" Module version os 0.0.9.0 #425

Open
awsrams opened this issue May 11, 2024 · 0 comments

Comments

@awsrams
Copy link

awsrams commented May 11, 2024

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

What is the current behavior?
ReportingServicesTools module for latest version available of 0.0.8.0 is supported until SSRS 2019 versions.
The unpublished module of 0.0.9.0 though SSRS 2022 is updated but it's not working as expected and is failing with "Exception calling "SetDatabaseConnection" : """ Errrors.

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.
Yes reporting bug.
"Set-RsDatabase" is failing for the SSRS 2022 with the below error. The configuration of ReportServer database for SQL Server Reporting Services is working as expected for SSRS 2019 with the $ssrsVersionValue for 15.
But for SSRS 2022 configuration with the $ssrsVersionValue of 16 is failing with the exception on SetDatabaseConnection.

    Set-RsDatabase `
    -ReportServerVersion $ssrsVersionValue `
    -ReportServerInstance $ssrsInstance `
    -DatabaseServerName localhost `
    -Name 'ReportServer' `
    -DatabaseCredentialType 'SQL' `
    -DatabaseCredential $ssrsUserCreds `
    -AdminDatabaseCredentialType 'Windows' `
    -AdminDatabaseCredential $domainAdminCreds `
    -Confirm:$false `
    -Verbose

https://github.com/microsoft/ReportingServicesTools/blob/master/ReportingServicesTools/Functions/Admin/Set-RsDatabase.ps1

Reproduce steps:
The above Set-RsDatabase for SSRS 2019 is working for 0.0.9.0 versions with $ssrsVersionValue=15 & $ssrsInstance=SSRS values for configuring SSRS on SQL Server EC-2 Machine with the latest 2022 Standard Edition of public AMI.

The configuration of Set-RsDatabase for SSRS 2022 is FAILING for 0.0.9.0 with $ssrsVersionValue=16 and ssrsInstance=SSRS
values for configuring SSRS on SQL Server EC-2 Machine with the latest 2022 Standard Edition of public AMI.

Error:
VERBOSE: Changed database context to 'ReportServerTempDB'.
VERBOSE: Changed database context to 'ReportServer'.
VERBOSE: Executing database rights script... Complete!
VERBOSE: Updating Reporting Services to connect to new database...
Exception calling "SetDatabaseConnection" : ""

What is the expected behavior?
The expected behavior is for SSRS 2022 and ssrsVersionValue of 16 should work same as SSRS 2019

Which versions of Powershell and which OS are affected by this issue? Did this work in previous versions of our scripts?
https://github.com/microsoft/ReportingServicesTools/releases/tag/0.0.9.0

The previous version of 0.0.8.0 is not supported for SSRS 2022, however when tried the unpublished module of ReportingServicesTools for release tag 0.0.9.0 is not working as expected for SSRS 2022.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant