Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Publish SSRS 2008 in LAN Expand / Collapse
Author
Message
Posted Wednesday, February 27, 2013 11:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 281, Visits: 926
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
Post #1424923
Posted Thursday, February 28, 2013 1:53 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 281, Visits: 926
Can any one know how to do it.

Thanks!
Post #1424951
Posted Thursday, February 28, 2013 2:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:23 PM
Points: 200, Visits: 1,568
As a guess you may need to turn off the firewall for the required ports on your local machine.
Post #1424954
Posted Thursday, February 28, 2013 2:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 281, Visits: 926
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!
Post #1424956
Posted Tuesday, March 05, 2013 6:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 281, Visits: 926
Any suggestions for this!
Post #1426781
Posted Tuesday, March 05, 2013 8:35 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:23 PM
Points: 200, Visits: 1,568
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
Post #1427143
Posted Tuesday, March 05, 2013 9:15 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:08 PM
Points: 281, Visits: 926
I dont use IIS here.

I tried http://remotecomp it is not connected
Post #1427154
Posted Tuesday, March 05, 2013 9:27 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 07, 2014 12:08 AM
Points: 138, Visits: 919
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
Post #1427159
Posted Sunday, March 10, 2013 9:30 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, December 17, 2013 4:56 AM
Points: 592, Visits: 753
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
Post #1428989
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse