SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Publish SSRS 2008 in LAN


Publish SSRS 2008 in LAN

Author
Message
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2266 Visits: 1387
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
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2266 Visits: 1387
Can any one know how to do it.

Thanks!
matak
matak
Right there with Babe
Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)

Group: General Forum Members
Points: 767 Visits: 4263
As a guess you may need to turn off the firewall for the required ports on your local machine.
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2266 Visits: 1387
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!
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2266 Visits: 1387
Any suggestions for this!
matak
matak
Right there with Babe
Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)Right there with Babe (767 reputation)

Group: General Forum Members
Points: 767 Visits: 4263
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
yuvipoy
yuvipoy
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2266 Visits: 1387
I dont use IIS here.

I tried http://remotecomp it is not connected
Dung Dinh
Dung Dinh
SSChasing Mays
SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)SSChasing Mays (621 reputation)

Group: General Forum Members
Points: 621 Visits: 1233
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
Van Heghe Eddy
Van Heghe Eddy
UDP Broadcaster
UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)

Group: General Forum Members
Points: 1438 Visits: 912
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search