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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 7:03 AM
Points: 336, Visits: 1,154
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 7:03 AM
Points: 336, Visits: 1,154
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 @ 9:35 PM
Points: 227, Visits: 1,995
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 7:03 AM
Points: 336, Visits: 1,154
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 5, 2013 6:07 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 7:03 AM
Points: 336, Visits: 1,154
Any suggestions for this!
Post #1426781
Posted Tuesday, March 5, 2013 8:35 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:35 PM
Points: 227, Visits: 1,995
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 5, 2013 9:15 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 7:03 AM
Points: 336, Visits: 1,154
I dont use IIS here.

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

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

Group: General Forum Members
Last Login: Yesterday @ 8:37 AM
Points: 141, Visits: 967
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
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, September 1, 2014 11:26 AM
Points: 647, Visits: 762
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