Post reply

Publish SSRS 2008 in LAN

  • February 27, 2013 at 11:51 pm

    #269138

    How to publish SSRS for internal alone.

    I have a project which needs to be circulated only to my team members using my hostname.

    What are the steps to deploy them.

    now i am able to do with

    http://localhost/Reports

    http://myhost-name/Reports

    where as if i see in another machine http://myhost-name/Reports i am unable to get the details.

    Thanks

  • February 28, 2013 at 1:53 am

    #1591902

    Can any one know how to do it.

    Thanks!

  • February 28, 2013 at 2:00 am

    #1591905

    As a guess you may need to turn off the firewall for the required ports on your local machine.

  • February 28, 2013 at 2:07 am

    #1591906

    I am able to take remote from another machine.

    Say Server A is my machine Server B is another machine i am able to take server A machine from server B and visa-versa.

    Server A is the machine where the SSRS is placed.

    Thanks!

  • March 5, 2013 at 6:07 am

    #1593436

    Any suggestions for this!

  • March 5, 2013 at 8:35 pm

    #1593743

    First thing i would do is try to access the remote computer via a browser

    http://remotecomp --if this fails then you have either iis/firewall issues

    This will tell you if iis is setup ok and if there are any firewall issues.

    Then you will probably want to go to

    http://remotecomp/reportserver (i think) - this should give you a directory listing of your reports --if this fails you have a problem with your reporting services

  • March 5, 2013 at 9:15 pm

    #1593752

    I dont use IIS here.

    I tried http://remotecomp it is not connected

  • March 5, 2013 at 9:27 pm

    #1593754

    yuvipoy (2/27/2013)

    How to publish SSRS for internal alone.

    I have a project which needs to be circulated only to my team members using my hostname.

    What are the steps to deploy them.

    now i am able to do with

    http://localhost/Reports

    http://myhost-name/Reports

    where as if i see in another machine http://myhost-name/Reports i am unable to get the details.

    Thanks

    In case, you're able to remote your local from another one, please check Authentication Configuration in SSRS

    1- Check info in Reporting Services Configuration Manager

    2- Check Authentication Mode

    3- Check Users\GroupUser which you allow to access SSRS are from trusted domain

    http://www.sqlmag.com/article/sql-server-reporting-services-ssrs/understanding-sql-server-reporting-services-authentication-141280

  • March 10, 2013 at 9:30 am

    #1595306

    Also check in the SSRs config file.

    Probably the localhost name is used there in stead of teh hostname.

    Normally you can alter this config file with the GUI from configuration manager, but i also have found that the modifications in this are not always saved.

    So these steps should be performed then:

    Stop SSRs services

    find the config file in the SSRs installed directorie , normally C:\program files\ms sqlserver\sqlversion\..

    Don't have the exact path @ hand but i remember the directoryname was so obvious like SSRs you dont really need it.

    take a copy of the config file just in case..

    Open the config file in wordpas or so and search for the 'hostname' value.

    Change to the computername

    Save the file

    Start SSRs services

    Try again.

    Wkr,

    Eddy

Viewing 9 posts - 1 through 8 (of 8 total)

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