question

WilliamD avatar image
WilliamD asked

Cannot connect to Report Server from client through Internet Explorer

Hi. I have just installed SQL Server 2008 Enterprise (SP1) on Windows 2008 Standard and have setup Reporting Services using the Reporting Services Configuration Manager. The Service Account for SSRS is a domain user (admin privileges) and the remaining settings are the defaults (port 80, no SSL). Once the setup was complete, I tested SSRS by connecting to http://machinename/ReportServer and http://machinename/Reports with IExplorer and SSMS locally on the machine and everything seemed fine. As soon as I try connecting from another machine, I wait for the authentication request but it never appears and I get an error "Internet Explorer cannot display the webpage" after about 20 seconds. I have tried connecting to http://ipaddress/Reports or http://ipaddress/ReportServer but get the same error. Does anyone have any ideas what could be wrong? I have not setup IIS, because I believe that SSRS in Sql 2008 doesn't need IIS anymore, right? Many thanks for any ideas.
sql-server-2008ssrsconnection
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
A shot in the dark... Firewall???
3 Likes 3 ·
WilliamD avatar image WilliamD commented ·
Bang.... you got it - thanks! I love it when the answer is so obvious answer and you still can't think of it yourself. Couldn't see the wood for the trees. Post it as an answer and I'll give you the points.
0 Likes 0 ·
sp_lock avatar image
sp_lock answered
William check your firewall... Normally the case ha ;-)
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
done and done :o)
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered
open the SSRS Configuration Manager doohicky and check the Report Manager URL value. Its actually a clickable hyperlink that should take you to the RM home page. If it works on the server copy|paste to other client. If that fails then Jonlee's shot may well be on target
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.