all groups > sql server reporting services > july 2007 >
You're in the

sql server reporting services

group:

RS2005 cant'connect to server


RS2005 cant'connect to server Coop
7/27/2007 4:40:00 PM
sql server reporting services:
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
Re: RS2005 cant'connect to server Jean-Pierre Riehl
7/29/2007 12:00:00 AM
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


[quoted text, click to view]
Re: RS2005 cant'connect to server Bruce L-C [MVP]
7/29/2007 3:12:10 PM
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

[quoted text, click to view]

AddThis Social Bookmark Button