cancel
Showing results for 
Search instead for 
Did you mean: 

can't access sql reports remotely

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

it's not technically an EV issue but since it's preventing me from installing DA reports i thought maybe someone else on the board has run into this. basically, SQL and SSRS are installed on the same server. it's a single server with a single SQL instance. the reports come up fine when accessed locally but accessing them via http://sqlserver/reports from another server, while logged in as the VSA, returns with a http 401 error code. this same code is what we get when trying to install the DA reports which is supposed to "push" them from the DA server to the SRS server.

1 ACCEPTED SOLUTION

Accepted Solutions

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

turned out to be a gpo/permissions issue and was fixed by the customer. thanks for everyone's input.

View solution in original post

12 REPLIES 12

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

Can you access it via the other url?  It will be something like http://sqlserver/reportserver

JesusWept3
Level 6
Partner Accredited Certified

wonder if its something like this?
http://blogs.msdn.com/lukaszp/archive/2008/07/18/reporting-services-http-401-unauthorized-host-headers-require-your-attention.aspx

 

https://www.linkedin.com/in/alex-allen-turl-07370146

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

locally yes but remotely that one doesnt work either.

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

i did forget to mention SQL and SRS 2008 R2.

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

thanks JW. i'll check this out and see what we can do considering that now we have production SQL databases on there it might take some time to make the changes and reboots.

Ameen
Level 6

I feel you might have checked this but for making sure, from IIS did you confirm that 'integrated Authentication' is checked on the security tab from the properties on 'report'

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

are you sure about that? i dont have IIS installed as a role or feature on the server (windows 2008 r2, sql 2008 r2, SSRS 2008 r2)

JesusWept3
Level 6
Partner Accredited Certified

huh?
You have SSRS installed on a server that doesn't have IIS installed?

https://www.linkedin.com/in/alex-allen-turl-07370146

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

yup that's exactly how it appears to be installed

JesusWept3
Level 6
Partner Accredited Certified

ok so which server DOES have IIS installed and hosts the reports and reportserver virtual directories?

https://www.linkedin.com/in/alex-allen-turl-07370146

JesusWept3
Level 6
Partner Accredited Certified

never mind, i researched it and SSRS installs stand alone components like httpsys to do web hosting for the reports and doesnt require IIS

https://www.linkedin.com/in/alex-allen-turl-07370146

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

turned out to be a gpo/permissions issue and was fixed by the customer. thanks for everyone's input.