Report Manager Unavailable

Installed SRS 2k on a Windows 2003 sp2 machine.
SQL 2k installed, running, Report Server databased got created.
No errors during installation but two odd issues came up.
First, we can access the reportserver page via http://localhost/reportserver
but Report Manager via http://localhost/reports errors with a 404
(with report manager color scheme). It does append the /pages/
folder.aspx to the typed address.
Event viewer does show an Report Manager Event 114 which appears to
equate to "Report Manager cannot connect to the ReportServer service"
checked and the SRS service is running.
Not sure what else to look for.
Second and maybe related: http://localhost/reportserver works but
http://servername/reportserver is not recognized - it goes to an under
construction page. The RSWebApplication.config file has
<ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
I can ping localhost, servername and IP address with success.
Have uninstalled SRS, removed databases and reinstalled same issues.
Any ideas? Thanks for your help.Just in case it helps somebody down the road...
Problem was another website on the server using port 80. Change web
site report manager was using to a different port via IIS and it
worked.
http://webservername:99/reports

Report Manager error with OK button

I'm just installed SQL Reporting Services 2000 with SP2 on a Windows Server
2003 box that is fully patched.
I have the .net framework v1.1 installed and running. My issue is that when
I try to either add roles or modify anything in the site settings the OK
button does nothing. The cancel button seems to work find. However
anywhere in any screen that you see the Ok button is there..just not
clickable.
Please help.
--
Report DeveloperThis sort of thing is usually because anonymous security has been assigned
for IIS. If that is the case then everyone is the same identity when logged
in, i.e. there is no administrator. Have you done anything like that with
your site?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:FC320F8E-DAA6-4B85-93A3-93DC3F9B6DA0@.microsoft.com...
> I'm just installed SQL Reporting Services 2000 with SP2 on a Windows
> Server
> 2003 box that is fully patched.
> I have the .net framework v1.1 installed and running. My issue is that
> when
> I try to either add roles or modify anything in the site settings the OK
> button does nothing. The cancel button seems to work find. However
> anywhere in any screen that you see the Ok button is there..just not
> clickable.
> Please help.
> --
> Report Developer|||You nailed that one. At first I did have anoynmous access to the site
enabled..However I have since disabled that...
People currently in the local administrators group have the access to create
folders etc..However people who are not only see the home folder and the My
Subscriptions..
--
Report Developer
"Bruce L-C [MVP]" wrote:
> This sort of thing is usually because anonymous security has been assigned
> for IIS. If that is the case then everyone is the same identity when logged
> in, i.e. there is no administrator. Have you done anything like that with
> your site?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Matt" <Matt@.discussions.microsoft.com> wrote in message
> news:FC320F8E-DAA6-4B85-93A3-93DC3F9B6DA0@.microsoft.com...
> > I'm just installed SQL Reporting Services 2000 with SP2 on a Windows
> > Server
> > 2003 box that is fully patched.
> >
> > I have the .net framework v1.1 installed and running. My issue is that
> > when
> > I try to either add roles or modify anything in the site settings the OK
> > button does nothing. The cancel button seems to work find. However
> > anywhere in any screen that you see the Ok button is there..just not
> > clickable.
> >
> > Please help.
> > --
> > Report Developer
>
>|||It sounds like you do not have any security setup. RS uses roll based
security. This is what I do. Create a local group on the RS machine, I call
it Reports. To this group add any individual users or domain groups etc that
you want. This group is for browse only. You can have other groups for other
rights but to start off with you want to have a group that the users can
view and run reports. Then you go to the home of report managers,
properties, click on New Role assignment, group or username put in Reports
(or whatever you called the group when you created it). Check the box that
says browse.
When you do this from home all folders underneath will inherit this role. If
you have a particular folder that you don't want to have that group to have
access then you can go to that folder and modify the permission.
Hopefully that will get you in the right direction.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:F4C40FA5-D505-4906-A519-85834D382ABF@.microsoft.com...
> You nailed that one. At first I did have anoynmous access to the site
> enabled..However I have since disabled that...
> People currently in the local administrators group have the access to
create
> folders etc..However people who are not only see the home folder and the
My
> Subscriptions..
> --
> Report Developer
>
> "Bruce L-C [MVP]" wrote:
> > This sort of thing is usually because anonymous security has been
assigned
> > for IIS. If that is the case then everyone is the same identity when
logged
> > in, i.e. there is no administrator. Have you done anything like that
with
> > your site?
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Matt" <Matt@.discussions.microsoft.com> wrote in message
> > news:FC320F8E-DAA6-4B85-93A3-93DC3F9B6DA0@.microsoft.com...
> > > I'm just installed SQL Reporting Services 2000 with SP2 on a Windows
> > > Server
> > > 2003 box that is fully patched.
> > >
> > > I have the .net framework v1.1 installed and running. My issue is
that
> > > when
> > > I try to either add roles or modify anything in the site settings the
OK
> > > button does nothing. The cancel button seems to work find. However
> > > anywhere in any screen that you see the Ok button is there..just not
> > > clickable.
> > >
> > > Please help.
> > > --
> > > Report Developer
> >
> >
> >

Report Manager

I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
running for several months and quit running day before yesterday(?). I
have reinstalled, etc. and it appears to be running (there are no errors in
the logs). I re-deployed the reports from VS (no errors) and can see report
entries in the Report Server database. I have run rsconfigure to connect
using the SA account. The database name and folders are the defaults.
The issue: When I display Report Manager, no reports display and no errors.
Just the page header.
What can be causing this?check your security settings.
your anonymous and or integrated security are screwed up. that's why you
can't see anything at all.
"TACIR" wrote:
> I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> running for several months and quit running day before yesterday(?). I
> have reinstalled, etc. and it appears to be running (there are no errors in
> the logs). I re-deployed the reports from VS (no errors) and can see report
> entries in the Report Server database. I have run rsconfigure to connect
> using the SA account. The database name and folders are the defaults.
> The issue: When I display Report Manager, no reports display and no errors.
> Just the page header.
> What can be causing this?
>|||I set Anonymous (& Integrated Windows) on Report Server and Reports. Then
Report Server didn't work - without Anonymous it displays the directories and
reports ok. Reports still didn't display any of the reports.
"letuce dance" wrote:
> check your security settings.
> your anonymous and or integrated security are screwed up. that's why you
> can't see anything at all.
> "TACIR" wrote:
> > I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> > running for several months and quit running day before yesterday(?). I
> > have reinstalled, etc. and it appears to be running (there are no errors in
> > the logs). I re-deployed the reports from VS (no errors) and can see report
> > entries in the Report Server database. I have run rsconfigure to connect
> > using the SA account. The database name and folders are the defaults.
> > The issue: When I display Report Manager, no reports display and no errors.
> > Just the page header.
> > What can be causing this?
> >
> >|||It's kind of goofy.
turn anonymous off.
then go into properties tab on the report manager interface
setup a user machinename\iusr_machinename as the browser,content manager, my
reports, publisher
then you can turn anonymous back on if you want.
this way you will be able use anonymous access to your reporting server.
Not very secure because everybody will be able to access it; but if it's for
development what the heck.
like I said it's kinda goofy but if you think about what's going on and why
it makes sense once you understand things.
"TACIR" wrote:
> I set Anonymous (& Integrated Windows) on Report Server and Reports. Then
> Report Server didn't work - without Anonymous it displays the directories and
> reports ok. Reports still didn't display any of the reports.
> "letuce dance" wrote:
> > check your security settings.
> >
> > your anonymous and or integrated security are screwed up. that's why you
> > can't see anything at all.
> >
> > "TACIR" wrote:
> >
> > > I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> > > running for several months and quit running day before yesterday(?). I
> > > have reinstalled, etc. and it appears to be running (there are no errors in
> > > the logs). I re-deployed the reports from VS (no errors) and can see report
> > > entries in the Report Server database. I have run rsconfigure to connect
> > > using the SA account. The database name and folders are the defaults.
> > > The issue: When I display Report Manager, no reports display and no errors.
> > > Just the page header.
> > > What can be causing this?
> > >
> > >|||But - how do I get a report manager interface to work with' On I-Explorer
all it shows is the Home page header. Do you know the default that is used?
Guess I should be able to do it in the Web.config file but don't know the
syntax.
Since Report Server shows the reports, Report Manager is not getting
connecting to Report Server somehow.
I have Authentication = Windows and Impersonation = False in both Web.config
files.
"Everyone" has Windows Full Control on the Reporting Services directory.
"letuce dance" wrote:
> It's kind of goofy.
> turn anonymous off.
> then go into properties tab on the report manager interface
> setup a user machinename\iusr_machinename as the browser,content manager, my
> reports, publisher
> then you can turn anonymous back on if you want.
> this way you will be able use anonymous access to your reporting server.
> Not very secure because everybody will be able to access it; but if it's for
> development what the heck.
> like I said it's kinda goofy but if you think about what's going on and why
> it makes sense once you understand things.
> "TACIR" wrote:
> > I set Anonymous (& Integrated Windows) on Report Server and Reports. Then
> > Report Server didn't work - without Anonymous it displays the directories and
> > reports ok. Reports still didn't display any of the reports.
> >
> > "letuce dance" wrote:
> >
> > > check your security settings.
> > >
> > > your anonymous and or integrated security are screwed up. that's why you
> > > can't see anything at all.
> > >
> > > "TACIR" wrote:
> > >
> > > > I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> > > > running for several months and quit running day before yesterday(?). I
> > > > have reinstalled, etc. and it appears to be running (there are no errors in
> > > > the logs). I re-deployed the reports from VS (no errors) and can see report
> > > > entries in the Report Server database. I have run rsconfigure to connect
> > > > using the SA account. The database name and folders are the defaults.
> > > > The issue: When I display Report Manager, no reports display and no errors.
> > > > Just the page header.
> > > > What can be causing this?
> > > >
> > > >|||Well this all started with applying the latest Windows security (10/15/2005)
updates.
1. Removed the updates
2. Uninstalled/reinstalled Reporting Services - after working through
several errors finally deleted the entry from the Key table in Reporting
Services database.
3. Ran RSConfigure, RsActivate
4. Redeployed the DataSource and everything worked again.
Applied the Windows security updates again. Reporting Services broke again.
1. Deleted the entries from the Key table
2. Ran RSconfigure, RSActivate
3. Redeployed the DataSource and everything worked again.
"TACIR" wrote:
> But - how do I get a report manager interface to work with' On I-Explorer
> all it shows is the Home page header. Do you know the default that is used?
> Guess I should be able to do it in the Web.config file but don't know the
> syntax.
> Since Report Server shows the reports, Report Manager is not getting
> connecting to Report Server somehow.
> I have Authentication = Windows and Impersonation = False in both Web.config
> files.
> "Everyone" has Windows Full Control on the Reporting Services directory.
> "letuce dance" wrote:
> > It's kind of goofy.
> >
> > turn anonymous off.
> >
> > then go into properties tab on the report manager interface
> >
> > setup a user machinename\iusr_machinename as the browser,content manager, my
> > reports, publisher
> >
> > then you can turn anonymous back on if you want.
> >
> > this way you will be able use anonymous access to your reporting server.
> > Not very secure because everybody will be able to access it; but if it's for
> > development what the heck.
> >
> > like I said it's kinda goofy but if you think about what's going on and why
> > it makes sense once you understand things.
> > "TACIR" wrote:
> >
> > > I set Anonymous (& Integrated Windows) on Report Server and Reports. Then
> > > Report Server didn't work - without Anonymous it displays the directories and
> > > reports ok. Reports still didn't display any of the reports.
> > >
> > > "letuce dance" wrote:
> > >
> > > > check your security settings.
> > > >
> > > > your anonymous and or integrated security are screwed up. that's why you
> > > > can't see anything at all.
> > > >
> > > > "TACIR" wrote:
> > > >
> > > > > I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> > > > > running for several months and quit running day before yesterday(?). I
> > > > > have reinstalled, etc. and it appears to be running (there are no errors in
> > > > > the logs). I re-deployed the reports from VS (no errors) and can see report
> > > > > entries in the Report Server database. I have run rsconfigure to connect
> > > > > using the SA account. The database name and folders are the defaults.
> > > > > The issue: When I display Report Manager, no reports display and no errors.
> > > > > Just the page header.
> > > > > What can be causing this?
> > > > >
> > > > >

Report Headers

I'm using VS 2003 and SQL Server 2000 Reporting Services SP2.
I haven't found anything in Reporting Services that lets me create a report
header (a header that shows up only on the first page of a report) but am
wondering if there is some method of making the page header visible on the
first page and invisible on all others.
Thanks.
JonDon't use the header, but simply start the report with it
"Jon Limmer" wrote:
> I'm using VS 2003 and SQL Server 2000 Reporting Services SP2.
> I haven't found anything in Reporting Services that lets me create a report
> header (a header that shows up only on the first page of a report) but am
> wondering if there is some method of making the page header visible on the
> first page and invisible on all others.
> Thanks.
> Jon
>
>|||You're kidding! That easy!! Cool!
and thanks...
Jon
"Antoon" <Antoon@.discussions.microsoft.com> wrote in message
news:51F10004-77A6-4061-91B3-3F8E58347B9E@.microsoft.com...
> Don't use the header, but simply start the report with it
>