Code Monkey home page Code Monkey logo

Comments (7)

mmajcica avatar mmajcica commented on June 2, 2024 1

So there is something wrong with the authorization.

from deployssrs.

dabrantkosky avatar dabrantkosky commented on June 2, 2024

Same error.
In one network works fine, but in the other one returns an error for every application deployment.

from deployssrs.

mmajcica avatar mmajcica commented on June 2, 2024

Make sure that the connectivity is in place. Tasks run on the agents. Agent needs to be in possibility to reach the server on the port you have set your SSRS Web Server to replay. Judging by the URL, it is running on HTTP. Can your agent reach your server on the port 80?

from deployssrs.

dabrantkosky avatar dabrantkosky commented on June 2, 2024

Make sure that the connectivity is in place. Tasks run on the agents. Agent needs to be in possibility to reach the server on the port you have set your SSRS Web Server to replay. Judging by the URL, it is running on HTTP. Can your agent reach your server on the port 80?

Seems all in order. I have set the port 80 in my URL http://server.am.devnet.com:80/ReportServer_RPS_DEV_01/ReportService2010.asmx

Agent has access to the server, i can reach SSRS server from the browser inside the agent server, i ran a ping command and it's also working.

I'm using SQL authentication.

from deployssrs.

mmajcica avatar mmajcica commented on June 2, 2024

The task is a simple powershell script that tries to access the SSRS via HTTP. Two things can go wrong, or the connectivity is missing or the authentication is off.

Considering you have the access to the server I believe you are on an self hosted agent.

Can you do the following?

$username = "yourUserName"
$password = "yourpwd"
$url = "http://server.am.devnet.com:80/ReportServer_RPS_DEV_01/ReportService2010.asmx"

$securePassword = ConvertTo-SecureString -String $password -asPlainText -Force
        $credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $username, $securePassword
        
        $proxy = New-WebServiceProxy -Uri $url -Namespace SSRS.ReportingService2010 -Credential $credential -Class "SSRS"

where the $url is the address of your SSRS webservice and $username and $password are correctly set.

Are you able to create the proxy object without errors?

If not, what are the errors reported?

Btw this is the same what the task does

$proxy = New-WebServiceProxy -Uri $url -Namespace SSRS.ReportingService2010 -UseDefaultCredential -Class "SSRS"

from deployssrs.

dabrantkosky avatar dabrantkosky commented on June 2, 2024

The task is a simple powershell script that tries to access the SSRS via HTTP. Two things can go wrong, or the connectivity is missing or the authentication is off.

Considering you have the access to the server I believe you are on an self hosted agent.

Can you do the following?

$username = "yourUserName"
$password = "yourpwd"
$url = "http://server.am.devnet.com:80/ReportServer_RPS_DEV_01/ReportService2010.asmx"

$securePassword = ConvertTo-SecureString -String $password -asPlainText -Force
        $credential = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $username, $securePassword
        
        $proxy = New-WebServiceProxy -Uri $url -Namespace SSRS.ReportingService2010 -Credential $credential -Class "SSRS"

where the $url is the address of your SSRS webservice and $username and $password are correctly set.

Are you able to create the proxy object without errors?

If not, what are the errors reported?

Btw this is the same what the task does

$proxy = New-WebServiceProxy -Uri $url -Namespace SSRS.ReportingService2010 -UseDefaultCredential -Class "SSRS"

2020-10-06T19:03:33.8579937Z New-WebServiceProxy : The request failed with HTTP status 401: Unauthorized.
2020-10-06T19:03:33.8581271Z At C:\Agent_work_temp\10ea2031-2fdc-4cea-9fbe-5af9357319a8.ps1:10 char:18
2020-10-06T19:03:33.8581980Z + ... $proxy = New-WebServiceProxy -Uri $url -Namespace SSRS.ReportingSe ...
2020-10-06T19:03:33.8582650Z + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2020-10-06T19:03:33.8583400Z + CategoryInfo : ObjectNotFound: (http://saov1705...ervice2010.asmx:Uri) [New-WebServiceProxy], WebExcept
2020-10-06T19:03:33.8584819Z ion
2020-10-06T19:03:33.8585345Z + FullyQualifiedErrorId : WebException,Microsoft.PowerShell.Commands.NewWebServiceProxy
2020-10-06T19:03:33.9412689Z ##[error]PowerShell exited with code '1'.
2020-10-06T19:03:33.9899272Z ##[section]Finishing: PowerShell Script

from deployssrs.

dabrantkosky avatar dabrantkosky commented on June 2, 2024

So there is something wrong with the authorization.

I don't have the credentials, so maybe someone entered them wrong on the Library, i'll check this and will be back.

Thanks!


Edit: @mmajcica It really was a problem with the account on SSRS Server. Is it possible to update the task to return a more specific error about authentication other than " ##[error]There was an error downloading"?
Also, thank you for your help! :)

from deployssrs.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.