search

tobania / VSTS.Extension.SqlReportingServices

VSTS Extension for uploading SSRS Reports
MIT License
14 stars 20 forks source link

After SSRS scaleout deployment failed. Microsoft.PowerShell.Commands.WriteErrorException: Unable to connect to the remote server #58

Open pjshah70 opened 3 years ago

pjshah70 commented 3 years ago

After SSRS scaleout deployment failed with error. Microsoft.PowerShell.Commands.WriteErrorException: Unable to connect to the remote server. I am able to connect and deploy to the endpoint from same machine and using same credentials from Browser. It is also able to deploy using same credentials from VisualStudio. But this task failed.

Partial Log: 2021-03-22T17:09:21.6910409Z Task : SQL Server Reports Deployment 2021-03-22T17:09:21.6911502Z Version : 1.4.3 2021-03-22T17:09:23.1738207Z Executing the powershell script: E:\VSTS1_tasks\SqlReportingServicesDeployment_e99e48ac-8011-45ca-aa36-fc2cec54ecfb\1.4.3\SqlReportingServicesDeployment.ps1 2021-03-22T17:09:23.1739736Z ##[debug]PowerShellHandler.Execute - AddCommand(E:\VSTS1_tasks\SqlReportingServicesDeployment_e99e48ac-8011-45ca-aa36-fc2cec54ecfb\1.4.3\SqlReportingServicesDeployment.ps1) ... 2021-03-22T17:09:23.1749035Z ##[debug]PowerShellHandler.Execute - AddParameter(WebserviceUrl=http:///ReportServer/ReportService2010.asmx?wsdl) 2021-03-22T17:09:23.1749811Z ##[debug]PowerShellHandler.Execute - AddParameter(WsUsername=) 2021-03-22T17:09:23.1750944Z ##[debug]PowerShellHandler.Execute - AddParameter(WsPassword=***) 2021-03-22T17:09:23.3977118Z Preparing Deployment of RDL files... 2021-03-22T17:09:23.4483243Z Uploading files 2021-03-22T17:09:23.4590526Z Creating WebService proxy using credentials 2021-03-22T17:09:26.4367546Z Uploading 6 files to http:///ReportServer/ReportService2010.asmx?wsdl (/SC_Documents-test)... 2021-03-22T17:09:26.4797075Z Uploading report ContractSSRS to /SC_Documents-test... 2021-03-22T17:09:47.5277733Z ##[error]Microsoft.PowerShell.Commands.WriteErrorException: Unable to connect to the remote server