search

tobania / VSTS.Extension.SqlReportingServices

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

Creating WebService proxy using credentials #37

Closed MagnusTim closed 6 years ago

MagnusTim commented 6 years ago

Hi,

Thanks for a nice build task!

We have problems deploying to one of our buildservers. We use: SQL Server 2014 SP2, 12.0.5000.0 and the user running the deploystep is local admin on the server and has rights on the RS instance.   We get the following error:

2018-02-07T13:45:42.0734713Z Uploading files 2018-02-07T13:45:42.0794723Z Creating WebService proxy using credentials 2018-02-07T13:45:42.0794723Z 2018-02-07T13:45:42.0794723Z 2018-02-07T13:46:03.1817656Z ##[error]System.Management.Automation.ActionPreferenceStopException: The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Unable to connect to the remote server 2018-02-07T13:46:03.1817656Z ##[debug]Processed: ##vso[task.logissue type=error;]System.Management.Automation.ActionPreferenceStopException: The running command stopped because the preference variable "ErrorActionPreference" or common parameter is set to Stop: Unable to connect to the remote server 2018-02-07T13:46:03.1817656Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2018-02-07T13:46:03.1817656Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2018-02-07T13:46:03.1817656Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2018-02-07T13:46:03.1817656Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-07T13:46:03.1817656Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-07T13:46:03.1827676Z at Microsoft.TeamFoundation.DistributedTask.Handlers.LegacyVSTSPowerShellHost.VSTSPowerShellHost.Main(String[] args)

Do you have any guidence or tips what we could do or if we can get extende logging somehow?

Regards Magnus

ygeelen-tb commented 6 years ago

Could you try running a simple powershell script that does an HTTP request to your Reporting Services Service and print the response?

jonasnorrlander commented 6 years ago

Hi,

Tried to make a call with powershell (Invoke-WebRequest -Uri "http://WSP2597C/ReportServer/ReportService2010.asmx?wsdl") and got the following error.

2018-02-12T11:06:38.9650478Z Deployment started on target machine... 2018-02-12T11:06:38.9650478Z 2018-02-12T11:06:38.9650478Z System.AggregateException: Failed to execute the powershell script. Consult the logs below for details of the error. 2018-02-12T11:06:38.9650478Z The remote server returned an error: (401) Unauthorized. ---> System.Management.Automation.CmdletInvocationException: The remote server returned an error: (401) Unauthorized. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized. 2018-02-12T11:06:38.9650478Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request) 2018-02-12T11:06:38.9650478Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord() 2018-02-12T11:06:38.9650478Z --- End of inner exception stack trace --- 2018-02-12T11:06:38.9650478Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2018-02-12T11:06:38.9650478Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2018-02-12T11:06:38.9650478Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2018-02-12T11:06:38.9650478Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9650478Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9650478Z at System.Management.Automation.PowerShell.Invoke(IEnumerable input, PSInvocationSettings settings) 2018-02-12T11:06:38.9650478Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.<>cDisplayClass28_0.b0() 2018-02-12T11:06:38.9650478Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.<>cDisplayClass19_0`1.b0() 2018-02-12T11:06:38.9650478Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.Execute(Action action) 2018-02-12T11:06:38.9650478Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.Execute[T](Func1 action) 2018-02-12T11:06:38.9660554Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.Invoke(String errorContextMessage, Boolean writeResultToLog, Boolean isCancellable, ActionPreference errorActionPreference) 2018-02-12T11:06:38.9660554Z --- End of inner exception stack trace --- 2018-02-12T11:06:38.9660554Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.Invoke(String errorContextMessage, Boolean writeResultToLog, Boolean isCancellable, ActionPreference errorActionPreference) 2018-02-12T11:06:38.9660554Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.ScriptExecutor.ExecuteScript(IPowerShell powerShell, String script, String arguments, Boolean isScriptDotSourced, Boolean useHttp) 2018-02-12T11:06:38.9660554Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.DeploymentService.RunPowerShellScripts(DeploymentMachineSpecification deploymentMachine, ScriptSpecification scriptSpecification, ScriptSpecification initializationScriptSpecification, String applicationPath, IPowerShell powerShellSession) 2018-02-12T11:06:38.9660554Z ---> (Inner Exception #0) System.Management.Automation.CmdletInvocationException: The remote server returned an error: (401) Unauthorized. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized. 2018-02-12T11:06:38.9660554Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request) 2018-02-12T11:06:38.9660554Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord() 2018-02-12T11:06:38.9660554Z --- End of inner exception stack trace --- 2018-02-12T11:06:38.9660554Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2018-02-12T11:06:38.9660554Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2018-02-12T11:06:38.9660554Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2018-02-12T11:06:38.9660554Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9660554Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9660554Z at System.Management.Automation.PowerShell.Invoke(IEnumerable input, PSInvocationSettings settings) 2018-02-12T11:06:38.9660554Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.<>c__DisplayClass28_0.<Invoke>b__0() 2018-02-12T11:06:38.9660554Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.<>c__DisplayClass19_01.b0() 2018-02-12T11:06:38.9660554Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.Execute(Action action) 2018-02-12T11:06:38.9660554Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.Execute[T](Func1 action) 2018-02-12T11:06:38.9660554Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.Invoke(String errorContextMessage, Boolean writeResultToLog, Boolean isCancellable, ActionPreference errorActionPreference)<--- 2018-02-12T11:06:38.9660554Z GET http://wsp2597c/ReportServer/ReportService2010.asmx?wsdl with 0-byte payload 2018-02-12T11:06:38.9670490Z 2018-02-12T11:06:38.9670490Z 2018-02-12T11:06:38.9670490Z 2018-02-12T11:06:38.9670490Z ##[debug]Service logs for Deployment operation on WSP2597C:5985 2018-02-12T11:06:38.9670490Z ##[debug]RemoteDeployerSource Verbose: 10 : [RemoteDeployer][12:feb:18:12:6:36:3800; 19784, 4](WSP2597C)Creating public key for communication 2018-02-12T11:06:38.9670490Z RemoteDeployerSource Verbose: 2 : [RemoteDeployer][12:feb:18:12:6:36:3956; 19784, 4](WSP2597C)Created public key for communication 2018-02-12T11:06:38.9670490Z RemoteDeployerSource Information: 12 : [RemoteDeployer][12:feb:18:12:6:36:3956; 19784, 4](WSP2597C)Deployment service - VisualStudioRemoteDeployerf5dde5eb-72ca-4e35-bd5a-33cd35119140 is running... 2018-02-12T11:06:38.9670490Z RemoteDeployerSource Verbose: 4 : [RemoteDeployer][12:feb:18:12:6:37:4112; 19784, 6](WSP2597C)Input file found 2018-02-12T11:06:38.9670490Z RemoteDeployerSource Verbose: 5 : [RemoteDeployer][12:feb:18:12:6:37:4112; 19784, 6](WSP2597C)Reading input parameters 2018-02-12T11:06:38.9670490Z RemoteDeployerSource Verbose: 6 : [RemoteDeployer][12:feb:18:12:6:37:4112; 19784, 6](WSP2597C)Finished reading input parameters 2018-02-12T11:06:38.9670490Z RemoteDeployerSource Verbose: 7 : [RemoteDeployer][12:feb:18:12:6:37:4581; 19784, 6](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)Executing specified action. ScriptNull= False,. AzureStorageNull: True 2018-02-12T11:06:38.9670490Z RemoteDeployerSource Information: 1222012 : [RemoteDeployer][12:feb:18:12:6:37:4581; 19784, 6](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)deploymentMachine.MachineName: localhost. 2018-02-12T11:06:38.9670490Z RemoteDeployerSource Information: 1221727 : [RemoteDeployer][12:feb:18:12:6:37:4581; 19784, 6](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)ApplicationPath: 2018-02-12T11:06:38.9680588Z RemoteDeployerSource Information: 1221740 : [RemoteDeployer][12:feb:18:12:6:37:4737; 19784, 4](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)Establishing local powershell session on the machine 2018-02-12T11:06:38.9680588Z RemoteDeployerSource Information: 1221740 : [RemoteDeployer][12:feb:18:12:6:37:7551; 19784, 4](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)Finished establishing local powershell session on the machine 2018-02-12T11:06:38.9680588Z RemoteDeployerSource Information: 1221661 : [RemoteDeployer][12:feb:18:12:6:37:7551; 19784, 4](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)Starting Run Dsc on the machine:localhost, powershell port: 5985. 2018-02-12T11:06:38.9680588Z RemoteDeployerSource Information: 1221666 : [RemoteDeployer][12:feb:18:12:6:37:7551; 19784, 4](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)Executing commands to set execution policy and set global variables. 2018-02-12T11:06:38.9680588Z RemoteDeployerSource Information: 1222014 : [RemoteDeployer][12:feb:18:12:6:37:7862; 19784, 4](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)GetDeploymentScript:: applicationPath: 2018-02-12T11:06:38.9680588Z RemoteDeployerSource Information: 1221667 : [RemoteDeployer][12:feb:18:12:6:37:7862; 19784, 4](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)Machine:localhost Port:5985 => Creating Working Directory and setting it as the current directory. 2018-02-12T11:06:38.9680588Z RemoteDeployerSource Information: 1221665 : [RemoteDeployer][12:feb:18:12:6:37:8175; 19784, 4](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)Executing powershell script file. 2018-02-12T11:06:38.9680588Z RemoteDeployerSource Verbose: 1221675 : [RemoteDeployer][12:feb:18:12:6:37:8800; 19784, 4](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)Finished retrying 1 out of 3 times for exception: System.Management.Automation.CmdletInvocationException: The remote server returned an error: (401) Unauthorized. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized. 2018-02-12T11:06:38.9680588Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request) 2018-02-12T11:06:38.9680588Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord() 2018-02-12T11:06:38.9680588Z --- End of inner exception stack trace --- 2018-02-12T11:06:38.9680588Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2018-02-12T11:06:38.9680588Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2018-02-12T11:06:38.9680588Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2018-02-12T11:06:38.9680588Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9680588Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection1 input, PSDataCollection`1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9680588Z at System.Management.Automation.PowerShell.Invoke(IEnumerable input, PSInvocationSettings settings) 2018-02-12T11:06:38.9680588Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.<>cDisplayClass28_0.b0() 2018-02-12T11:06:38.9680588Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.<>cDisplayClass19_01.<Execute>b__0() 2018-02-12T11:06:38.9680588Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.Execute(Action action) 2018-02-12T11:06:38.9690549Z RemoteDeployerSource Error: 1221741 : [RemoteDeployer][12:feb:18:12:6:37:8800; 19784, 4](WSP2597C:5985-f5dde5eb-72ca-4e35-bd5a-33cd35119140)System.AggregateException: Failed to execute the powershell script. Consult the logs below for details of the error. 2018-02-12T11:06:38.9690549Z The remote server returned an error: (401) Unauthorized. ---> System.Management.Automation.CmdletInvocationException: The remote server returned an error: (401) Unauthorized. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized. 2018-02-12T11:06:38.9690549Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request) 2018-02-12T11:06:38.9690549Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord() 2018-02-12T11:06:38.9690549Z --- End of inner exception stack trace --- 2018-02-12T11:06:38.9690549Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2018-02-12T11:06:38.9690549Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2018-02-12T11:06:38.9690549Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2018-02-12T11:06:38.9690549Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9690549Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9690549Z at System.Management.Automation.PowerShell.Invoke(IEnumerable input, PSInvocationSettings settings) 2018-02-12T11:06:38.9690549Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.<>c__DisplayClass28_0.<Invoke>b__0() 2018-02-12T11:06:38.9690549Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.<>c__DisplayClass19_01.b0() 2018-02-12T11:06:38.9690549Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.Execute(Action action) 2018-02-12T11:06:38.9690549Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.Execute[T](Func1 action) 2018-02-12T11:06:38.9690549Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.Invoke(String errorContextMessage, Boolean writeResultToLog, Boolean isCancellable, ActionPreference errorActionPreference) 2018-02-12T11:06:38.9690549Z --- End of inner exception stack trace --- 2018-02-12T11:06:38.9690549Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.Invoke(String errorContextMessage, Boolean writeResultToLog, Boolean isCancellable, ActionPreference errorActionPreference) 2018-02-12T11:06:38.9690549Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.ScriptExecutor.ExecuteScript(IPowerShell powerShell, String script, String arguments, Boolean isScriptDotSourced, Boolean useHttp) 2018-02-12T11:06:38.9690549Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.DeploymentService.RunPowerShellScripts(DeploymentMachineSpecification deploymentMachine, ScriptSpecification scriptSpecification, ScriptSpecification initializationScriptSpecification, String applicationPath, IPowerShell powerShellSession) 2018-02-12T11:06:38.9690549Z ---> (Inner Exception #0) System.Management.Automation.CmdletInvocationException: The remote server returned an error: (401) Unauthorized. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized. 2018-02-12T11:06:38.9700485Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.GetResponse(WebRequest request) 2018-02-12T11:06:38.9700485Z at Microsoft.PowerShell.Commands.WebRequestPSCmdlet.ProcessRecord() 2018-02-12T11:06:38.9700485Z --- End of inner exception stack trace --- 2018-02-12T11:06:38.9700485Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2018-02-12T11:06:38.9700485Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2018-02-12T11:06:38.9700485Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2018-02-12T11:06:38.9700485Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9700485Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection1 input, PSDataCollection`1 output, PSInvocationSettings settings) 2018-02-12T11:06:38.9700485Z at System.Management.Automation.PowerShell.Invoke(IEnumerable input, PSInvocationSettings settings) 2018-02-12T11:06:38.9700485Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.<>cDisplayClass28_0.b0() 2018-02-12T11:06:38.9700485Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.<>cDisplayClass19_01.<Execute>b__0() 2018-02-12T11:06:38.9700485Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.Execute(Action action) 2018-02-12T11:06:38.9700485Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Utilities.RetryExecutor.Execute[T](Func1 action) 2018-02-12T11:06:38.9700485Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.Invoke(String errorContextMessage, Boolean writeResultToLog, Boolean isCancellable, ActionPreference errorActionPreference)<--- 2018-02-12T11:06:38.9700485Z 2018-02-12T11:06:38.9700485Z RemoteDeployerSource Information: 1221662 : [RemoteDeployer]12:feb:18:12:6:37:8800; 19784, 4Cleaning temporary Mof Folder 2018-02-12T11:06:38.9700485Z RemoteDeployerSource Verbose: 1221778 : [RemoteDeployer]12:feb:18:12:6:37:8956; 19784, 4Disposing the remote session 2018-02-12T11:06:38.9700485Z RemoteDeployerSource Verbose: 8 : [RemoteDeployer]12:feb:18:12:6:37:8956; 19784, 6Completed specificed action. Result: Failed 2018-02-12T11:06:38.9700485Z 2018-02-12T11:06:38.9700485Z 2018-02-12T11:06:38.9700485Z Deployment status for machine 'WSP2597C:5985' : 'Failed' 2018-02-12T11:06:39.1580077Z ##[debug]Processed: ##vso[task.logissue type=error;code={"Dtl_Sdk_Error":{"PowershellPort":5985,"Protocol":"Http","TestCertificate":false,"WinrmConnectionSucceeded":true,"Error":"The remote server returned an error: (401) Unauthorized."}};] 2018-02-12T11:06:39.1580077Z 2018-02-12T11:06:39.1610093Z 2018-02-12T11:06:39.1610093Z ##[debug]System.Exception: The remote server returned an error: (401) Unauthorized. 2018-02-12T11:06:39.1610093Z ##[error]System.Management.Automation.RuntimeException: The remote server returned an error: (401) Unauthorized. ---> System.Management.Automation.RuntimeException: The remote server returned an error: (401) Unauthorized. 2018-02-12T11:06:39.1610093Z ##[debug]Processed: ##vso[task.logissue type=error;]System.Management.Automation.RuntimeException: The remote server returned an error: (401) Unauthorized. ---> System.Management.Automation.RuntimeException: The remote server returned an error: (401) Unauthorized. 2018-02-12T11:06:39.1630092Z --- End of inner exception stack trace --- 2018-02-12T11:06:39.1630092Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input) 2018-02-12T11:06:39.1630092Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke) 2018-02-12T11:06:39.1630092Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync) 2018-02-12T11:06:39.1630092Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:39.1630092Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection1 input, PSDataCollection1 output, PSInvocationSettings settings) 2018-02-12T11:06:39.1630092Z at Microsoft.TeamFoundation.DistributedTask.Handlers.LegacyVSTSPowerShellHost.VSTSPowerShellHost.Main(String[] args) 2018-02-12T11:06:39.1720102Z ##[error]LegacyVSTSPowerShellHost.exe completed with return code: -1. 2018-02-12T11:06:39.1740084Z ##[section]Finishing: Run PowerShell on WSP2597C 2018-02-12T11:06:39.1810069Z ##[debug]Cleaning agent temp folder: D:\BA\10_work_temp 2018-02-12T11:06:39.1820086Z ##[section]Finishing: Release

anton-kirschhock commented 6 years ago

We've handled that by passing a PSObject to the webservice creation: $wsSecurePass = ConvertTo-SecureString -String $WsPassword -AsPlainText -Force

    $auth = New-Object System.Management.Automation.PSCredential -ArgumentList $WsUsername,$wsSecurePass;
    $ssrs = New-WebServiceProxy -Uri $WebserviceUrl -Credential $auth -ErrorAction Stop

Im not sure if this would help

anton-kirschhock commented 6 years ago

It looks to me more that the buildserver has no connection to the ssrs server. Verify that with your IT department and let us know

MagnusTim commented 6 years ago

It worked when we opened 1433, thanks!

/Magnus

Från: AntonK notifications@github.com Skickat: den 21 mars 2018 22:06 Till: tobania/VSTS.Extension.SqlReportingServices VSTS.Extension.SqlReportingServices@noreply.github.com Kopia: Magnus magnus@timner.se; Author author@noreply.github.com Ämne: Re: [tobania/VSTS.Extension.SqlReportingServices] Creating WebService proxy using credentials (#37)

It looks to me more that the buildserver has no connection to the ssrs server. Verify that with your IT department and let us know

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/tobania/VSTS.Extension.SqlReportingServices/issues/37#issuecomment-375095411, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AT772jcluEsYsOpqB_12nbLFrul1MODKks5tgsCmgaJpZM4R8vRn.

anton-kirschhock commented 6 years ago

Okay thanks for the feedback :)