report pack for iis - report generation taking long?

I've got this installed and the sample database was working fine. I then
imported about a weeks worth from two iis servers (grew the DB to about 5
GB) and now pulling up any of the default 12 reports takes at least 30
minutes to an hour or longer. Is this normal? The SQL server is a dual
xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
Services SP2.Try to do a select of the same data and see how long it takes...RS will be
slower than that of course - but will not be faster than your select when it
queries the data..
Ensure you have properly indexed tables.
You may also wish to run the query on a schedule and deliver it from cache -
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Joe" <joe@.do.not.email.me> wrote in message
news:%23%234FpU4qFHA.248@.TK2MSFTNGP14.phx.gbl...
> I've got this installed and the sample database was working fine. I then
> imported about a weeks worth from two iis servers (grew the DB to about 5
> GB) and now pulling up any of the default 12 reports takes at least 30
> minutes to an hour or longer. Is this normal? The SQL server is a dual
> xeon, 2 GB of RAM, 3 disk (15k rpm) raid 5 with SQL 2000 SP3 and Reporting
> Services SP2.
>

Report manager will not connect

I have moved the sites from the default sites to another website that all
ready had a cert installed. I have changed the config files in both report
manager and reportserver to point to https://website/reportserver for the
url. The reportserver site works but I get an error on the reportmanager site:
The underlying connection was closed: Unable to connect to the remote server.
This site did work while it was on the default site under port 80.
-DanI'm having the same problem with an SBS server. Did you ever find a solution
for this?
"Dan C." wrote:
> I have moved the sites from the default sites to another website that all
> ready had a cert installed. I have changed the config files in both report
> manager and reportserver to point to https://website/reportserver for the
> url. The reportserver site works but I get an error on the reportmanager site:
> The underlying connection was closed: Unable to connect to the remote server.
> This site did work while it was on the default site under port 80.
> -Dan

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 shows a blank page

Hi all. My name is Guilherme and I'm a Braziliam software developer.

I've installed on my computer all the software required to work with MS SQL RS. I log on this computer using my domain user. and a few days ago i needed to change my password (network policy)

Now, when I open the adress http://localhost/reports on my computer, I can't see the installed reports, neither the configuration page.

What should I do?

Thanks in advance.

My guess is that you haven't set up any rights to root folder..

In Server Management Studio you can give your user administration access..

report manager problem

I have installed SQL 2005 reporting services and I configured it using
Reporting Services Configuration. Now I tried to access to report manager
using http://servername/Reports with login I used to start reporting
services. It doesn't work and keep prompting me for login and password. But
no use and I am sure this login is correct and password correct and it
started the reportings services successfully. Can anyone please help how to
solve this problem. Thanks.What kind of authenticate are you using ?
SQL Based or Windows bases.
Check if the user is allow to open the report database in the SQL Server .
Ritchie
"00 Hillary" wrote:
> I have installed SQL 2005 reporting services and I configured it using
> Reporting Services Configuration. Now I tried to access to report manager
> using http://servername/Reports with login I used to start reporting
> services. It doesn't work and keep prompting me for login and password. But
> no use and I am sure this login is correct and password correct and it
> started the reportings services successfully. Can anyone please help how to
> solve this problem. Thanks.
>
>|||I am using SQL Based authentication. What of right should I check with the
report database? Thanks.
"Ritchie" <Ritchie@.discussions.microsoft.com> wrote in message
news:AB1B5866-9539-410F-9BFC-A57FF8CC28B5@.microsoft.com...
> What kind of authenticate are you using ?
> SQL Based or Windows bases.
> Check if the user is allow to open the report database in the SQL Server .
> Ritchie
>
> "00 Hillary" wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report manager
>> using http://servername/Reports with login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>>

Report manager home page erroring with an invalid character.

I have a 2003 server with IIS 6.0, SQL Server 2005, Analysis Services 2005,
and Reporting Services 2005 installed. I can create new reports and publish
them. If I go to //localhost/reportserver I can get to the reports and they
will come up. However, if I go to //localhost/Reports I get a message
stating that the XML page cannot be displayed.
A name was started with an invalid character. Error processing resource
'http://localhost/Reports/home.aspx' Line 1, Posi...
<%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.HomePag...
I tried uninstalling and re-installing reporting services but I get the same
error. Any thoughts?Luke,
All you have to do is open the IIS MMC and then right click the
"reports" virtual directory, select property and then under the
ASP.NET tab select asp.net version that belongs to the .NET framework
version 2. For some reason, after you installed reporting services,
the version of the ASP.NET was removed from the asp.net tab.
Dave Luna.
Luke wrote:
> I have a 2003 server with IIS 6.0, SQL Server 2005, Analysis Services 2005,
> and Reporting Services 2005 installed. I can create new reports and publish
> them. If I go to //localhost/reportserver I can get to the reports and they
> will come up. However, if I go to //localhost/Reports I get a message
> stating that the XML page cannot be displayed.
> A name was started with an invalid character. Error processing resource
> 'http://localhost/Reports/home.aspx' Line 1, Posi...
> <%@. Page language="c#" Codebehind="Home.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.HomePag...
> I tried uninstalling and re-installing reporting services but I get the same
> error. Any thoughts?

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 error "scale-out deployment not supported in this edition of Reporting Servi

Hi,

I have been trying to get report services installed but another error came:

The feature: "Scale-out deployment" is not supported in this edition of Reporting Services. (rsOperationNotSupported) (rsRPCError)

This error comes when I try to view either http://localhost/Reports or http://localhost/reportserver

Any suggestions?

thank you.

Can you tell us a little more about what you are trying to accomplish? What version of REporting Services are you trying to install. ARe you trying to set up a webfarm?

Thanks,

|||

I have given up of setting the Reporting Services.

Seems that I am not running the correct SQL version to use reporting services. I have express edition with advanced settings.

Basically I just wanted to run everything on the same computer.

Report Manager error

Some weeks back I successfully installed SQL Server RS SP1 on a Win2K Server
(note it is NOT a domain controller). All worked fine.
Recently, following a restart of the machine, I get the following error:
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\bin" is denied.
I have read numerous posts on this issue. Some suggest the documented
workaround IF the server is a DC. All other posts don't appear to have been
resolved.
I have granted full control to Everyone for the ReportManager and bin
folders but to no effect.
Has anyone encountered the fix for this issue?
Thanks.For anyone that might have stumbled on to this post... I found the solution -
eventually.
Check out the "Impersonate a client after authentication" local policy. The
local ASPNET account must be included. In my case a domain policy was
overriding the local policy.

report manager datasources

RS is installed on a 64 bit system. I am pulling my data from Foxpro. I can
get it fine in the report designer, but when deployed to the Report Manager
it wont work....Any ideas or workarounds?Is the datasource shared? If so - are the details correct?
If the data source is custom, does the user running the report have
permission?
"Ben" wrote:
> RS is installed on a 64 bit system. I am pulling my data from Foxpro. I can
> get it fine in the report designer, but when deployed to the Report Manager
> it wont work....Any ideas or workarounds?

Report Manager Config Issue

Greetings,

*Microsoft Windows Server 2003

*MSSQL Server 2005 (with reporting services installed)

I have found a configuration issue after setting up the virtual directorties for the report service and report manager.

The reporting virtual directories are assigned to a non default website and the assigned site has a defined IP Address other than the machines assigned IP.

The Reporting Services Configuration Manager Created the virtual directories properly but there seems to be a problem with it reconizing a non-default IP Address for the site the reporting services directories are created under. Because I get -

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

When I open C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\RSWebApplication.config I see the following -

<UI>

<ReportServerUrl></ReportServerURL>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

I tried

<ReportServerUrl>http://<Site IP Address>/</ReportServerURL>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

and

<ReportServerUrl>http://<Site IP Address>/ReportServer</ReportServerURL>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Still no luck - any suggestions?

Nevermind Figured it out -

<ReportServerUrl>http://<Site IP Address>/ReportServer</ReportServerURL>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Works - just did not recycle the application pools in IIS. By the way if you are configuring the manager for a non-default IP address be carefull. For some reason the report manager does not like a <ReportServerVirtualDirectory> value if <ReportServerURL> is supplied.

Report Manager Config Error

Hi;
I just installed RS and it seemed to go ok. But when I try to access the Report Manager at localhost\reports, I get the following error:
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: The XML file c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not be loaded. Attempted to access an unloaded AppDomain.
Source Error:
[No relevant source lines]
Source File: c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 0
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
I've tried to run the rsconfig utility several times, but nothing has helped so far.
Thanks for helping!This is an issue with your .net installation. Not sure what specifically is
causing this but searching google on the error should lead you in the right
direction.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
news:A5E49FA1-A934-47B6-891F-F4A321C3CA17@.microsoft.com...
> Hi;
> I just installed RS and it seemed to go ok. But when I try to access the
Report Manager at localhost\reports, I get the following error:
> Configuration Error
> Description: An error occurred during the processing of a configuration
file required to service this request. Please review the specific error
details below and modify your configuration file appropriately.
> Parser Error Message: The XML file
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
be loaded. Attempted to access an unloaded AppDomain.
> Source Error:
> [No relevant source lines]
> Source File:
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 0
> ----
--
> Version Information: Microsoft .NET Framework Version:1.1.4322.573;
ASP.NET Version:1.1.4322.573
> I've tried to run the rsconfig utility several times, but nothing has
helped so far.
> Thanks for helping!

Report Manager buttons not working

HI there,
we just installed reporting services 2000 on our web server, and some
of the buttons like New Folder, etc do not work. When you press on
them nothing happens.
Does anyone know what would cause this?
Regards,
TomMy guess is you have enable anonymous for the website (check in IIS). If so,
then because the user is anonymous you don't have any rights to do anything,
even if you are an admin because it does not know who your are, you are
anonymous.
Hope that makes sense.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<OTSolutions@.shaw.ca> wrote in message
news:1164995767.663955.160290@.l12g2000cwl.googlegroups.com...
> HI there,
> we just installed reporting services 2000 on our web server, and some
> of the buttons like New Folder, etc do not work. When you press on
> them nothing happens.
> Does anyone know what would cause this?
> Regards,
> Tom
>|||Hi Bruce, we did not have enable anonymous for the website checked.
I also have re-registered asp .net just to be safe, any other
suggestions?
PS Thanks for the quick response.
Regards,
Tom
Bruce L-C [MVP] wrote:
> My guess is you have enable anonymous for the website (check in IIS). If so,
> then because the user is anonymous you don't have any rights to do anything,
> even if you are an admin because it does not know who your are, you are
> anonymous.
> Hope that makes sense.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <OTSolutions@.shaw.ca> wrote in message
> news:1164995767.663955.160290@.l12g2000cwl.googlegroups.com...
> > HI there,
> >
> > we just installed reporting services 2000 on our web server, and some
> > of the buttons like New Folder, etc do not work. When you press on
> > them nothing happens.
> >
> > Does anyone know what would cause this?
> >
> > Regards,
> > Tom
> >|||My next guess is that no-one has setup roles in RS. Are you an administrator
on the server that is running RS. If not, then you need to get someone who
is or get your account added to the local administrator account on the
server. By default, local administrator group accounts have admin rights on
RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<OTSolutions@.shaw.ca> wrote in message
news:1165074992.191408.136430@.f1g2000cwa.googlegroups.com...
> Hi Bruce, we did not have enable anonymous for the website checked.
> I also have re-registered asp .net just to be safe, any other
> suggestions?
> PS Thanks for the quick response.
> Regards,
> Tom
> Bruce L-C [MVP] wrote:
>> My guess is you have enable anonymous for the website (check in IIS). If
>> so,
>> then because the user is anonymous you don't have any rights to do
>> anything,
>> even if you are an admin because it does not know who your are, you are
>> anonymous.
>> Hope that makes sense.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <OTSolutions@.shaw.ca> wrote in message
>> news:1164995767.663955.160290@.l12g2000cwl.googlegroups.com...
>> > HI there,
>> >
>> > we just installed reporting services 2000 on our web server, and some
>> > of the buttons like New Folder, etc do not work. When you press on
>> > them nothing happens.
>> >
>> > Does anyone know what would cause this?
>> >
>> > Regards,
>> > Tom
>> >
>

Report Manager and The request failed with HTTP status 400

I have installed Reporting services on a win2k3 on a completely different
irtual Directory than Default Directory .My Report Server is working fine
but I can't get my reporting manager working it give me this error:
The request failed with HTTP status 400:bad request,
Is there somebody who can help me.
ThnaksI think I got the answert ,,
I'm using a DNS for the new virtual directory that I have installed report
server and report manager on it and I forogt to update <ReportServerUrl> in
the RSWebApplication.config file of "Report Manager"
in the following address:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
It was pointing to the wrong address http://localhost/reportsver where as it
should be http://MyDNS/reportsver.
HTH,
ALI-R
"ALI-R" <newbie@.microsoft.com> wrote in message
news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> I have installed Reporting services on a win2k3 on a completely different
> irtual Directory than Default Directory .My Report Server is working fine
> but I can't get my reporting manager working it give me this error:
> The request failed with HTTP status 400:bad request,
> Is there somebody who can help me.
> Thnaks
>|||Hi all,
we're still in trouble as our ReportManager webapp still won't work.
I verified the RSWebApplication.config files of both Report Manager and
Report Server to contain
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
and
<UrlRoot>http://localhost/ReportServer</UrlRoot>
respectively.
I already verified all permissions and even changed both above URLs to read
http://<servername> instead of localhost. This does not make any noticable
difference.
This is real trouble, MS, I'd hate to have to resort to reïnstalling
everything from scratch, as there's no telling how if, or how long, this will
work...
Please help? :o(
Ramses.
Still, the ReportServer works just fine on both
http://localhost/ReportServer and http://severname/ReportServer, wheras the
ReportManager simply refuses to work. It keeps yielding the dreaded
The request failed with HTTP status 400: Bad Request.
"ALI-R" wrote:
> I think I got the answert ,,
> I'm using a DNS for the new virtual directory that I have installed report
> server and report manager on it and I forogt to update <ReportServerUrl> in
> the RSWebApplication.config file of "Report Manager"
> in the following address:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
> It was pointing to the wrong address http://localhost/reportsver where as it
> should be http://MyDNS/reportsver.
> HTH,
> ALI-R
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> > I have installed Reporting services on a win2k3 on a completely different
> > irtual Directory than Default Directory .My Report Server is working fine
> > but I can't get my reporting manager working it give me this error:
> >
> > The request failed with HTTP status 400:bad request,
> >
> > Is there somebody who can help me.
> >
> > Thnaks
> >
> >
>
>|||Hi all,
we're still in trouble as our ReportManager webapp still won't work.
I verified the RSWebApplication.config files of both Report Manager and
Report Server to contain
<ReportServerUrl>http://localhost/ReportServer</ReportServerUrl>
and
<UrlRoot>http://localhost/ReportServer</UrlRoot>
respectively.
I already verified all permissions and even changed both above URLs to read
http://<servername> instead of localhost. This does not make any noticable
difference.
This is real trouble, MS, I'd hate to have to resort to reïnstalling
everything from scratch, as there's no telling how if, or how long, this will
work...
Please help? :o(
Ramses.
"ALI-R" wrote:
> I think I got the answert ,,
> I'm using a DNS for the new virtual directory that I have installed report
> server and report manager on it and I forogt to update <ReportServerUrl> in
> the RSWebApplication.config file of "Report Manager"
> in the following address:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager
> It was pointing to the wrong address http://localhost/reportsver where as it
> should be http://MyDNS/reportsver.
> HTH,
> ALI-R
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:%23s41$7MBFHA.3528@.tk2msftngp13.phx.gbl...
> > I have installed Reporting services on a win2k3 on a completely different
> > irtual Directory than Default Directory .My Report Server is working fine
> > but I can't get my reporting manager working it give me this error:
> >
> > The request failed with HTTP status 400:bad request,
> >
> > Is there somebody who can help me.
> >
> > Thnaks
> >
> >
>
>|||I would check the host header in IIS. I have been having a problem
where I can't view the report properties, export a report, or schedule
a report (viewing is fine, though).
I was messing with the host headers in IIS and got that message if I
had things configured incorrectly. For working locally, you should
probably not have anything in the host header value for the site.|||I have no Host-headers set for the default website - checked this numerous
times. The default website is bound to both 127.0.0.1 and the LAN IP address
of the server. Note that my http://<servername>/Reports tests wouldn't have
worked otherwise.
Still at a loss. :o(
"cybermud" wrote:
> I would check the host header in IIS. I have been having a problem
> where I can't view the report properties, export a report, or schedule
> a report (viewing is fine, though).
> I was messing with the host headers in IIS and got that message if I
> had things configured incorrectly. For working locally, you should
> probably not have anything in the host header value for the site.
>

Report Manager Admin menu dissapearing

I've installed Reporting Services twice now. At first the administrative menu
in report manager works when I log in with an administative account and I can
upload my .RDL files. However, the next day I log in with the same account
and the administrative toolbar is gone. When I re-install it works again then
stops working. I've tried creating another administrative account and tried
logging in with that, same deal.
I don't get it, it's probably an issue with the authentication/impersonation
routines or something, but this is messed up. I don't have this issue on
another server with the same installation (Server2003, SQL2000, Reporting
Services SP2).
Any suggestions would be appreciated.Ok, I figured it out. Apparently the option to enable anonymous user access
in IIS has to checked off in both the reports and reporting services
application pools. Idiotic, you would expect it only to be required under the
reports pool as it is the one used for the report manager interface.
"Ramez" wrote:
> I've installed Reporting Services twice now. At first the administrative menu
> in report manager works when I log in with an administative account and I can
> upload my .RDL files. However, the next day I log in with the same account
> and the administrative toolbar is gone. When I re-install it works again then
> stops working. I've tried creating another administrative account and tried
> logging in with that, same deal.
> I don't get it, it's probably an issue with the authentication/impersonation
> routines or something, but this is messed up. I don't have this issue on
> another server with the same installation (Server2003, SQL2000, Reporting
> Services SP2).
> Any suggestions would be appreciated.

Report Manager

I've recently installed SQL Server 2005 Expression with Advanced Services. I'm exploring Report Server, deploying and executing reports, but I'm having some problems. If I hit a report in IE 7 using the URL naming scheme, everything is fine. If (on an ASP.NET page) I embed a local (RDLC) report in a ReportViewer control, all is well. If I link to a remote (RDL) report with ReportViewer, even though IIS, SQL Server Express, Report Server, and the user are on the same machine, I get an error:

The permissions granted to user 'SERVER1\ASPNET' are insufficient for performing this operation. (rsAccessDenied).

This is whether I'm using integrated security or anonymous for my web application. The ReportServer$SQLEXPRESS vdir is set at integrated security by default. The message states ASPNET either way, even when a LoginName control on the page confirms that it's using my actual login info. I've seen some places that show elaborate code-based ways to impersonate to get this working better, but it seems like it should just work without resorting to custom code.

I also keep reading about setting roles properly on the server, but I see no way whatsoever to assign users/roles to reports. I've seen several links about the Report Manager (http://msdn2.microsoft.com/en-us/library/ms365166.aspx and http://msdn2.microsoft.com/en-us/library/ms161561.aspx). Supposedly I can go to http://localhost/Reports$SQLEXPRESS (the links both state this), but I get nothing, and IIS doesn't show a vdir with the Reports$SQLEXPRESS name. Is this something that I need to install separately? I've installed on two different XP Pro boxes with the same results.

What am I doing wrong? Help would very much appreciated!

-Arian

Any thoughts anyone?

Please?

|||

Report Manager should be an optional installation option with your SQL Express with Advanced Services edition.

I can't remember the exact UI layout for this but you should be able to either:

1) go into Add/Remove programs and use the change option to open the Installation program for SQL Express with Advanced Services. You should see a Feature selection screen (or need to click an 'advanced' button) to open it. There you should be able to check the report manager.

Or if you're OK doing a reinstall, (I check this on my comptuer) -

Run the express w/ adv svcs installation again.

Uncheck the "Hide advanced configuration options" check box on the Resgistration Information dialog.

On the Feature Selection dialog, in the tree view, click "Reporting Services" and select "Entire feature will be installed on local hard drive". You should see the X disapear from the Report Manager feature.

Proceed with the installation and you should get report manager.

-Lukasz

|||

Right you are! I went back through setup and saw it nested under Report Server. Thanks for that!

Is that all I need to get rid of the ASPNET issue? Once I have Report Manager I just assign permissions to any user, including ASPNET, right?

|||

I don't know off the top of my head. I need to check with some other folks. In the meantime, assiging permissions to ASP.Net user will get you running. If you don't hear back from me in a day or so, just ping this thread and I'll see it in my inbox again :-).

-Lukasz

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 Manager

I think I have Reporting Services installed correctly and it is working except for the Report Manager.
When I browse to http://localhost/reportserver I dont have a user interface. All I see is big black letters saying localhost/reportserver -/ and underneath is a list of the reports I have deployed.
How do I get the user interface to show?
Your help is appreciated.
Roy

OK,
The answer is so simple I can't beleive I overlooked it.
The path to Report Manager is http://<servername>/reports
When I browsed there everything was as expected.|||The Report Manager web application resides here:
http://locahost/reports.

You are accessing the web service URL.

Todd

Report Generator in VS.NET

We have a SQL server 2000 w/ Reporting services installed. I have a laptop
I use for development running Windows XP, w/ VS.Net enterprise installed.
[I know if you intall Reporting services on a Sql server with VS.net
installed you get the Business Intelligent Project types and, therefore,
have access to the Report generator. ]
My question is : Do I have to go to the Sql server and use VS.Net on the
server to use the report generator or is there some way to install and use
report generator from my laptop?
ThxThat's normal. Reporting Services is actually implemented as a Web Service
you can drive from anywhere.
Just run the RS installer on your laptop to get the VS.Net addin, and then
specify the Url of your server.
Or you can use the web front-end by pointing your browser at
http://<server>/Reports
brian
"adrian m" <nospam@.nospam.com> wrote in message
news:e8Q2ZkrbEHA.904@.TK2MSFTNGP09.phx.gbl...
> We have a SQL server 2000 w/ Reporting services installed. I have a
laptop
> I use for development running Windows XP, w/ VS.Net enterprise installed.
> [I know if you intall Reporting services on a Sql server with VS.net
> installed you get the Business Intelligent Project types and, therefore,
> have access to the Report generator. ]
> My question is : Do I have to go to the Sql server and use VS.Net on the
> server to use the report generator or is there some way to install and use
> report generator from my laptop?
> Thx
>