report viewer in new window

I'm executing report server from my aspx page as follows:
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
taSource=c:\temp\mydataset.xml)
this seems the easiest way.
Is there any way I can get the report to display in a new window so that my
aspx page still shows?
Thanks,
GDean,
In your ASP.NET page, you can generate script to run in the window onload
event. In your case, this script would call window.open passing the report
URL. Just make sure that you put in window onload to prevent cookie lost if
you are using Forms Authentication. This will guarantee that the script will
run when the page and cookies are loaded.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.manning.com/lachev
Home page and blog http://www.prologika.com
---
"G. Dean Blake" <Dean@.nospam.com> wrote in message
news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> I'm executing report server from my aspx page as follows:
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> taSource=c:\temp\mydataset.xml)
> this seems the easiest way.
> Is there any way I can get the report to display in a new window so that
my
> aspx page still shows?
> Thanks,
> G
>|||if you mean when my aspx page is just loading, I don't have the information
yet to generate the report. A purpose of my aspx page is to develop a
dataset to generate the report. My response.redirect is in answer to a
button click event.
"Teo Lachev" <teo@.nospam.prologika.com> wrote in message
news:uylD6E4hEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Dean,
> In your ASP.NET page, you can generate script to run in the window onload
> event. In your case, this script would call window.open passing the report
> URL. Just make sure that you put in window onload to prevent cookie lost
if
> you are using Forms Authentication. This will guarantee that the script
will
> run when the page and cookies are loaded.
> --
> Hope this helps.
> ---
> Teo Lachev, MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> http://www.manning.com/lachev
> Home page and blog http://www.prologika.com
> ---
> "G. Dean Blake" <Dean@.nospam.com> wrote in message
> news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > I'm executing report server from my aspx page as follows:
> >
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> > taSource=c:\temp\mydataset.xml)
> >
> > this seems the easiest way.
> >
> > Is there any way I can get the report to display in a new window so that
> my
> > aspx page still shows?
> > Thanks,
> > G
> >
> >
>|||No, I meant using Page.RegisterClientScriptBlock in your ASP.NET page to
generate dynamically the browser window.onload call instead of using
Response.Redirect, e.g.
StringBuilder sb=new StringBuilder();
sb.Append("<script language=\"javascript\">");
sb.Append("function requestReport");
sb.Append("{");
sb.Append("window.open (<'your report URL'>");
sb.Append("}");
sb.Append("</script>");
this.Page.RegisterClientScriptBlock("script",sb.ToString());
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.manning.com/lachev
Home page and blog http://www.prologika.com
---
"G. Dean Blake" <Dean@.nospam.com> wrote in message
news:u$8xE%237hEHA.632@.TK2MSFTNGP12.phx.gbl...
> if you mean when my aspx page is just loading, I don't have the
information
> yet to generate the report. A purpose of my aspx page is to develop a
> dataset to generate the report. My response.redirect is in answer to a
> button click event.
> "Teo Lachev" <teo@.nospam.prologika.com> wrote in message
> news:uylD6E4hEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Dean,
> >
> > In your ASP.NET page, you can generate script to run in the window
onload
> > event. In your case, this script would call window.open passing the
report
> > URL. Just make sure that you put in window onload to prevent cookie lost
> if
> > you are using Forms Authentication. This will guarantee that the script
> will
> > run when the page and cookies are loaded.
> >
> > --
> > Hope this helps.
> >
> > ---
> > Teo Lachev, MCSD, MCT
> > Author: "Microsoft Reporting Services in Action"
> > http://www.manning.com/lachev
> > Home page and blog http://www.prologika.com
> > ---
> >
> > "G. Dean Blake" <Dean@.nospam.com> wrote in message
> > news:%23eyTdaxhEHA.3148@.TK2MSFTNGP10.phx.gbl...
> > > I'm executing report server from my aspx page as follows:
> > >
> >
>
response.redirect(http://localhost/reportserver?%2fCPlusReports%2fResults&Da
> > > taSource=c:\temp\mydataset.xml)
> > >
> > > this seems the easiest way.
> > >
> > > Is there any way I can get the report to display in a new window so
that
> > my
> > > aspx page still shows?
> > > Thanks,
> > > G
> > >
> > >
> >
> >
>

Report usage in SQL2005 RS

Is there a SSIS equivalent to the information in DTS package described at
http://msdn2.microsoft.com/en-us/library/aa972246(SQL.80).aspx '
If not, is it possible to install the DTS package and migrate it to SSIS?Make sure Samples are installed on your MSSQL 2005 server. Then go to:
C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Report
Samples\Server Management Sample Reports
There's a solution (Server Management Sample Reports.sln) that contains an
SSIS package and some sample reports. Read the
readme_ServerManagementReports.htm file for instructions.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"William" <William@.discussions.microsoft.com> wrote in message
news:B0511D2D-77F1-4FFC-A070-A8FE2C47C567@.microsoft.com...
> Is there a SSIS equivalent to the information in DTS package described at
> http://msdn2.microsoft.com/en-us/library/aa972246(SQL.80).aspx '
> If not, is it possible to install the DTS package and migrate it to SSIS?

report to url

I have a question to ask:
I type
"http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2ftestreport"
in jump to url box, it will go to open a report named testreport in my report
server. It is good. I want to rename the testreport to a variable name.
If I change testreport to Field!ReportName.Value in stead, then it does
not work, how do you make the Field!ReportName.Value to convert to
testreport. I have other reports in the report server="http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2f" &
Feild!ReportName.Value
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henry Chen" <HenryChen@.discussions.microsoft.com> wrote in message
news:85B76250-BB7F-4C78-96CB-2BB5B0C7804F@.microsoft.com...
>I have a question to ask:
> I type
> "http://reportserverurl/pages/reports.aspx?ItemPath=%2ftargetfolder%2ftestreport"
> in jump to url box, it will go to open a report named testreport in my
> report
> server. It is good. I want to rename the testreport to a variable name.
> If I change testreport to Field!ReportName.Value in stead, then it does
> not work, how do you make the Field!ReportName.Value to convert to
> testreport. I have other reports in the report server

report service's cache problem

hi,
i query the result in Web
my report service has only one parameter
(1) i set some condition as : http://127.0.0.1/reportServer?/query1&NO>=1)
, and query it, It's Ok!
(2) Add some new record in SQL server
(3) and set the query as step(1) :
http://127.0.0.1/reportServer?/query1&NO>=1)) . My god! the
newest added record could't be shown in setp (2)
To find what's the reason of this:
(1) i open the SQL Server's event-detector, and find in step 2 , Server's
event-detector cann't dectect the step(2)'s action.
(2) another test , i set the query as
http://127.0.0.1/reportServer?/query1&NO>=2 , then the result's ok!
(3) finally, i reset the query as
http://127.0.0.1/reportServer?/query1&NO>=1 , then the result's ok, too!
How puzzled it is!
I guess this may be cached by IIS or reportServer.BUT I Cann't find in which
configution , i can shield the cache.
My opion is that in every query , the SQL Sever can dectect the action , and
reQeury the newest result.
Any sugguestion ? thanks a lot!
RainbowIn Report Manager, view the report using an admin account.
Select the Properties tab.
Then select the Execution page.
Is the radio button for Do not cache temporary copies of this report
selected?
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 00:31:09 +0800, "Rainbow" <RainbowHu@.msn.com>
wrote:
>hi,
>i query the result in Web
>my report service has only one parameter
>(1) i set some condition as : http://127.0.0.1/reportServer?/query1&NO>=1)
>, and query it, It's Ok!
>(2) Add some new record in SQL server
>(3) and set the query as step(1) :
>http://127.0.0.1/reportServer?/query1&NO>=1)) . My god! the
>newest added record could't be shown in setp (2)
>
> To find what's the reason of this:
>(1) i open the SQL Server's event-detector, and find in step 2 , Server's
>event-detector cann't dectect the step(2)'s action.
>(2) another test , i set the query as
>http://127.0.0.1/reportServer?/query1&NO>=2 , then the result's ok!
>(3) finally, i reset the query as
>http://127.0.0.1/reportServer?/query1&NO>=1 , then the result's ok, too!
>How puzzled it is!
>I guess this may be cached by IIS or reportServer.BUT I Cann't find in which
>configution , i can shield the cache.
>My opion is that in every query , the SQL Sever can dectect the action , and
>reQeury the newest result.
>Any sugguestion ? thanks a lot!
>Rainbow
>
>|||-- Original Message --
From: "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com>
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Sent: Sunday, October 09, 2005 9:43 PM
Subject: Re: report service's cache problem
> In Report Manager, view the report using an admin account.
> Select the Properties tab.
> Then select the Execution page.
> Is the radio button for Do not cache temporary copies of this report
> selected?
>
thanks, Andrew
Yes, the default value in Execution page is "Do not cache temporary copies
of this report"?In My Report Manager , this is Selected.|||I have the same caching issue. It seems the Reporting Services still cache
the data even the "Do not cache temporary copies of this report" is checked.
Is this a feature or a bug?
Thank you.
"Andrew Watt [MVP - InfoPath]" wrote:
> In Report Manager, view the report using an admin account.
> Select the Properties tab.
> Then select the Execution page.
> Is the radio button for Do not cache temporary copies of this report
> selected?
> Andrew Watt
> MVP - InfoPath
> On Sun, 9 Oct 2005 00:31:09 +0800, "Rainbow" <RainbowHu@.msn.com>
> wrote:
> >hi,
> >
> >i query the result in Web
> >
> >my report service has only one parameter
> >
> >(1) i set some condition as : http://127.0.0.1/reportServer?/query1&NO>=1)
> >, and query it, It's Ok!
> >(2) Add some new record in SQL server
> >(3) and set the query as step(1) :
> >http://127.0.0.1/reportServer?/query1&NO>=1)) . My god! the
> >newest added record could't be shown in setp (2)
> >
> >
> > To find what's the reason of this:
> >(1) i open the SQL Server's event-detector, and find in step 2 , Server's
> >event-detector cann't dectect the step(2)'s action.
> >(2) another test , i set the query as
> >http://127.0.0.1/reportServer?/query1&NO>=2 , then the result's ok!
> >(3) finally, i reset the query as
> >http://127.0.0.1/reportServer?/query1&NO>=1 , then the result's ok, too!
> >
> >How puzzled it is!
> >I guess this may be cached by IIS or reportServer.BUT I Cann't find in which
> >configution , i can shield the cache.
> >My opion is that in every query , the SQL Sever can dectect the action , and
> >reQeury the newest result.
> >
> >Any sugguestion ? thanks a lot!
> >
> >Rainbow
> >
> >
> >
> >
>

Report Server/Reporting Data Services in SQL 2005 Express

As stated in this page:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
The above-mentioned features are to be part of SQL Server 2005 Express at a
future date.
Does anyone know when this is to be?
TIA,
Eddy VugteveenEddy,
Take a look at
http://www.microsoft.com/downloads/details.aspx?familyid=57856CDD-DA9B-4AD0-9A8A-F193AE8410AD&displaylang=en.
You need the SQL Express with Advanced Services Edition.
I believe that the definitive version of SP1 should be available later
this month.
Andrew Watt [MVP]
On Thu, 13 Apr 2006 04:47:02 -0700, Eddy Vugteveen <Eddy
Vugteveen@.discussions.microsoft.com> wrote:
>As stated in this page:
>http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
>The above-mentioned features are to be part of SQL Server 2005 Express at a
>future date.
>Does anyone know when this is to be?
>TIA,
>Eddy Vugteveen|||Hi Andrew
The information I got from someone in Microsoft was Reporting services
was still not available for SQL Express.
If as you say Reporting Services is available in reporting Services how
does the licensing work
Thanks
Karen

Report Server serious issues!

I am having serious issues with RS. i have installed the SP1 and I am
able to launch the main reports page, i.e. http://myserver/Reports and
it re-directs to http://myserver/Reports/Pages/Folder.aspx.
Here i can see all the various options etc. Now I created a sample
connection as per the \MSSQL\Reporting
Services\Samples\Reports\Readme.htm file. The problem is I am unable to
upload any RDL file. It tries to do it, and then comes back with this
message:
"An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help Timeout expired. The
timeout period elapsed prior to completion of the operation or the
server is not responding. "
I also tried using the rs -i PublishSampleReports.rss -s
http://gacorwks7047a/reportserver -v parentFolder="Sample Reports"
method but that too times out on me.
"The operation has timed-out.
The operation has timed-out.
The operation has timed-out.
The operation has timed-out.
The operation has timed-out."
The other wierd part is that from VS .net2003 when i open a Report
wizard and i can create new shared data source OK (for example local-
pubs using windows authentication), but then when i create the new
report and select the same shared data source i get
"A connection cannot be made to the database. Set and check the
connection string."..
please help!!!
thanx much
-rI'd be looking at the account used to start the Reporting service and see if
it has appropriate access to the 2 reports databases.
"rajeev.unnikrishnan@.gmail.com" wrote:
> I am having serious issues with RS. i have installed the SP1 and I am
> able to launch the main reports page, i.e. http://myserver/Reports and
> it re-directs to http://myserver/Reports/Pages/Folder.aspx.
> Here i can see all the various options etc. Now I created a sample
> connection as per the \MSSQL\Reporting
> Services\Samples\Reports\Readme.htm file. The problem is I am unable to
> upload any RDL file. It tries to do it, and then comes back with this
> message:
> "An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help Timeout expired. The
> timeout period elapsed prior to completion of the operation or the
> server is not responding. "
>
> I also tried using the rs -i PublishSampleReports.rss -s
> http://gacorwks7047a/reportserver -v parentFolder="Sample Reports"
> method but that too times out on me.
> "The operation has timed-out.
> The operation has timed-out.
> The operation has timed-out.
> The operation has timed-out.
> The operation has timed-out."
> The other wierd part is that from VS .net2003 when i open a Report
> wizard and i can create new shared data source OK (for example local-
> pubs using windows authentication), but then when i create the new
> report and select the same shared data source i get
> "A connection cannot be made to the database. Set and check the
> connection string."..
> please help!!!
> thanx much
> -r
>|||the ReportingServices starts under LocalAccount, and the Sql box uses
NT authentication, so i guess this rules it out?
any more suggestions - pleeeeeeeeeeeeez
thanx
-r
Mary Bray [SQL Server MVP] wrote:
> I'd be looking at the account used to start the Reporting service and
see if
> it has appropriate access to the 2 reports databases.
>
> "rajeev.unnikrishnan@.gmail.com" wrote:
> > I am having serious issues with RS. i have installed the SP1 and I
am
> > able to launch the main reports page, i.e. http://myserver/Reports
and
> > it re-directs to http://myserver/Reports/Pages/Folder.aspx.
> >
> > Here i can see all the various options etc. Now I created a sample
> > connection as per the \MSSQL\Reporting
> > Services\Samples\Reports\Readme.htm file. The problem is I am
unable to
> > upload any RDL file. It tries to do it, and then comes back with
this
> > message:
> > "An internal error occurred on the report server. See the error log
for
> > more details. (rsInternalError) Get Online Help Timeout expired.
The
> > timeout period elapsed prior to completion of the operation or the
> > server is not responding. "
> >
> >
> > I also tried using the rs -i PublishSampleReports.rss -s
> > http://gacorwks7047a/reportserver -v parentFolder="Sample Reports"
> >
> > method but that too times out on me.
> > "The operation has timed-out.
> > The operation has timed-out.
> > The operation has timed-out.
> > The operation has timed-out.
> > The operation has timed-out."
> >
> > The other wierd part is that from VS .net2003 when i open a Report
> > wizard and i can create new shared data source OK (for example
local-
> > pubs using windows authentication), but then when i create the new
> > report and select the same shared data source i get
> > "A connection cannot be made to the database. Set and check the
> > connection string."..
> >
> > please help!!!
> > thanx much
> > -r
> >
> >|||It sounds like the timeout in IIS is set too small. Try looking in IIS
Manager.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<rajeev.unnikrishnan@.gmail.com> wrote in message
news:1112318394.235320.77230@.f14g2000cwb.googlegroups.com...
> the ReportingServices starts under LocalAccount, and the Sql box uses
> NT authentication, so i guess this rules it out?
> any more suggestions - pleeeeeeeeeeeeez
> thanx
> -r
>
> Mary Bray [SQL Server MVP] wrote:
>> I'd be looking at the account used to start the Reporting service and
> see if
>> it has appropriate access to the 2 reports databases.
>>
>> "rajeev.unnikrishnan@.gmail.com" wrote:
>> > I am having serious issues with RS. i have installed the SP1 and I
> am
>> > able to launch the main reports page, i.e. http://myserver/Reports
> and
>> > it re-directs to http://myserver/Reports/Pages/Folder.aspx.
>> >
>> > Here i can see all the various options etc. Now I created a sample
>> > connection as per the \MSSQL\Reporting
>> > Services\Samples\Reports\Readme.htm file. The problem is I am
> unable to
>> > upload any RDL file. It tries to do it, and then comes back with
> this
>> > message:
>> > "An internal error occurred on the report server. See the error log
> for
>> > more details. (rsInternalError) Get Online Help Timeout expired.
> The
>> > timeout period elapsed prior to completion of the operation or the
>> > server is not responding. "
>> >
>> >
>> > I also tried using the rs -i PublishSampleReports.rss -s
>> > http://gacorwks7047a/reportserver -v parentFolder="Sample Reports"
>> >
>> > method but that too times out on me.
>> > "The operation has timed-out.
>> > The operation has timed-out.
>> > The operation has timed-out.
>> > The operation has timed-out.
>> > The operation has timed-out."
>> >
>> > The other wierd part is that from VS .net2003 when i open a Report
>> > wizard and i can create new shared data source OK (for example
> local-
>> > pubs using windows authentication), but then when i create the new
>> > report and select the same shared data source i get
>> > "A connection cannot be made to the database. Set and check the
>> > connection string."..
>> >
>> > please help!!!
>> > thanx much
>> > -r
>> >
>> >
>|||thanx for the suggestion, i checked the tinmeout was 900 secons
something, i have cranked it up to 10,000 seconds and it still times
out..
i think it has something to do with the permissions, in terms of aspnet
users access with respect to some folder or some service - but i cannot
pinpoint what. But then why should VS act weird and not be able to use
the shared DS'
i hope someone can walk me thro some trouble shooting steps and default
access.
thanx again!!
-r
Brian Welcker wrote:
> It sounds like the timeout in IIS is set too small. Try looking in
IIS
> Manager.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> <rajeev.unnikrishnan@.gmail.com> wrote in message
> news:1112318394.235320.77230@.f14g2000cwb.googlegroups.com...
> >
> > the ReportingServices starts under LocalAccount, and the Sql box
uses
> > NT authentication, so i guess this rules it out?
> >
> > any more suggestions - pleeeeeeeeeeeeez
> >
> > thanx
> > -r
> >
> >
> > Mary Bray [SQL Server MVP] wrote:
> >> I'd be looking at the account used to start the Reporting service
and
> > see if
> >> it has appropriate access to the 2 reports databases.
> >>
> >>
> >> "rajeev.unnikrishnan@.gmail.com" wrote:
> >>
> >> > I am having serious issues with RS. i have installed the SP1 and
I
> > am
> >> > able to launch the main reports page, i.e.
http://myserver/Reports
> > and
> >> > it re-directs to http://myserver/Reports/Pages/Folder.aspx.
> >> >
> >> > Here i can see all the various options etc. Now I created a
sample
> >> > connection as per the \MSSQL\Reporting
> >> > Services\Samples\Reports\Readme.htm file. The problem is I am
> > unable to
> >> > upload any RDL file. It tries to do it, and then comes back with
> > this
> >> > message:
> >> > "An internal error occurred on the report server. See the error
log
> > for
> >> > more details. (rsInternalError) Get Online Help Timeout expired.
> > The
> >> > timeout period elapsed prior to completion of the operation or
the
> >> > server is not responding. "
> >> >
> >> >
> >> > I also tried using the rs -i PublishSampleReports.rss -s
> >> > http://gacorwks7047a/reportserver -v parentFolder="Sample
Reports"
> >> >
> >> > method but that too times out on me.
> >> > "The operation has timed-out.
> >> > The operation has timed-out.
> >> > The operation has timed-out.
> >> > The operation has timed-out.
> >> > The operation has timed-out."
> >> >
> >> > The other wierd part is that from VS .net2003 when i open a
Report
> >> > wizard and i can create new shared data source OK (for example
> > local-
> >> > pubs using windows authentication), but then when i create the
new
> >> > report and select the same shared data source i get
> >> > "A connection cannot be made to the database. Set and check the
> >> > connection string."..
> >> >
> >> > please help!!!
> >> > thanx much
> >> > -r
> >> >
> >> >
> >|||is the fact that i have on that machine .net sdk 1.0, 2.0, SQL 2k, SQL
2005, Analysis Server all running causing some of these issues?|||RS is a 1.1 application, if you have multipe versions of dotnet installed
you definitely have to have IIS configured for RS to be using 1.1. However,
usually when this is a problem you get an error, not a timing out issue.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<rajeev.unnikrishnan@.gmail.com> wrote in message
news:1112358696.050931.32410@.l41g2000cwc.googlegroups.com...
> is the fact that i have on that machine .net sdk 1.0, 2.0, SQL 2k, SQL
> 2005, Analysis Server all running causing some of these issues?
>|||thanx for ur input.. i have since uninstalled sdk2 and re-done
asnet_regiis for 1.1 and still have the same issues..
why does VS 2003 also have the same issue, as to not being able to use
the shared DS even though it is valid!
i am really perplexed here, i have uninstalled and reinstalled rs about
50 times now (with the SP).. the weird thing is that on my personal
laptop all the installation when just fine!!!
thanx
-r
Bruce L-C [MVP] wrote:
> RS is a 1.1 application, if you have multipe versions of dotnet
installed
> you definitely have to have IIS configured for RS to be using 1.1.
However,
> usually when this is a problem you get an error, not a timing out
issue.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <rajeev.unnikrishnan@.gmail.com> wrote in message
> news:1112358696.050931.32410@.l41g2000cwc.googlegroups.com...
> > is the fact that i have on that machine .net sdk 1.0, 2.0, SQL 2k,
SQL
> > 2005, Analysis Server all running causing some of these issues?
> >|||Are you setting a query timeout on the report in the report designer?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<rajeev.unnikrishnan@.gmail.com> wrote in message
news:1112375976.133779.139770@.o13g2000cwo.googlegroups.com...
> thanx for ur input.. i have since uninstalled sdk2 and re-done
> asnet_regiis for 1.1 and still have the same issues..
> why does VS 2003 also have the same issue, as to not being able to use
> the shared DS even though it is valid!
> i am really perplexed here, i have uninstalled and reinstalled rs about
> 50 times now (with the SP).. the weird thing is that on my personal
> laptop all the installation when just fine!!!
>
> thanx
> -r
>
> Bruce L-C [MVP] wrote:
>> RS is a 1.1 application, if you have multipe versions of dotnet
> installed
>> you definitely have to have IIS configured for RS to be using 1.1.
> However,
>> usually when this is a problem you get an error, not a timing out
> issue.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <rajeev.unnikrishnan@.gmail.com> wrote in message
>> news:1112358696.050931.32410@.l41g2000cwc.googlegroups.com...
>> > is the fact that i have on that machine .net sdk 1.0, 2.0, SQL 2k,
> SQL
>> > 2005, Analysis Server all running causing some of these issues?
>> >
>|||nopes.. all i have done (:-() is install rs, install rs sp1 and try
opening up the default report manager page. this works fine. but when i
try to upload the rdl file, it doesnt do it. same with vs 2003, it
opens the project, and then when i supply the right url, and try to
deploy the file, it tires and then says time-out!!
what could be screwed up here?
thanx again!
-r|||I don't think it has anything to do with security. It really looks like some
sort of network name resolution issues. Do you have a proxy server? Are you
using fully qualified machine names?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<rajeev.unnikrishnan@.gmail.com> wrote in message
news:1112380865.139398.189170@.l41g2000cwc.googlegroups.com...
> nopes.. all i have done (:-() is install rs, install rs sp1 and try
> opening up the default report manager page. this works fine. but when i
> try to upload the rdl file, it doesnt do it. same with vs 2003, it
> opens the project, and then when i supply the right url, and try to
> deploy the file, it tires and then says time-out!!
> what could be screwed up here?
> thanx again!
> -r
>|||well i am running on my local machine (localhost) - so how does the
proxy come into play?..
yes, the machine itself go thro a proxy server to go outside the
company network, but i dont think reportserver needs to go outside the
network to open the report ( OR DOES IT- to come to think of it, the
xslt files ect need to be pulled in real time?!).. if it does matter
where do i set the proxy server settings?
thanx very much!
-r

Report Server not found at http://localhost/ReportServer

Hi,
I have installed Developer editio of reporting svcs on my webserver. Our SQL
server 2000 (developer edition) is on a separate database server. Now I have
created a simple report but when i try to deploy the report the report... i
get the error Report Server not found at http://localhost/ReportServer.. Is
it because my database is on a different server?
--
pmudpmud wrote:
> Hi,
> I have installed Developer editio of reporting svcs on my webserver.
> Our SQL server 2000 (developer edition) is on a separate database
> server. Now I have created a simple report but when i try to deploy
> the report the report... i get the error Report Server not found at
> http://localhost/ReportServer.. Is it because my database is on a
> different server?
Is your web server the same machine as your development machine? The
URL you gave would indicate that, but from your description it sounds
like the web server may be on a different box, NOT your development
machine.
In VStudio 2003, right-click on your report project in Solution
Explorer (usually at the top righthand corner of the dev environment).
Make sure that the TargetServerURL property points to your web server
where Reporting Services is. For example, if your web/reporting server
is named pmudweb, TargetServerURL should be http://pmudweb/ReportServer
.
So, it may be because your reporting server is on another machine, not
because the database server is on another machine.
hth
Highly Obscure|||Hi Highly Obscure,
I tried that and it works but i get a different error now i.e "The
underlying connection was closed.could not establish trust relationship with
remote server."
I think it is something related with SSL... I am reading a Microsoft article
right now at http://support.microsoft.com/?scid=kb;en-us;823177 . If you
have any inputs, please let me know.
Thanks
"Highly Obscure" wrote:
> pmud wrote:
> > Hi,
> >
> > I have installed Developer editio of reporting svcs on my webserver.
> > Our SQL server 2000 (developer edition) is on a separate database
> > server. Now I have created a simple report but when i try to deploy
> > the report the report... i get the error Report Server not found at
> > http://localhost/ReportServer.. Is it because my database is on a
> > different server?
> Is your web server the same machine as your development machine? The
> URL you gave would indicate that, but from your description it sounds
> like the web server may be on a different box, NOT your development
> machine.
> In VStudio 2003, right-click on your report project in Solution
> Explorer (usually at the top righthand corner of the dev environment).
> Make sure that the TargetServerURL property points to your web server
> where Reporting Services is. For example, if your web/reporting server
> is named pmudweb, TargetServerURL should be http://pmudweb/ReportServer
> ..
> So, it may be because your reporting server is on another machine, not
> because the database server is on another machine.
> hth
> Highly Obscure
>|||We got this behavior when we used a certificate that didn't chain up to
a "real" root certificate. In our case we installed Certificate
Services as enterprise root on a domain controller in a different
domain from the report server, then requested a certificate from this
CA and installed it on the report server. No matter what we tried (and
of course we installed the Web server certificate in Internet Explorer
on the client), we could not get SSL working reliably on the report
server, with various symptoms, one of which was the error you cite.
In the end, since this was in the development environment, we ended up
using SelfSSL, available from Microsoft at
http://www.microsoft.com/windowsserver2003/iis/downloads/default.mspx .
It's a lot better than makecert. You can also download an SSL
diagnostic utility from the link given above, very helpful.
now that's
Highly Obscure
pmud wrote:
> Hi Highly Obscure,
> I tried that and it works but i get a different error now i.e "The
> underlying connection was closed.could not establish trust
> relationship with remote server."
> I think it is something related with SSL... I am reading a Microsoft
> article right now at
> http://support.microsoft.com/?scid=kb;en-us;823177 . If you have any
> inputs, please let me know.
> Thanks
>|||Hi Highly Obscure,
I tried a couple of things since yesterday and my my real problem is as
follows. Please suggest that with the problem I have , will it be a good idea
to download the Self SSL as suugested by you.
PROBLEM::
I have installed Reporting Services and enabled SSL. The Reporting Svcss by
default was installed in the "Dealer.com" which was originally the Default
Website . Now we created another site with properties same as the Defult Web
site and called it Default Website and created virtual directories "Reports"
and "ReportServer" in this new Default Web site.
Now the problem is that when I deploy the reports , I get an error alert
message saying " A connection could not be made to the report server at
https://report.com/ReportServer . " When I close this message I get an error
in the Task List oh VS.Net as " The underlying connection was closed. Could
not establish trust relationship with the server."
I have already changed the 2 config files to use the URL
https://report.com/ReportServer and the project property of traget URL is
also set to the same. Also, the SSL Sercure Key Connection Value is set to 2.
I am able to browse from IE to https://report.com/ReportServer but not to
the report manager at https://report.com/reports .Also, MY MAIN PROBLEM IS
THAT I CANT DEPLOY THE REPORTS..
Also, our SQL database is on a different server and reporting services is on
the webserver.
Sjpuld I download the SelfSSl for this paroblem'
Thanks
"Highly Obscure" wrote:
> We got this behavior when we used a certificate that didn't chain up to
> a "real" root certificate. In our case we installed Certificate
> Services as enterprise root on a domain controller in a different
> domain from the report server, then requested a certificate from this
> CA and installed it on the report server. No matter what we tried (and
> of course we installed the Web server certificate in Internet Explorer
> on the client), we could not get SSL working reliably on the report
> server, with various symptoms, one of which was the error you cite.
> In the end, since this was in the development environment, we ended up
> using SelfSSL, available from Microsoft at
> http://www.microsoft.com/windowsserver2003/iis/downloads/default.mspx .
> It's a lot better than makecert. You can also download an SSL
> diagnostic utility from the link given above, very helpful.
> now that's
> Highly Obscure
> pmud wrote:
> > Hi Highly Obscure,
> >
> > I tried that and it works but i get a different error now i.e "The
> > underlying connection was closed.could not establish trust
> > relationship with remote server."
> >
> > I think it is something related with SSL... I am reading a Microsoft
> > article right now at
> > http://support.microsoft.com/?scid=kb;en-us;823177 . If you have any
> > inputs, please let me know.
> >
> > Thanks
> >
>

Report server missing

Hi,
i did install srs sucessfully but i couldnt run reportserver nor my
http://localhost/report works.
And even i couldnt find reportserver in adminstrative tools [services] to
restart the report server.
and i can see the result in preview,
But when i deploy or click f5 to see in browser it provides an error as no
report server found at blah blah.
Do you want me to reinstall else are we having any remedy for it.
Regards
Navin.DOn Tue, 4 Oct 2005 12:11:05 -0700, "NAVIN.D"
<NAVIND@.discussions.microsoft.com> wrote:
>Hi,
>i did install srs sucessfully but i couldnt run reportserver nor my
>http://localhost/report works.
>And even i couldnt find reportserver in adminstrative tools [services] to
>restart the report server.
>and i can see the result in preview,
>But when i deploy or click f5 to see in browser it provides an error as no
>report server found at blah blah.
>Do you want me to reinstall else are we having any remedy for it.
>Regards
>Navin.D
You should try http://localhost/reports (with a final "s"). Your URL
is wrong.
In the Services window, Reporting Services should be visible as
ReportServer. If you don't have that I suspect that your install
wasn't complete.
Andrew Watt
MVP - InfoPath|||Hi,
It seems like I am getting a similar error - "Report Services instance could
not be found". However, from services, I am able to start and stop SQL
Server Reporting Services. I get the error when I try to connect to
Reporting Services from Management Studio. I am using Sept CTP.
How do I verify that I have this installed correctly? From the folder
structure, I'm seeing MSSQL.1, MSSQL.2, and MSSQL.3, so I am pretty sure I
installed all components that's on the CD.
Any help is appreciated!
-Lawrence
"Andrew Watt [MVP - InfoPath]" wrote:
> On Tue, 4 Oct 2005 12:11:05 -0700, "NAVIN.D"
> <NAVIND@.discussions.microsoft.com> wrote:
> >Hi,
> >
> >i did install srs sucessfully but i couldnt run reportserver nor my
> >http://localhost/report works.
> >
> >And even i couldnt find reportserver in adminstrative tools [services] to
> >restart the report server.
> >
> >and i can see the result in preview,
> >
> >But when i deploy or click f5 to see in browser it provides an error as no
> >report server found at blah blah.
> >
> >Do you want me to reinstall else are we having any remedy for it.
> >
> >Regards
> >Navin.D
> You should try http://localhost/reports (with a final "s"). Your URL
> is wrong.
> In the Services window, Reporting Services should be visible as
> ReportServer. If you don't have that I suspect that your install
> wasn't complete.
> Andrew Watt
> MVP - InfoPath
>|||it was stupid of me... i got it to work now... thanks!
-Lawrence
"Lawrence" wrote:
> Hi,
> It seems like I am getting a similar error - "Report Services instance could
> not be found". However, from services, I am able to start and stop SQL
> Server Reporting Services. I get the error when I try to connect to
> Reporting Services from Management Studio. I am using Sept CTP.
> How do I verify that I have this installed correctly? From the folder
> structure, I'm seeing MSSQL.1, MSSQL.2, and MSSQL.3, so I am pretty sure I
> installed all components that's on the CD.
> Any help is appreciated!
> -Lawrence
> "Andrew Watt [MVP - InfoPath]" wrote:
> > On Tue, 4 Oct 2005 12:11:05 -0700, "NAVIN.D"
> > <NAVIND@.discussions.microsoft.com> wrote:
> >
> > >Hi,
> > >
> > >i did install srs sucessfully but i couldnt run reportserver nor my
> > >http://localhost/report works.
> > >
> > >And even i couldnt find reportserver in adminstrative tools [services] to
> > >restart the report server.
> > >
> > >and i can see the result in preview,
> > >
> > >But when i deploy or click f5 to see in browser it provides an error as no
> > >report server found at blah blah.
> > >
> > >Do you want me to reinstall else are we having any remedy for it.
> > >
> > >Regards
> > >Navin.D
> >
> > You should try http://localhost/reports (with a final "s"). Your URL
> > is wrong.
> >
> > In the Services window, Reporting Services should be visible as
> > ReportServer. If you don't have that I suspect that your install
> > wasn't complete.
> >
> > Andrew Watt
> > MVP - InfoPath
> >

Report Server issue

Hi, when I open my report server ( http://localhost/reportserver ) in IE doesn't show the option to delete, new folder, new data source, etc, IE shows all like a FTP explorer with flat text and hyperlinks, I can't delete a deployed solution, how I can install, reconfigure or fix this issue?

Marcos

Hi Marcos,

To manage the reports (add/edit/delete --> datasource, folders , reports etc...), please browse to http://localhost/reports instead of http://localhost/reportserver.

Thanks and Regards,

sudheer racha

|||

Thank you, but it continues appearing equal. maybe I don't have grant access but I'm administrator. it's possible that the security configurations in IE make this issue?

Marcos

|||

I can't really picture what you are saying nor do I understand the problem as you have described it. Can you try describing the problem a bit more or do the following so that we can see what you are talking about:

1. Create an account at www.photobucket.com

2. Create a screenshot of what you see when you navigate to http://localhost/reports

3. Upload this to your photobucket account

4. Link to the image in this thread so we can see it.

|||

yeess! It workss... is very very very slow but it work, remain a lot of time to open the report manager but works. Thanks

|||It sounds like either your server or the PC you are accessing report manager from needs more RAM or a faster processor.

Report Server is not responding for XP2 sp2 and SQL Server 05 Dev

I am encountering this issue when I try and go to the Report Server url
http://localhost/reports
I get the message:
"The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version."
I get the same message when I used the computer name insteaed of localhost
The Reports Virtual Directory and the Report Server virtual directory are
installed under the default web site
--
adamHello Adam,
Thank you for using Microsoft MSDN newsgroup!
From your description, I understand that you installed SRS 2005 on WinXP
SP2 machine, but you received the following error message when accessing
http://localhost/reports. If I'm off-base, please let me know.
"The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version."
Based on my experience, you may want to temporarily remove the following
entry from C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager\RSWebApplication.config file:
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
Also, please make sure the following entry is listed in above file:
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
Note: Please back up above file before you do any modification.
If the issue persists, please go to following URL and let me know the
result.
http://localhost/reportserver
Do you configure SSL for the reportserver/reports virtual directories?
If you have any update or questions, please feel free to let's know. I look
forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi peter,
Thx for your reply â' Iâ'm afraid that didnâ't work.
Here is the RSWebApplication.config after the edits you suggested. The
Report Server VD line I commented out rather than removed.
<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl
<!--<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>-->
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
Do you configure SSL for the reportserver/reports virtual directories? â' No
Look forward to hearing from you as to what our next step is
Cheers
adam
--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for using Microsoft MSDN newsgroup!
> From your description, I understand that you installed SRS 2005 on WinXP
> SP2 machine, but you received the following error message when accessing
> http://localhost/reports. If I'm off-base, please let me know.
> "The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version."
> Based on my experience, you may want to temporarily remove the following
> entry from C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager\RSWebApplication.config file:
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>.
> Also, please make sure the following entry is listed in above file:
> <ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
> Note: Please back up above file before you do any modification.
> If the issue persists, please go to following URL and let me know the
> result.
> http://localhost/reportserver
> Do you configure SSL for the reportserver/reports virtual directories?
> If you have any update or questions, please feel free to let's know. I look
> forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Adam,
Thank you for your update. I found reportserverurl entry is empty on the
first line. Please remove the following line to test the sitaution.
<ReportServerUrl></ReportServerUrl>
We look forward to yur reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update. I found reportserverurl entry is empty on the
> first line. Please remove the following line to test the sitaution.
> <ReportServerUrl></ReportServerUrl>
> We look forward to yur reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hi Peter,
I removed the line but to no avail
"<ReportServerUrl></ReportServerUrl> "
is there additonal information I can provide you to help diagonse the
situation?
many thx
ps i seemed to have posted a blank response by accident
adam
--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update. I found reportserverurl entry is empty on the
> first line. Please remove the following line to test the sitaution.
> <ReportServerUrl></ReportServerUrl>
> We look forward to yur reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update. Before we go further on this issue, I'd like to
know the following information:
1. please go to following URL and let me know the result.
http://localhost/reportserver
2. Please check if sharepoint extension is installed on the default website
Run inetmgr, right click the default Web site->properties->ISAPI Filter,
and check if stsfltr is listed. If so, please add reports and reportserver
virtual directlory Sharepoint Exclusion paths. You can add the Reports
virtual directory to the exclusion paths using Sharepoint administration:
http://msdn2.microsoft.com/en-us/library/ms159697.aspx
3. Did you configure hostheader for your default Web site? Did you use
default 80 port for your default web site?
Run inetmgr,right click the default Web site->properties->Web
site->Advanced, make sure it is default to 80, and no host header if used.
IP address is set to "All unassigned"
4. Change the RSWebApplication.config to following to test
<UI>
<ReportServerUrl>http://localhost/reportserver/</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
</UI>
I'm looking forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter - see my detailed answers below:
It didn't seem to work though: Dont have wss installed so much didn't apply.
many thx adam - look forward to your next installement so we can move on.
Hope we are ruling out the usual suspects. adam
1) please go to following URL and let me know the result.
http://localhost/reportserver
Result below
localhost/ReportServer - /
________________________________________
________________________________________
Microsoft SQL Server Reporting Services Version 9.00.2047.00
2. Please check if sharepoint extension is installed on the default website
Run inetmgr, right click the default Web site->properties->ISAPI Filter,
and check if stsfltr is listed.
IIS - Default Web Site â' ISAPI Filter â' Properties
No Filter listed
3) a) Did you use default 80 port for your default web site? Yes
IIS - Default Web Site â'Web Site - Properties - TCP Port: = 80
b) Is IP address is set to "All unassigned"?
IIS - Default Web Site â'â' Properties â' IP Address: = (All Unassigned)
c) Did you configure hostheader for your default Web site? â' No see below
IIS - Default Web Site â' Properties â' Web Site - IP Address - Advanced
Under: Multiple Identities for this web site
Has the following values
IP Address: Default â' TCP Port: 80 - Host Header Name: BLANK
4. Change the RSWebApplication.config to following to test:
Changes made:
Added â'/â' to the end of
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
So it reads
<ReportServerUrl>http://localhost/reportserver/</ReportServerUrl>
Removed the line
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
RSWebApplication.config file after changes below
<Configuration>
<UI>
<ReportServerUrl>http://localhost/reportserver/</ReportServerUrl>
<!--<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>-->
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update. Before we go further on this issue, I'd like to
> know the following information:
> 1. please go to following URL and let me know the result.
> http://localhost/reportserver
> 2. Please check if sharepoint extension is installed on the default website
> Run inetmgr, right click the default Web site->properties->ISAPI Filter,
> and check if stsfltr is listed. If so, please add reports and reportserver
> virtual directlory Sharepoint Exclusion paths. You can add the Reports
> virtual directory to the exclusion paths using Sharepoint administration:
> http://msdn2.microsoft.com/en-us/library/ms159697.aspx
>
> 3. Did you configure hostheader for your default Web site? Did you use
> default 80 port for your default web site?
> Run inetmgr,right click the default Web site->properties->Web
> site->Advanced, make sure it is default to 80, and no host header if used.
> IP address is set to "All unassigned"
>
> 4. Change the RSWebApplication.config to following to test
>
> <UI>
> <ReportServerUrl>http://localhost/reportserver/</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> </UI>
> I'm looking forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update.
Going forward, please collect reporting services web application log under
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\log\ReportserverWebApp*.log
You could send them to me at petery@.microsoft.com
Also, please disable the loopback check on WinXP machine to see if it makes
any difference:
1. Click Start, click Run, type regedit, and then click OK.
2. In Registry Editor, locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. Right-click Lsa, point to New, and then click DWORD Value.
4. Type DisableLoopbackCheck, and then press ENTER.
5. Right-click DisableLoopbackCheck, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Quit Registry Editor, and then restart your computer.
Since the issue is most likely related to Reportserverurl configuration.
Please change the RSWebApplication.config file to include the exact
following content:
<UI>
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
And/or
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>http://localhost/reportserver</ReportServerVir
tualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Please make sure you run iisreset after each test. Thank you for your time
and I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||thx
i'll mail the logs to your email.
here's the rest Changed the Registery setting as instructed.
After having made registry editor changes below and before having made
changes to the RSWebApplication.config file I tried the URL
http://localhost/reports/ and got the following error. Please read past the
error as there is more
Server Error in '/Reports' Application.
________________________________________
The report server configuration file specifies localhost for the Web server
name. The report server requires that the computer name be specified instead.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Exception: The report server configuration file
specifies localhost for the Web server name. The report server requires that
the computer name be specified instead.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[Exception: The report server configuration file specifies localhost for the
Web server name. The report server requires that the computer name be
specified instead.]
Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode
node, RSConfiguration configObject) +1211
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument()
+972
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32
[ServerConfigurationErrorException: The report server has encountered a
configuration error. See the report server log files for more information.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String
configFileName) +62
Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String
configFileName, String location) +296
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
configFileName, String configLocation) +134
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84
Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender,
EventArgs e) +32
________________________________________
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42
********************************************************
I changed the RSWebconfig file as instructed and here were the results:
<UI>
<ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Gave
Server Error in '/Reports' Application.
----
The report server configuration file specifies localhost for the Web server
name. The report server requires that the computer name be specified instead.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Exception: The report server configuration file
specifies localhost for the Web server name. The report server requires that
the computer name be specified instead.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[Exception: The report server configuration file specifies localhost for the
Web server name. The report server requires that the computer name be
specified instead.]
Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode
node, RSConfiguration configObject) +1211
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument()
+972
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32
[ServerConfigurationErrorException: The report server has encountered a
configuration error. See the report server log files for more information.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String
configFileName) +62
Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String
configFileName, String location) +296
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String
configFileName, String configLocation) +134
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84
Microsoft.ReportingServices.UI.Global.get_Configuration() +4
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +84
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +64
----
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42
For
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>http://localhost/reportserver</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
The http://localhost/reports/
Gave
The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.
Thanks very much and I look forward to your next post and help
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update.
> Going forward, please collect reporting services web application log under
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\log\ReportserverWebApp*.log
> You could send them to me at petery@.microsoft.com
> Also, please disable the loopback check on WinXP machine to see if it makes
> any difference:
> 1. Click Start, click Run, type regedit, and then click OK.
> 2. In Registry Editor, locate and then click the following registry key:
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
> 3. Right-click Lsa, point to New, and then click DWORD Value.
> 4. Type DisableLoopbackCheck, and then press ENTER.
> 5. Right-click DisableLoopbackCheck, and then click Modify.
> 6. In the Value data box, type 1, and then click OK.
> 7. Quit Registry Editor, and then restart your computer.
> Since the issue is most likely related to Reportserverurl configuration.
> Please change the RSWebApplication.config file to include the exact
> following content:
> <UI>
> <ReportServerUrl>http://localhost/reportserver</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
>
> And/or
>
> <UI>
> <ReportServerUrl></ReportServerUrl>
>
> <ReportServerVirtualDirectory>http://localhost/reportserver</ReportServerVir
> tualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
>
> Please make sure you run iisreset after each test. Thank you for your time
> and I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update and log infomration. Going forward, please
replace reportserverurl to your computername to test:
<UI>
<ReportServerUrl>http://yourcomputername/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
Also, you may try to use FQDN of your computer name such as
"server.domain.com" to test
<UI>
<ReportServerUrl>http://server.domain.com/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
I appreciate your efforts in working with us and I look forward to your
reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter â' Iâ'm afraid the results were not good
After having placed the computername, both with and without fqdn, in the
ReportServer URL I am afraid I still get
â'The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version. â'
The URLs I used to test were http://computername/reports and
http://localhost/reports
Both gave the same result.
Please could you get back to me with your next suggestions.
adam
--
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update and log infomration. Going forward, please
> replace reportserverurl to your computername to test:
> <UI>
> <ReportServerUrl>http://yourcomputername/reportserver</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> Also, you may try to use FQDN of your computer name such as
> "server.domain.com" to test
> <UI>
> <ReportServerUrl>http://server.domain.com/reportserver</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> I appreciate your efforts in working with us and I look forward to your
> reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Do those two websites exist in IIS (using IIS tools to look at your web
site).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"adam" <adam@.noemail.noemail> wrote in message
news:81A4375D-46B5-478E-B2F5-4FD44F297A05@.microsoft.com...
> Hi Peter - I'm afraid the results were not good
> After having placed the computername, both with and without fqdn, in the
> ReportServer URL I am afraid I still get
> "The attempt to connect to the report server failed. Check your
> connection
> information and that the report server is a compatible version. "
> The URLs I used to test were http://computername/reports and
> http://localhost/reports
> Both gave the same result.
> Please could you get back to me with your next suggestions.
> adam
> --
> adam
>
> ""privatenews"" wrote:
>> Hello Adam,
>> Thank you for your update and log infomration. Going forward, please
>> replace reportserverurl to your computername to test:
>> <UI>
>> <ReportServerUrl>http://yourcomputername/reportserver</ReportServerUrl>
>> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
>> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
>> </UI>
>> Also, you may try to use FQDN of your computer name such as
>> "server.domain.com" to test
>> <UI>
>> <ReportServerUrl>http://server.domain.com/reportserver</ReportServerUrl>
>> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
>> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
>> </UI>
>> I appreciate your efforts in working with us and I look forward to your
>> reply.
>> Best Regards,
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>>
>> =====================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> ======================================================>>|||hi bruce
underneath the deafult web site in ISS there are two directories entitled
ReportServer
Reports
please tell me anything else you need to know to help diagnose.
many thx
adam
adam
"Bruce L-C [MVP]" wrote:
> Do those two websites exist in IIS (using IIS tools to look at your web
> site).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "adam" <adam@.noemail.noemail> wrote in message
> news:81A4375D-46B5-478E-B2F5-4FD44F297A05@.microsoft.com...
> > Hi Peter - I'm afraid the results were not good
> >
> > After having placed the computername, both with and without fqdn, in the
> > ReportServer URL I am afraid I still get
> >
> > "The attempt to connect to the report server failed. Check your
> > connection
> > information and that the report server is a compatible version. "
> >
> > The URLs I used to test were http://computername/reports and
> > http://localhost/reports
> >
> > Both gave the same result.
> >
> > Please could you get back to me with your next suggestions.
> >
> > adam
> >
> > --
> > adam
> >
> >
> > ""privatenews"" wrote:
> >
> >> Hello Adam,
> >>
> >> Thank you for your update and log infomration. Going forward, please
> >> replace reportserverurl to your computername to test:
> >>
> >> <UI>
> >>
> >> <ReportServerUrl>http://yourcomputername/reportserver</ReportServerUrl>
> >>
> >> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> >> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> >>
> >> </UI>
> >>
> >> Also, you may try to use FQDN of your computer name such as
> >> "server.domain.com" to test
> >>
> >> <UI>
> >>
> >> <ReportServerUrl>http://server.domain.com/reportserver</ReportServerUrl>
> >>
> >> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> >> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> >>
> >> </UI>
> >>
> >> I appreciate your efforts in working with us and I look forward to your
> >> reply.
> >>
> >> Best Regards,
> >>
> >> Peter Yang
> >> MCSE2000/2003, MCSA, MCDBA
> >> Microsoft Online Partner Support
> >>
> >>
> >> =====================================================> >>
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> ======================================================> >>
> >>
> >>
>
>|||Hello Adam,
It seems there are some issue on the components of reportmanager. If you do
not have SQL 2005 SP1 installed, you may want to install it from the
follwoing link:
http://www.microsoft.com/sql/sp1.mspx
if you have SQL 2005 SP1 installed, and you'd like to keep the old
database, please backup databases via the following method, and
remove/reinstall RS component, and then reinstall SP1 for RS component.
How to move a Reporting Services database from a computer that is running
Reporting Services to another computer
http://support.microsoft.com/default.aspx?scid=842425
If the issue persists, I'd like to know the following information. .
How did you configure <UrlRoot> entry in RSReportServer.Config? Do you have
other Web sites running on the server? If so, if you temporarily stop other
web sites and only keep default Web site running, what's the result?
please also help gather the IIS metabase and send them to me
A. Install IIS 6 resource kit which include metaexploer
http://www.microsoft.com/downloads/details.aspx?FamilyID=56FC92EE-A71A-4C73-
B628-ADE629C89499&displaylang=en
B. Run MBExplorer.exe.
C. Right-click LM and click Export to file.
D. Type a name such as "lm" and click OK.
E. Repeat steps for the rest containers.
F. Please compress the files to a ZIP file and send it to me
Thanks for your patience and time, and we look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter,
The Version of SQLServer that I am running is below
9.00.2047.00 SP1 Developer Edition
Question Peter: is there a way to not have installed SP1 for RS but have
installed it for the rest of RS?
Clarification to be sure:
You would like me to uninstall Reporting Services entirely and reinstall it?
If so thatâ's ok just want to be sure.
The <UrlRoot> entry in RSReportServer.Config is configured as follows
<UrlRoot> http://computername/reportserver<UrlRoot>
Do you have other Web sites running on the server?
No there is just the Report Server sites under the default web sites
IIS Metabase: I have emailed this to you.
Adam
--
adam
""privatenews"" wrote:
> Hello Adam,
> It seems there are some issue on the components of reportmanager. If you do
> not have SQL 2005 SP1 installed, you may want to install it from the
> follwoing link:
> http://www.microsoft.com/sql/sp1.mspx
> if you have SQL 2005 SP1 installed, and you'd like to keep the old
> database, please backup databases via the following method, and
> remove/reinstall RS component, and then reinstall SP1 for RS component.
> How to move a Reporting Services database from a computer that is running
> Reporting Services to another computer
> http://support.microsoft.com/default.aspx?scid=842425
>
> If the issue persists, I'd like to know the following information. .
> How did you configure <UrlRoot> entry in RSReportServer.Config? Do you have
> other Web sites running on the server? If so, if you temporarily stop other
> web sites and only keep default Web site running, what's the result?
>
> please also help gather the IIS metabase and send them to me
> A. Install IIS 6 resource kit which include metaexploer
> http://www.microsoft.com/downloads/details.aspx?FamilyID=56FC92EE-A71A-4C73-
> B628-ADE629C89499&displaylang=en
> B. Run MBExplorer.exe.
> C. Right-click LM and click Export to file.
> D. Type a name such as "lm" and click OK.
> E. Repeat steps for the rest containers.
> F. Please compress the files to a ZIP file and send it to me
> Thanks for your patience and time, and we look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update and information attached to your email.
>Question Peter: is there a way to not have installed SP1 for RS but have
>installed it for the rest of RS?
If you want to install SP1 for components other than SRS, you could
deselect SRS on steup program when prompted.
>You would like me to uninstall Reporting Services entirely and reinstall
it?
>If so thatâ's ok just want to be sure.
Yes. I suggested that remove RS component (including sp1) from Add/Remove
program, reinstall RS compoennt and re-apply SP1 to the component.
From IIS metabase, it seems ASP.net is not working properly for the Rreport
VD since some properties are missing. You could compare reports and
reportserver VD in metabase explorer, some ASP related entries are missed.
I suspect web.config under reportmanager folder is corrupted or has some
missed configuration.
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager\
I have included a copy of web.config on my side just for your reference. If
you want to modify the file, please back up it first.
Also, you may want to try to create a new VD for report mangaer by
referring to link below. However, this is just for test and is not a
support situation.
http://sqljunkies.com/Article/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
Thank you for your efforts, and I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter,
I unistalled and reinstalled SRS
I then reinstalled sp1
I deleted the Report Server and Report Manager Viritual Directories. I got
Reporting services Configuration screen dumps for you to look at.
Once I completed this it failed however there is something new
http://localhost/Reports
same as before
"The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version"
http://localhost/ReportServer
*NEW MESSAGE*
Reporting Services Error
________________________________________
â?¢ The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is
denied.
________________________________________
SQL Server Reporting Services
*ANOTHER NEW MESSAGE*
http://<computer name>/reportserver
Reporting Services Erro
----
The report server installation is not initialized.
(rsReportServerNotActivated) (rsRPCError) Get Online Help
----
SQL Server Reporting Services
Peter need exact instruction on what you think I should modify to proceed.
I wasn't clear what you wanted me to do with the Web config file.
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update and information attached to your email.
> >Question Peter: is there a way to not have installed SP1 for RS but have
> >installed it for the rest of RS?
> If you want to install SP1 for components other than SRS, you could
> deselect SRS on steup program when prompted.
>
> >You would like me to uninstall Reporting Services entirely and reinstall
> it?
> >If so that�s ok just want to be sure.
> Yes. I suggested that remove RS component (including sp1) from Add/Remove
> program, reinstall RS compoennt and re-apply SP1 to the component.
>
> From IIS metabase, it seems ASP.net is not working properly for the Rreport
> VD since some properties are missing. You could compare reports and
> reportserver VD in metabase explorer, some ASP related entries are missed.
> I suspect web.config under reportmanager folder is corrupted or has some
> missed configuration.
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager\
> I have included a copy of web.config on my side just for your reference. If
> you want to modify the file, please back up it first.
>
> Also, you may want to try to create a new VD for report mangaer by
> referring to link below. However, this is just for test and is not a
> support situation.
> http://sqljunkies.com/Article/525B575A-7F61-483A-AC8F-FEC700C34674.scuk
> Thank you for your efforts, and I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
Thank you for your update. Sorry to hear that reinstall doesn't solve the
issue.
From the error message of reportserver, it seems the application pool of
Reportserver VD does not have permission of the file RSReportServer.config
You may want to grant <computername>\aspnet account full NTFS control
permission to the following folders
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportManager\
Right click the folder->Properties->Security, and check the NTFS
permission.
You may add ASPNET account to SQL Server login, and grant it sysadmin role
to isolate the issue
In management studio, find security->login, and add the account
<computername>\aspnet, and grant it sysadmin role.
You could try to connect to ReportServer and reports VDs to test the
situation. You may want to try to initialize RS via RS configuration tool
before doing so.
If you encounter "cannot connect to reportserver database" error, try to
run the following command to re-configure database connection of RS:
rsconfig -s -d reportserver -a Windows -U <domain user account that want
to use> -P <password of the domain user>
Please let me know if you have any update. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter
no luck
followed the steps you outlined please see my status report below!
please read to the bottom.
ASP.net account granted full control to both the REportServer and
ReportManager directory
ASP.net account was part of SQL Server login. I added sysadmin role
RS configuration tool.
Confused here. There are 2 entries on the Intitaliazation page - however
only one of the line items has the intialization check bok filled in.
here are the error items provided by clicking "Tell me more about the
problem and how to resolve it"
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
installation is not initialized. (rsReportServerNotActivated)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
installation is not initialized. (rsReportServerNotActivated)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
Did not use the rsconfig utility in case what I have written changes
anything in anyway.
Also for using the RSconfig utility - please coudl you give me blow blow
instructions of how to use it.
many thx adam
adam
""privatenews"" wrote:
> Hello Adam,
> Thank you for your update. Sorry to hear that reinstall doesn't solve the
> issue.
> From the error message of reportserver, it seems the application pool of
> Reportserver VD does not have permission of the file RSReportServer.config
> You may want to grant <computername>\aspnet account full NTFS control
> permission to the following folders
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportServer\
> C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
> Services\ReportManager\
> Right click the folder->Properties->Security, and check the NTFS
> permission.
> You may add ASPNET account to SQL Server login, and grant it sysadmin role
> to isolate the issue
> In management studio, find security->login, and add the account
> <computername>\aspnet, and grant it sysadmin role.
> You could try to connect to ReportServer and reports VDs to test the
> situation. You may want to try to initialize RS via RS configuration tool
> before doing so.
> If you encounter "cannot connect to reportserver database" error, try to
> run the following command to re-configure database connection of RS:
> rsconfig -s -d reportserver -a Windows -U <domain user account that want
> to use> -P <password of the domain user>
> Please let me know if you have any update. Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
You could try the following command to reconfigure your reporting service:
rsconfig -s -d reportserver -a Windows -U <domain user account that want >
to use> -P <password of the domain user>
For example, your servername is server1, you have domain account
domain1\user1, and password is pass1. The account has sysadmin role on SQL
Server. You want reporting server to use this user's credential to connect
to SQL 2000 and backend reportserver database (YOu could confirm the
database name in enterprise manager of SQL Server, since you reinstall RS,
you may find 2 reportserver databases, please make sure the one you want).
You could use the following command:
rsconfig -s server1 -d reportserver -a Windows -U domain1\user1 -P pass1
More related information:
How to move a Reporting Services database from a computer that is running
Reporting Services to another computer
http://support.microsoft.com/default.aspx?scid=842425
I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hello Adam,
Just want to check in if you have further questions on the issue. Please
feel free to post back if need any help.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||--
adam
""privatenews"" wrote:
> Hello Adam,
> Just want to check in if you have further questions on the issue. Please
> feel free to post back if need any help.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hello Adam,
It seems you post this by accident. Not sure if you need further assistance
on this issue? I look forward to your reply. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
From: =?Utf-8?B?YWRhbQ==?= <adam@.noemail.noemail>
Subject: RE: Report Server is not responding for XP2 sp2 and SQL Server 05
Date: Tue, 8 Aug 2006 07:51:01 -0700
Newsgroups: microsoft.public.sqlserver.reportingsvcs
adam