none
Failed to detect the specified SQL Server Reporting Services RRS feed

  • Question

  • I have Windows Vista Home Basic Service Pack 2, Visual Studio 2008 60 days trial version, SQL Server Express Edition 2008 R2, Reporting Services Installed, my Report Manager site which is http://Rogelio1:80//Reports_MSSSQL10_50 that I can access by Internet Explorer. I create a Report Server Project and added a new Report, I can test the Preview of report running with data, and is Ok, now I want to send my report to the report server in order to share it with any project, so when I define the information at "Project properties Pane" in order to deploy my report, I write at TargetServerURL field the same address that I use at Internet Explorer: http://Rogelio1:80//Reports_MSSSQL10_50, and in the next field "TargetServerVersion" I use the option:  "Detect Version..." when i click this, as a result, I receive the message: "Failed to detect the specified SQL Server Reporting Services".

    What am I doing wrong?

    Thank you for your help

    Rogelio Reyna

     


    Rogelio Reyna
    Sunday, October 10, 2010 5:39 AM

Answers

  • Hi Rogelio,

    There are two endpoints associated with Report Server. One is the Report Manager, the other the Report Server. in your example above, you are using the Report Manager URL, which will not work. Try the Report Server URL. Default URL would be http://machinename/ReportServer. Port 80 would probably be default and can be added if needed. On XP we used to default to port :8080. You might try that port if the ReportServer url does not work.


    Brad Syputa, Microsoft Reporting Services This posting is provided "AS IS" with no warranties.
    • Marked as answer by RogeReyna Wednesday, October 13, 2010 5:45 AM
    Tuesday, October 12, 2010 10:53 PM

All replies

  • Hi Rogelio,

    There are two endpoints associated with Report Server. One is the Report Manager, the other the Report Server. in your example above, you are using the Report Manager URL, which will not work. Try the Report Server URL. Default URL would be http://machinename/ReportServer. Port 80 would probably be default and can be added if needed. On XP we used to default to port :8080. You might try that port if the ReportServer url does not work.


    Brad Syputa, Microsoft Reporting Services This posting is provided "AS IS" with no warranties.
    • Marked as answer by RogeReyna Wednesday, October 13, 2010 5:45 AM
    Tuesday, October 12, 2010 10:53 PM
  • Hi Brad,

    Thank you for your help, your advice let me thought that maybe I did'nt have ReportServer or the name is another one. I verified at SQL Sever Configuration Manager and Reporting Services was enabled, saw it properties, and could not guess the name of the ReportServer, after that I started "Reporting Services Configuration Manager" and I saw the "Report Server Web Service URL" and this time I thought "This could be something similar for local service, or Why don't use it?" Ok, I used It and ¡¡It Works!! The same that is suposed to be for web service, works for my windowsforms application.

    So finally, my ReportServer URL was:  http://Rogelio1/ReportServer_MSSSQL10_50 and now I could deploy my report and use this report in another project.

    Thank's again.

    Rogelio Reyna


    Rogelio Reyna
    Wednesday, October 13, 2010 5:45 AM
  • Thanks! Your Post Helped me.

    - Subhadip

    Wednesday, February 10, 2016 1:42 AM