Urgent: <server>/ReportServer working and <server>/Reports isnt -- sql server reporting services

sql server reporting services : Urgent: <server>/ReportServer working and <server>/Reports isnt

Bofo
2/10/2005 1:08:01 PM

Hi have a problem with config.

I am tryin to deploy to a remote server. I am using SQL authentication.
I have identical usernames and password for a Windows account and a SQL
account.

When I open <server>/reportServer, after passwd auth, i get the list of
all reports and I can click on them and they are functioning.
But when I open <server>/reports, after passwd auth, i get to the Home
screen with the folder containing the reports. But when I click any
report in that page, I get a
'Cant display Page' in that frame.
----
I tried this on the server that has the reporting services, I can get
to the report but when I submit any query, I get a database error.

Would like to know what are the issues here.
The SQL server is running on the same mc as the RS

Any help will help
Thanks
Bofo

Bofo
2/10/2005 5:40:42 PM

I am unable to find whats causing the problem.

1. All reports working when I browse them on the server machine.
2. When I try to access http://<server>/reports, I am prompted for a
passwd/user
I enter an username/passwd that has admin priv on Windows and also dba
admin on the SQL server
3. I pass that phase and go on to see the firstpage of the reports
which shows a folder containing all the reports.
I can view and change all links like the properties, security etc.
4. When I clic any report .rdl file, I get the browser page 'action
cancelled' IE message.

The SQL database is using the mixed mode of auth

----------
But I can access all the reports from my machine when i use the
http://<server>/reportserver URL.

Has anyone faced such a problem

Thanks
Bofo

RemoteDeploy
2/11/2005 7:40:30 AM

it is using a sql account. But not a very strong passwd as I am using
it as a test.

Its seems the problem is with that the explorer not finding the URL, or
searching in wrong places.
I dont get see any SQL or RS error messages. All I see is an action
cancelled page in IE.

The RS is residing on a Server within a DMZ. We connect to it using a
NAT IP (i presume) and not its actual IP.

In that case how is the <servername>/Reportserver working perfectly
fine ?

Do I need to configure the Remote Routing access service on the server
? But donno how to configure.
Arrrrgghh....

Bofo

RemoteDeploy
2/11/2005 8:01:52 AM

http://<server>/Reports/Pages/Report.aspx?ServerUrl=

The above is the URL its trying to reach and seems like its expecting a
server URL.
Looking at the config files to see if any problem

ECathell
2/11/2005 8:02:42 AM

what's the authentication scheme for the shared datasource?

I have found that its best to make the datasource use a sql account with a
strong password that has read or execute permissions where needed.

--
--Eric Cathell, MCSA
[quoted text, click to view]

Bofo
2/11/2005 8:11:08 AM

SOLVED !

I changed the ServerURL in the RSWebapp.config from
servername/Reportserver to
<server-ip>/reportserver.
I thought about this last night but I had another installation working
fine with the servername.

bofo

ECathell
2/11/2005 11:17:32 AM

thats leads me to believe you have a DNS issue....

--
--Eric Cathell, MCSA
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn