Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. SSRS across Internet

SSRS across Internet

Scheduled Pinned Locked Moved Database
sql-serversysadmindatabasecomworkspace
14 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • J JM76

    Hi, thank you very much for your interest First question - have you got SSRS up and running for those on the local network, can users see reports when on the local network? Yes, inside the network everything is working fine Second question - what does 'didn't work' mean, what error messages did you get? The problem is the browser, Internet explorer can't find the web page. I don´t know what is wrong with my configuration. Thank you

    G Offline
    G Offline
    GuyThiebaut
    wrote on last edited by
    #4

    JM76 wrote:

    Internet explorer can't find the web page

    That's still not telling me the error message you receive. Are you getting a 404, what is the exact wording of the error message?

    “That which can be asserted without evidence, can be dismissed without evidence.”

    ― Christopher Hitchens

    1 Reply Last reply
    0
    • J JM76

      Hi, thank you very much for your interest First question - have you got SSRS up and running for those on the local network, can users see reports when on the local network? Yes, inside the network everything is working fine Second question - what does 'didn't work' mean, what error messages did you get? The problem is the browser, Internet explorer can't find the web page. I don´t know what is wrong with my configuration. Thank you

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #5

      JM76 wrote:

      The problem is the browser, Internet explorer can't find the web page.

      If your browser cannot open Google, is that the browsers fault? I'd first check connectivity, in particular NAT. Download a portable Apache-server and put it on USB. Start that on the machine that you are trying to reach. That way you can verify whether the computer can be found and the TCP settings/firwall/router is correct. I'm going to guess that the translation of the external IP to an internal IP is incorrect.

      Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

      J 2 Replies Last reply
      0
      • L Lost User

        JM76 wrote:

        The problem is the browser, Internet explorer can't find the web page.

        If your browser cannot open Google, is that the browsers fault? I'd first check connectivity, in particular NAT. Download a portable Apache-server and put it on USB. Start that on the machine that you are trying to reach. That way you can verify whether the computer can be found and the TCP settings/firwall/router is correct. I'm going to guess that the translation of the external IP to an internal IP is incorrect.

        Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

        J Offline
        J Offline
        JM76
        wrote on last edited by
        #6

        GuyThiebaut That's still not telling me the error message you receive. Are you getting a 404, what is the exact wording of the error message? Eddy Vluggen If your browser cannot open Google, is that the browsers fault? I'd first check connectivity, in particular NAT. Download a portable Apache-server and put it on USB. Start that on the machine that you are trying to reach. That way you can verify whether the computer can be found and the TCP settings/firwall/router is correct. I'm going to guess that the translation of the external IP to an internal IP is incorrect. Hi Mr.GuyThiebaut and Mr.Eddy Vluggen Thank you very much for your reply and sorry for my delay. Right now I´m out until the next monday. I can´t prove anything more. As soon as I come back I´m going to prove it and then I´ll reply

        1 Reply Last reply
        0
        • L Lost User

          JM76 wrote:

          The problem is the browser, Internet explorer can't find the web page.

          If your browser cannot open Google, is that the browsers fault? I'd first check connectivity, in particular NAT. Download a portable Apache-server and put it on USB. Start that on the machine that you are trying to reach. That way you can verify whether the computer can be found and the TCP settings/firwall/router is correct. I'm going to guess that the translation of the external IP to an internal IP is incorrect.

          Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

          J Offline
          J Offline
          JM76
          wrote on last edited by
          #7

          That's still not telling me the error message you receive. Are you getting a 404, what is the exact wording of the error message? If your browser cannot open Google, is that the browsers fault? I'd first check connectivity, in particular NAT. Download a portable Apache-server and put it on USB. Start that on the machine that you are trying to reach. That way you can verify whether the computer can be found and the TCP settings/firwall/router is correct. I'm going to guess that the translation of the external IP to an internal IP is incorrect. Hi Christopher & Eddy Please take a look to the following image, if you can, please try yourself. From the client I do not get any error message If you try to do a telnet, you can see this work perfectly, so this means that port forwarding is right. http://i57.tinypic.com/ms2glu.png[^]

          L 1 Reply Last reply
          0
          • J JM76

            That's still not telling me the error message you receive. Are you getting a 404, what is the exact wording of the error message? If your browser cannot open Google, is that the browsers fault? I'd first check connectivity, in particular NAT. Download a portable Apache-server and put it on USB. Start that on the machine that you are trying to reach. That way you can verify whether the computer can be found and the TCP settings/firwall/router is correct. I'm going to guess that the translation of the external IP to an internal IP is incorrect. Hi Christopher & Eddy Please take a look to the following image, if you can, please try yourself. From the client I do not get any error message If you try to do a telnet, you can see this work perfectly, so this means that port forwarding is right. http://i57.tinypic.com/ms2glu.png[^]

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #8

            JM76 wrote:

            Please take a look to the following image

            If that is a screenshot from your local network, using the outside adress, then yes, I'd expect it to not find it. From any other computer outside the network, it should be visible. It ain't from my place - something accepts the connection, but that's about it.

            Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

            J 1 Reply Last reply
            0
            • L Lost User

              JM76 wrote:

              Please take a look to the following image

              If that is a screenshot from your local network, using the outside adress, then yes, I'd expect it to not find it. From any other computer outside the network, it should be visible. It ain't from my place - something accepts the connection, but that's about it.

              Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

              J Offline
              J Offline
              JM76
              wrote on last edited by
              #9

              Hi Eddy, thank you very much!!! No, the screenshot is from outside of my network, I´m connected with another public IP. When I try connect from my network, inside the Lan, everything is fine. I don´t know what else I can try.

              L 1 Reply Last reply
              0
              • J JM76

                Hi Eddy, thank you very much!!! No, the screenshot is from outside of my network, I´m connected with another public IP. When I try connect from my network, inside the Lan, everything is fine. I don´t know what else I can try.

                L Offline
                L Offline
                Lost User
                wrote on last edited by
                #10

                I would have expected the other way around :) I can't TeamView, but if I did, the first thing I'd be doing is downloading a webserver. As soon as the external IP in a browser shows the "it works" page from Apache, I'd replace the server with another app (SSRS in your case).

                Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

                J 1 Reply Last reply
                0
                • L Lost User

                  I would have expected the other way around :) I can't TeamView, but if I did, the first thing I'd be doing is downloading a webserver. As soon as the external IP in a browser shows the "it works" page from Apache, I'd replace the server with another app (SSRS in your case).

                  Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

                  J Offline
                  J Offline
                  JM76
                  wrote on last edited by
                  #11

                  I have tried the following, Install IIS and try to access from outside, and works perfectly. Download a portable Apache-server and put it on USB. Start that on the machine that you are trying to reach. That way you can verify whether the computer can be found and the TCP settings/firwall/router is correct. I'm going to guess that the translation of the external IP to an internal IP is incorrect. Sorry Eddy, but I don´t understand what have to do. I have download xampp portable http://portableapps.com/apps/development/xampp[], but I´m a litle lost, If you can guide me ...

                  L 1 Reply Last reply
                  0
                  • J JM76

                    I have tried the following, Install IIS and try to access from outside, and works perfectly. Download a portable Apache-server and put it on USB. Start that on the machine that you are trying to reach. That way you can verify whether the computer can be found and the TCP settings/firwall/router is correct. I'm going to guess that the translation of the external IP to an internal IP is incorrect. Sorry Eddy, but I don´t understand what have to do. I have download xampp portable http://portableapps.com/apps/development/xampp[], but I´m a litle lost, If you can guide me ...

                    L Offline
                    L Offline
                    Lost User
                    wrote on last edited by
                    #12

                    JM76 wrote:

                    I don´t understand what have to do.

                    You already done it; whether it's tested with IIS or Apache makes little difference. If you can connect from the outside and see the IIS-page, then the network-settings are correct. To summarize; you have an application that servers webpages (IIS) and that is reachable from outside of the local network. You have another application (SSRS) that works correctly on the network, but does not talk to the outside world. Does SSRS require credentials? I had expected an error-message if it is missing a authentication, but I can imagine that there's some kind of "lock" on SSRS to prevent anonymous browsing of the database. Apparently it is complicated enough to write a book[^] on the subject.

                    Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

                    J 1 Reply Last reply
                    0
                    • L Lost User

                      JM76 wrote:

                      I don´t understand what have to do.

                      You already done it; whether it's tested with IIS or Apache makes little difference. If you can connect from the outside and see the IIS-page, then the network-settings are correct. To summarize; you have an application that servers webpages (IIS) and that is reachable from outside of the local network. You have another application (SSRS) that works correctly on the network, but does not talk to the outside world. Does SSRS require credentials? I had expected an error-message if it is missing a authentication, but I can imagine that there's some kind of "lock" on SSRS to prevent anonymous browsing of the database. Apparently it is complicated enough to write a book[^] on the subject.

                      Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

                      J Offline
                      J Offline
                      JM76
                      wrote on last edited by
                      #13

                      Hi Eddy Finally SOLVED!!! After reading your linkhttp://searchitchannel.techtarget.com/feature/SQL-Server-2008-Reporting-Services-for-Internet-deployment[^] All I have done, is edit the file rsreportserver.config and change the tag Authentication

                      	Off
                      	Proxy
                      	true
                      

                      After this works perfectly. Thank you very much

                      L 1 Reply Last reply
                      0
                      • J JM76

                        Hi Eddy Finally SOLVED!!! After reading your linkhttp://searchitchannel.techtarget.com/feature/SQL-Server-2008-Reporting-Services-for-Internet-deployment[^] All I have done, is edit the file rsreportserver.config and change the tag Authentication

                        	Off
                        	Proxy
                        	true
                        

                        After this works perfectly. Thank you very much

                        L Offline
                        L Offline
                        Lost User
                        wrote on last edited by
                        #14

                        You're welcome, and thanks for posting the solution :) Might save someone else some days of frustration.

                        Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

                        1 Reply Last reply
                        0
                        Reply
                        • Reply as topic
                        Log in to reply
                        • Oldest to Newest
                        • Newest to Oldest
                        • Most Votes


                        • Login

                        • Don't have an account? Register

                        • Login or register to search.
                        • First post
                          Last post
                        0
                        • Categories
                        • Recent
                        • Tags
                        • Popular
                        • World
                        • Users
                        • Groups