Wednesday, March 21, 2012

RS2005 cant'connect to server

Hi. Like some others here, I'm struggling to get a production install of
RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The
database is on a separate SQL 2005 (SP2) server. With the help of some posts
here I finally am able to browse to Report Manager and also deploy reports
from VS2005, but only when local to the report server. On my own
workstation, I get "cannot display the page" when I try to browse to Report
Manager , and "connection could not be made to the report server" when I try
to deploy reports. I checked local intranet sites in IE, and the whole
segment is allowed (set in GP) so that isn't th problem. Do you have any
ideas why I can't connect to RS from a workstation on my network? Thanks.Hi,
"cannot display the page" seems to be an IIS layer problem. To help
identifying your problem, can you
-verify url used to browse reports (http://<yourserver>/Reports)
-verify your web request reach IIS (chek logs at
c:\windows\system32\logfiles\)
-verify Http Status code send back by IIS
Jean-Pierre Riehl
http://blog.djeepy1.net
http://www.bewise.fr
"Coop" <Coop@.discussions.microsoft.com> wrote in message
news:48452325-3B31-4318-A3B5-B82F388A591A@.microsoft.com...
> Hi. Like some others here, I'm struggling to get a production install of
> RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The
> database is on a separate SQL 2005 (SP2) server. With the help of some
> posts
> here I finally am able to browse to Report Manager and also deploy reports
> from VS2005, but only when local to the report server. On my own
> workstation, I get "cannot display the page" when I try to browse to
> Report
> Manager , and "connection could not be made to the report server" when I
> try
> to deploy reports. I checked local intranet sites in IE, and the whole
> segment is allowed (set in GP) so that isn't th problem. Do you have any
> ideas why I can't connect to RS from a workstation on my network? Thanks.|||If you can browse locally (when logged into the server) then everything is
setup correctly. I think the issue here is that you have not configured
roles properly. By default if you are a member of the local administrators
group then you are in the role that allows you to deploy. RS has its own
roles, totally separate from database security. Add your user for your
workstation to the local administrator group on the server. Then give it all
a try.
Also, try fully qualify your server (I assume when local you just used
localhost). For instance try
http://servername.whatever.com/reports
My guess is this is an issue with RS roles.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jean-Pierre Riehl" <jean-pierre.riehl@.b-e-w-i-s-e.fr> wrote in message
news:41E3F7CE-1559-41D5-B5BD-26129028BC7B@.microsoft.com...
> Hi,
> "cannot display the page" seems to be an IIS layer problem. To help
> identifying your problem, can you
> -verify url used to browse reports (http://<yourserver>/Reports)
> -verify your web request reach IIS (chek logs at
> c:\windows\system32\logfiles\)
> -verify Http Status code send back by IIS
>
> --
> Jean-Pierre Riehl
> http://blog.djeepy1.net
> http://www.bewise.fr
>
> "Coop" <Coop@.discussions.microsoft.com> wrote in message
> news:48452325-3B31-4318-A3B5-B82F388A591A@.microsoft.com...
>> Hi. Like some others here, I'm struggling to get a production install of
>> RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The
>> database is on a separate SQL 2005 (SP2) server. With the help of some
>> posts
>> here I finally am able to browse to Report Manager and also deploy
>> reports
>> from VS2005, but only when local to the report server. On my own
>> workstation, I get "cannot display the page" when I try to browse to
>> Report
>> Manager , and "connection could not be made to the report server" when I
>> try
>> to deploy reports. I checked local intranet sites in IE, and the whole
>> segment is allowed (set in GP) so that isn't th problem. Do you have any
>> ideas why I can't connect to RS from a workstation on my network?
>> Thanks.
>

No comments:

Post a Comment