microsoft / ReportingServicesTools

Reporting Services Powershell Tools
MIT License
458 stars 213 forks source link

bug - Grant-RsSystemRole - failing with download error #388

Open CarlosGzz-SQL opened 2 years ago

CarlosGzz-SQL commented 2 years ago

Do you want to request a feature or report a bug? Report a bug What is the current behavior? while running Grant-RsSystemRole it fails with the error message below, I have noticed this only happens with SSRS version 2014, I have tried this in at least 4 servers with the same error, and running this in newer versions of SSRS (2016,2017,2019) this works fine.

Failed to establish proxy connection to http://<>/Reports/ReportService2010.asmx : There was an error downloading 'http://<>/Reports/ReportService2010.asmx'. At C:\Program Files\WindowsPowerShell\Modules\ReportingServicesTools\0.0.7.2\Functions\Utilities\New-RsWebServiceProxy.ps1:136 char:9 throw (New-Object System.Exception("Failed to establish proxy ...


     CategoryInfo          : OperationStopped: (:) [], Exception
     FullyQualifiedErrorId : Failed to establish proxy connection to http://<<MyAwesomeServer>>/Reports/ReportService2010.asmx : There was an error downloading 'http://<<MyAwesomeServer>>/Reports/ReportService2010.asmx'.

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem. using IDE or console running code below. $SSRS_Url ="http://<<MyAwesomeServer>>/Reports/"; $SSRS_user ="MyUSerAccount"; $SSRS_Role = "System Administrator"; Grant-RsSystemRole -ReportServerUri $SSRS_Url -Identity $SSRS_user -RoleName $SSRS_Role ;

What is the expected behavior? add user (AD or local) to System administrator role Which versions of Powershell and which OS are affected by this issue? Did this work in previous versions of our scripts? not sure if worked in other versions affected ssrs version 2014 Screenshot 2022-09-26 131324

PS: 5.1 Windows Server 2019