Tuesday, March 20, 2012
Report Manager Virtual Directory disabled
I have problem with Reporting Services 2005 configuration on Win2k3.
Every setting has green mark, except Rprt Manager Virtual Directory
which is grey and Web Service Identity has not configured mark. And I'm
aware that during instalation RS didn't add Reports dir to IIS, but I
don't know why.
Has anyone met with that problem?
Regards,
BartoloHi,
Yes I have just this same problem - but on an XP machine with SP2 (needed
for a demo setup).
Complete new install of SQLExpress Adv version. ReportServer is installed,
but Report Manager is grayed out.
Any resolution anyone please '.
Regards
Graham
"Bartolo" <andrew.osa@.gmail.com> wrote in message
news:1152266153.281436.141940@.k73g2000cwa.googlegroups.com...
> Hi,
> I have problem with Reporting Services 2005 configuration on Win2k3.
> Every setting has green mark, except Rprt Manager Virtual Directory
> which is grey and Web Service Identity has not configured mark. And I'm
> aware that during instalation RS didn't add Reports dir to IIS, but I
> don't know why.
> Has anyone met with that problem?
> Regards,
> Bartolo
>|||Hi,
OK - I just managed to get past this problem :-).
The issue seems to be that I failed to select 'Report Manager' during
initial installation - even though I DID select Reporting Services - Report
Manager seems to be unselected by default !!.
The problem however is then :
1. Re-running the original SQL Express Adv installer, and checking Report
Manager - then tells me that there is nothing to install !! - it apparently
LIES.
2. Running Add/Remove programs, select SQL Server, Change takes me to the
re-install screens BUT my original installation folder was temporary and so
has been deleted :-O.
To get around this problem :
1. Run the main installer again, but at the point where it says nothing to
insall use Explorer to grab a copy of the installers temporary SQL 'Setup'
folder, and store this somewhere safe. Then let the installer exit and
delete its files - you're left with your copy ;-).
2. Run Add/Remove etc - select Report Manager and continue until it
complains that it cannot find 'sqlrun_rs.msi' (as its pointing at the (now
deleted) temp folder. Point this to your copied folder and the install
completes :-)).
Now run the config tool and it shows Report Manager is available !!.
Now all I have to do is to fix the ASP.NET permissions - as it now complains
that the ASP.NET account used to access the webservice (and which I cannot
change) does not have access to the GAC :-O.
Some hoops huh :-O. Maybe Microsoft can comment on the installation failures
?.
NB I already have RS installed on a 2003 server and went through a different
set of hoops to get it running on there :-O.
Hope this helps...
Regards
Graham
"Bartolo" <andrew.osa@.gmail.com> wrote in message
news:1152266153.281436.141940@.k73g2000cwa.googlegroups.com...
> Hi,
> I have problem with Reporting Services 2005 configuration on Win2k3.
> Every setting has green mark, except Rprt Manager Virtual Directory
> which is grey and Web Service Identity has not configured mark. And I'm
> aware that during instalation RS didn't add Reports dir to IIS, but I
> don't know why.
> Has anyone met with that problem?
> Regards,
> Bartolo
>|||Hi Graham,
Thx for help, now I'm on holiday.
So I'd check your solution as soon as I come back to the job.
Then I'll share with my experience.
Regards,
Bartolo|||Thank you for this information, helped me get the Report Manager up and running on my XP box
From http://www.developmentnow.com/g/115_2006_7_0_0_784539/Report-Manager-Virtual-Directory-disabled.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com
report manager problem
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 problem
I am getting the following error when trying to access the Report Manager:
The report server configuration file specifies localhost for the Web server name. The report server requires that the computer name be specified instead.
I have tried:
http://<computername>/reports
http://localhost/reports
I have gone into the report server configuration and tried to change the directory there, but with no affect. Is there something further that I need to be looking at?
Thanks for the information.
In the RSWebApplication.config file you should change the ReportServerUrl to not use localhost.Friday, March 9, 2012
Report Manager configuration
We deployed Reporting Services recently to a customer with a latest release and build. When they type in http://<server>/ReportServer, this just comes up with a screen like a navigation sreen showing folders and links to reports. What needs to be done to get the Report Manager screen showing?
It has been a while since I actually installed Reporting Services. When they go into configuration, all of the green checks are there (except for Web Service Identity, which is Red).
Thanks for any information.
Solved it...the user was not using the Virtual Directory. Sorry for the "newbie" post.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.
Tuesday, February 21, 2012
Report gets refreshed automatically
Hi,
I created a report using SQL 2000 Reporting Services. I have 3 input fields viz., Start Date, End Date and Configuration Item. First 2 are textboxes and the last one is a dropdown. I also have a button 'View Report' clicking which the report page will be refreshed. When I deploy the Reports in report manager, when I give the Start Date then the End date, before I could select a value from the Dropdown, the report page is getting refreshed automatically before I click View Report button. i.e., the report gets refreshed on lifting the focus from the End date textbox. Why does this happen? Note that I have not set the Auto refresh property for this report.
The most likely reason the report is being refreshed is because the "Configuration Item" parameter has a dynamic value that may depend on the values of "Start Date" and/or "End Date". The report is refreshed as soon as the value for "End Date" changes to ensure that the valid values for "Configuration Item" are accurate.
For example, RS will assume that "Configuration Item" depends on "End Date" if:
"Configuration Item" is populated from a query that uses expressions in the query, filters, calculated fields, or query parameters|||
I also faced the same problem.
In my case, by mistake I set the Report Properties " AutoRefresh " as 1 insted of 0 in properties window on right hand side
so just check whether its 1 or 0