Grant-RsCatalogItemRole Error - "Failed to establish proxy connection" on SQL 2019

[saandersen]

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

What is the current behavior? Receiving the error message: Failed to establish proxy connection to http://server/reportserver/ReportService2010.asmx : there was an error downloading 'http://server/reportserver/ReportService2010.asmx'.

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem. -Install SQL Server Reporting Services 2019 -Change Reporting Services service to run under Administrative service account -Install-PackageProvider -Name NuGet -Force -Set-PSRepository -Name 'PSGallery' -InstallationPolicy Trusted -Install-Module -Name SqlServer -Force -Confirm:$False -AllowClobber -Install-Module -Name DbaTools -Force -Confirm:$False -Install-Module -Name ReportingServicesTools -Set-RsDatabase -DatabaseServerName server -ReportServerInstance SSRS -SqlServerVersion SQLServervNext -Name ReportServer -DatabaseCredentialType ServiceAccount -Confirm:$False -Set-RsUrlReservation -ComputerName server -ReportServerInstance SSRS -SqlServerVersion SQLServervNext -Grant-RsCatalogItemRole -ReportServerUri 'http://server/reportserver' -Identity 'DOMAIN\User' -RoleName 'Content Manager' -Path '/'

What is the expected behavior? Users or groups could be added through the command line to the Report Manager with a specified role i.e. Content Manager.

Which versions of Powershell and which OS are affected by this issue? Did this work in previous versions of our scripts? Powershell = 5.1.17763.2268 OS = Windows Server 2019 Standard Yes, this worked for SQL Server 2016

[makotia-zz]

Any luck with this?

[DinoMyriadTech]

I am also having a similar issue runs fine in normal powershell5/ISE but when executed inside a .NetCore 3.1 console application under the hood the 'Grant-RsCatalogItemRole' is trying to execute a New-RsWebServiceProxyHelper -> which in turn tries to execute : New-RsWebServiceProxy @NewRsWebServiceProxyParam. This is where I am having an error in my logs, similar to:

Could not load file or assembly 'file:///C:\Users\spadmin\AppData\Local\Temp\2\gfrc04pp\gfrc04pp.dll' or one of its dependencies. The system cannot find the file specified.

• CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
• FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,a606ffe3-0ec9-4ec0-9ec4-e02c793144de.p s1

Please note that I am trying to connect to a Native PowerBi reportserver.

[eneerge]

Same issue here.