Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Publish SSRS 2008 in LAN
Add to briefcase

Publish SSRS 2008 in LAN Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
yuvipoy
Posted Wednesday, February 27, 2013 11:51 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 111, Visits: 516
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
yuvipoy
Posted Thursday, February 28, 2013 1:53 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 111, Visits: 516
Can any one know how to do it.

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

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

Group: General Forum Members
Last Login: Sunday, May 05, 2013 7:23 PM
Points: 133, Visits: 1,060
As a guess you may need to turn off the firewall for the required ports on your local machine.
Post #1424954
yuvipoy
Posted Thursday, February 28, 2013 2:07 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 111, Visits: 516
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
yuvipoy
Posted Tuesday, March 05, 2013 6:07 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 111, Visits: 516
Any suggestions for this!
Post #1426781
matak
Posted Tuesday, March 05, 2013 8:35 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Sunday, May 05, 2013 7:23 PM
Points: 133, Visits: 1,060
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
yuvipoy
Posted Tuesday, March 05, 2013 9:15 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 1:06 AM
Points: 111, Visits: 516
I dont use IIS here.

I tried http://remotecomp it is not connected
Post #1427154
Dung Dinh
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, May 03, 2013 8:54 AM
Points: 113, Visits: 890
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
Van Heghe Eddy
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: Thursday, March 28, 2013 9:55 AM
Points: 590, Visits: 730
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.