SSRS - specified report server could not be found

  • SSRS - specified report server could not be found

    Unable to deploy SSRS report.

    Target server URL

    http://myservername/Reports_SQLEXPRESS/Pages/Folder.aspx

    ---------------------------

    Microsoft Visual Studio

    ---------------------------

    Microsoft SQL Server Report Designer

    The specified report server URL http://myservername/Reports_SQLEXPRESS/ could not be found. Verify the syntax of the URL and that the report server exists.

    ---------------------------

    OK

    ---------------------------

    Tried with localhost but same error.

    Target server URL

    http://localhost/Reports_SQLEXPRESS/Pages/Folder.aspx

    ---------------------------

    Microsoft Visual Studio

    ---------------------------

    Microsoft SQL Server Report Designer

    The specified report server URL http://localhost/Reports_SQLEXPRESS/ could not be found. Verify the syntax of the URL and that the report server exists.

    ---------------------------

    OK

    ---------------------------

    Have provided my server information's as well in the attachment.

  • Visual studio is telling you exactly what the problem is here, it can't find the server. I'm pretty sure if you navigated to http://localhost/Reports_SQLEXPRESS/[/url] you would get a "Server not found" error in your favourite web browser.

    In your post you've blurred out the Server name, but have localhost in your second image (so this tells me they are not one and the same), so you'll need to change your Project URL to SSRS URL, and ensure that SSRS is running on the destination server.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Thom A (10/5/2016)


    Visual studio is telling you exactly what the problem is here, it can't find the server. I'm pretty sure if you navigated to http://localhost/Reports_SQLEXPRESS/[/url] you would get a "Server not found" error in your favourite web browser.

    In your post you've blurred out the Server name, but have localhost in your second image (so this tells me they are not one and the same), so you'll need to change your Project URL to SSRS URL, and ensure that SSRS is running on the destination server.

    Thanks for your quick reply

    How to change the project URL. I am running on the destination server only , so i tried with local host http://localhost/Reports_SQLEXPRESS/[/url] but even it did not worked for me.

    Ensured that SSRS is running in destination server. 🙂

    I used the below link to configure SSRS. I am having same replica of below except the server name all other remain same.

    https://blogs.msdn.microsoft.com/mvpawardprogram/2014/03/10/adding-sql-server-express-2012-advanced-services-to-existing-development-environment/

  • The address you need is in your first screen shot. You've blurred it out, so I can't tell you what to enter. This needs to go in your TargetServerURl, which you currently have as localhost (which would imply you're running SQL SERVER on your own machine, which you clearly aren't).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • In order to serve business i have blurred my screen.

    That is the servername or i can say my machine name on which services is running.

    http://myservername/reports_SQLExpress

    http://localhost/reports_SQLExpress

    But when i give this URL in IE i am able see Home page as attached.

    when i use the same URL in target and deploy i am getting the error.

  • Ok, the URL you're trying to deploy to is the Report Manager URL, rather than the Web Service URL.

    You need to enter the URL displayed on your Web Service URL pane. See the highlighted URL in my screenshot.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply