ReportBuilder : Download Error

I am having problem running Report Builder. Error summary says this.

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://rs.mycompany.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ Unable to connect to the remote server
+ An established connection was aborted by the software in your host machine

It was working like Champ couple of days back. There has been some firewall policy changes happened between today and day it worked. I am suspecting something to do with firewall. But I am not sure. somebody please help.

Pleaseeee HELP!

Thanks,

have you tried changing the security of the report builder virtual folder to anonymous?

Report Viewer web part in Sharepoint 2.0 site

Hello:
I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
to display a report when a page loads using just the page viewer web
part.
In the properties of the web part, I have http://portal:81/Reports/Pages/Report.aspx?
in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
+Sellers in the Report Path field.
When I hit apply, the web part displays "A required argument is
missing from the URL that opens this page: ItemPath".
What am I doing wrong here?
Any assistance is appreciated.
Thanks in advance.
-JoeNever mind. I had the report server URL incorrect (it should have
been just http://portal:81/reports) and the report path should have
just been /repvendorportal/Top Sellers. The + was causing a problem
too.
Thanks.
-Joe
On Nov 8, 1:14 pm, Joe <j...@.josephmarkovich.com> wrote:
> Hello:
> I'm running the SSRS 2005 web parts in a Sharepoint 2.0 site. I want
> to display a report when a page loads using just the page viewer web
> part.
> In the properties of the web part, I havehttp://portal:81/Reports/Pages/Report.aspx?
> in the Report Manager URL field and itempath=%2fRepVendorPortal%2fTop
> +Sellers in the Report Path field.
> When I hit apply, the web part displays "A required argument is
> missing from the URL that opens this page: ItemPath".
> What am I doing wrong here?
> Any assistance is appreciated.
> Thanks in advance.
> -Joe

Report Viewer trying to get it running and having problems

I have a website with two textboxes. I am passing those text boxes as parameters into the Report Viewer. I receive this error: "An error has occurred during report processing. ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'GetData' that has no parameters."

I thought I had the xsd and rdlc set up properly but obviously I am missing something. If you can step me through this I would appreciate it.

Look in the control ObjectDataSource this control have the Property Select Method and Select Parmaters .

The Select Method must be with the parameters EJ: GetData(idcity)

In Select Parameters you have to add the parameter -- one for each textbox

You can send me the code for more help :victormartineze@.gmail.com

Sorry i dont speack english

Report Viewer Control to display reports

I have reports designed and deployed at the report server running Sql 2005
SSRS. I want to display those report in a vb.net Windows application using a
report viewer control and I have searched the internet for the past 2 weeks
and I still can not find anything or samples on how to do this. I wonder if
it is doable. Thanks.Paul,
You should find the report viewer reference at
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms(vs.80).aspx .
However, if you want just to show a predefined report for the end users,
Visual Studio offers the basic settings for the control, such as Report
server and report name. It is not a big magic :)
I got this sample, hope it will help for you.
http://www.devx.com/dotnet/Article/30424
Regards,
Janos
"Paul" <paul_mak@.shaw.ca> wrote in message
news:O2CwgFviHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I have reports designed and deployed at the report server running Sql 2005
>SSRS. I want to display those report in a vb.net Windows application using
>a report viewer control and I have searched the internet for the past 2
>weeks and I still can not find anything or samples on how to do this. I
>wonder if it is doable. Thanks.
>|||Some great samples at http://www.gotreportviewer.com
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Paul" <paul_mak@.shaw.ca> wrote in message
news:O2CwgFviHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I have reports designed and deployed at the report server running Sql 2005
>SSRS. I want to display those report in a vb.net Windows application using
>a report viewer control and I have searched the internet for the past 2
>weeks and I still can not find anything or samples on how to do this. I
>wonder if it is doable. Thanks.
>

Report timeout after 60 minutes

I'm running a long report from Reporting Services web site. When I run
the stored procedure by itself, it executes with no problem, taking
about 3 hours to complete. When I execute the report itself, it runs
for exactly 60 minutes and after that I get "The page can not be
displayed" message. I played around with session timeouts and report
execution timeout setting both of these to 5 hours, however that didn't
give any positive results. I'm beginning to think that it maybe some
IIS issue. I also increased the connection timeout in IIS to 5 hours.
Does anyone have any clues?
I'm running this on Windows 2000, IIS 5.
Thank you.
-IKI solved the problem myself. Looks like IE version 5.x and higher,
have 60 minute time-out limit.
A quick registry setting and a restart fixes the problem.
1. Add a ReceiveTimeout DWORD value with a data value of (<number of
seconds>)*1000 in the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet
Settings
For example, if you want the timeout duration to be 8 minutes, set the
ReceiveTimeout data value to 480000 (<480>*1000).
2. Restart your computer.
You can find more info at:
http://support.microsoft.com/kb/q181050/
-IK|||hi IK,
one clarification.
need to set this on the server or on the client.
i am adjusting this setting on a comp connecting to the server and checking
this out.
would be quite a relief to get round this one.
thanks for your note,
SamK
"IK" wrote:
> I solved the problem myself. Looks like IE version 5.x and higher,
> have 60 minute time-out limit.
> A quick registry setting and a restart fixes the problem.
> 1. Add a ReceiveTimeout DWORD value with a data value of (<number of
> seconds>)*1000 in the following registry key:
> HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet
> Settings
> For example, if you want the timeout duration to be 8 minutes, set the
> ReceiveTimeout data value to 480000 (<480>*1000).
> 2. Restart your computer.
>
> You can find more info at:
> http://support.microsoft.com/kb/q181050/
> -IK
>sql

Report timeout - long running SPROC

Hi all,
I have a SPROC that returns 773,923 rows and takes 13mins to execute in SQL
Query Analyzer.
I think I have increased all available timeout and session settings, but the
report returns page cannot be displayed.
The same happens when I try to create a snapshot.
Any ideas?
Thank you in advance.
Cheers
ShaneThis is a very bad idea. RS renders everything in RAM. Depending on the
format it can take varying amounts of time. If you try to render to PDF or
Excel (can Excel even take that many rows, I'm not sure what the limit is
now, it was 64K in Excel 2000) it will most likely never finish. What are
you trying to do, a human will never look at that many rows. If you are
trying to do data extraction then there are better technologies to use. HTML
is fast and might be possible but not sure what it buys you since this is
probably 100,000 rows of data. I suggest reading up on drill through, that
is a very good technique for navigating large amounts of data. If you
explain what you are trying to do there might be some other way to
accomplish it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
news:86D96692-5AD5-4BC0-953D-99A53D623AE3@.microsoft.com...
> Hi all,
> I have a SPROC that returns 773,923 rows and takes 13mins to execute in
> SQL
> Query Analyzer.
> I think I have increased all available timeout and session settings, but
> the
> report returns page cannot be displayed.
> The same happens when I try to create a snapshot.
> Any ideas?
> Thank you in advance.
> Cheers
> Shane|||Thanks for taking the time to read my post Bruce.
The report is an age trial balance for our entire organisation. So each line
(all 773,923 rows) are invoice lines.
It allows our snr management to see what debt are owed to our company.
I use a drill down so when the report is initially loaded you see each of my
company's regions (10 of them) and the sum of the money owed by age 30 Days,
60-90 Days, 120+ Days...
If you click on the + it expands to reveal the different general leger
accounts and the sum of the money owed by age 30 Days, 60-90 Days, 120+
Days...
If you click on the + again, it will display the person who owes the money
and the sum of the money owed by age 30 Days, 60-90 Days, 120+ Days...
If you click on the + again, it will display each of the invoice details..
The report is being rendered in HTML and I also want the execution snapshot
to be rendered in HTML as well.
Cheers,
Shane
"Bruce L-C [MVP]" wrote:
> This is a very bad idea. RS renders everything in RAM. Depending on the
> format it can take varying amounts of time. If you try to render to PDF or
> Excel (can Excel even take that many rows, I'm not sure what the limit is
> now, it was 64K in Excel 2000) it will most likely never finish. What are
> you trying to do, a human will never look at that many rows. If you are
> trying to do data extraction then there are better technologies to use. HTML
> is fast and might be possible but not sure what it buys you since this is
> probably 100,000 rows of data. I suggest reading up on drill through, that
> is a very good technique for navigating large amounts of data. If you
> explain what you are trying to do there might be some other way to
> accomplish it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
> news:86D96692-5AD5-4BC0-953D-99A53D623AE3@.microsoft.com...
> > Hi all,
> >
> > I have a SPROC that returns 773,923 rows and takes 13mins to execute in
> > SQL
> > Query Analyzer.
> >
> > I think I have increased all available timeout and session settings, but
> > the
> > report returns page cannot be displayed.
> >
> > The same happens when I try to create a snapshot.
> >
> > Any ideas?
> >
> > Thank you in advance.
> >
> > Cheers
> >
> > Shane
>
>|||OK, that is what I thought. Drill downs are great. Very intuitive.
Unfortunately they require all the data to be present. So although it is
great for the user it is not so a great a solution for speed. What I suggest
is to change this to limit the amount of data. Perhaps make it a combination
of drilldown and drillthrough. For instance, how much data is decreased if
you do a drillthrough for the involice details. Or perhaps the Person and
the invoice details. Make that it's own report with the appropriate
parameters and then drill through to it. My guess is that the sp would speed
up tremendously and the amount of data being dealt with by RS would drop to
a manageable level. My users (a very wide range from production operators to
management) have found drillthough to be very intuitive.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
news:3A3D9583-DF23-43B9-806F-0B4DD3A68F12@.microsoft.com...
> Thanks for taking the time to read my post Bruce.
> The report is an age trial balance for our entire organisation. So each
> line
> (all 773,923 rows) are invoice lines.
> It allows our snr management to see what debt are owed to our company.
> I use a drill down so when the report is initially loaded you see each of
> my
> company's regions (10 of them) and the sum of the money owed by age 30
> Days,
> 60-90 Days, 120+ Days...
> If you click on the + it expands to reveal the different general leger
> accounts and the sum of the money owed by age 30 Days, 60-90 Days, 120+
> Days...
> If you click on the + again, it will display the person who owes the money
> and the sum of the money owed by age 30 Days, 60-90 Days, 120+ Days...
> If you click on the + again, it will display each of the invoice details..
> The report is being rendered in HTML and I also want the execution
> snapshot
> to be rendered in HTML as well.
> Cheers,
> Shane
> "Bruce L-C [MVP]" wrote:
>> This is a very bad idea. RS renders everything in RAM. Depending on the
>> format it can take varying amounts of time. If you try to render to PDF
>> or
>> Excel (can Excel even take that many rows, I'm not sure what the limit is
>> now, it was 64K in Excel 2000) it will most likely never finish. What are
>> you trying to do, a human will never look at that many rows. If you are
>> trying to do data extraction then there are better technologies to use.
>> HTML
>> is fast and might be possible but not sure what it buys you since this is
>> probably 100,000 rows of data. I suggest reading up on drill through,
>> that
>> is a very good technique for navigating large amounts of data. If you
>> explain what you are trying to do there might be some other way to
>> accomplish it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
>> news:86D96692-5AD5-4BC0-953D-99A53D623AE3@.microsoft.com...
>> > Hi all,
>> >
>> > I have a SPROC that returns 773,923 rows and takes 13mins to execute in
>> > SQL
>> > Query Analyzer.
>> >
>> > I think I have increased all available timeout and session settings,
>> > but
>> > the
>> > report returns page cannot be displayed.
>> >
>> > The same happens when I try to create a snapshot.
>> >
>> > Any ideas?
>> >
>> > Thank you in advance.
>> >
>> > Cheers
>> >
>> > Shane
>>|||Thanks again Bruce.
I think the drillthrough idea sounds like a good one. Similar to this Sample
report:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_samplereports_v1_4z95.asp
I'll give it a go and let you know how I go! :)
Cheers,
Shane
"Bruce L-C [MVP]" wrote:
> OK, that is what I thought. Drill downs are great. Very intuitive.
> Unfortunately they require all the data to be present. So although it is
> great for the user it is not so a great a solution for speed. What I suggest
> is to change this to limit the amount of data. Perhaps make it a combination
> of drilldown and drillthrough. For instance, how much data is decreased if
> you do a drillthrough for the involice details. Or perhaps the Person and
> the invoice details. Make that it's own report with the appropriate
> parameters and then drill through to it. My guess is that the sp would speed
> up tremendously and the amount of data being dealt with by RS would drop to
> a manageable level. My users (a very wide range from production operators to
> management) have found drillthough to be very intuitive.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
> news:3A3D9583-DF23-43B9-806F-0B4DD3A68F12@.microsoft.com...
> > Thanks for taking the time to read my post Bruce.
> >
> > The report is an age trial balance for our entire organisation. So each
> > line
> > (all 773,923 rows) are invoice lines.
> >
> > It allows our snr management to see what debt are owed to our company.
> >
> > I use a drill down so when the report is initially loaded you see each of
> > my
> > company's regions (10 of them) and the sum of the money owed by age 30
> > Days,
> > 60-90 Days, 120+ Days...
> >
> > If you click on the + it expands to reveal the different general leger
> > accounts and the sum of the money owed by age 30 Days, 60-90 Days, 120+
> > Days...
> >
> > If you click on the + again, it will display the person who owes the money
> > and the sum of the money owed by age 30 Days, 60-90 Days, 120+ Days...
> >
> > If you click on the + again, it will display each of the invoice details..
> >
> > The report is being rendered in HTML and I also want the execution
> > snapshot
> > to be rendered in HTML as well.
> >
> > Cheers,
> >
> > Shane
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> This is a very bad idea. RS renders everything in RAM. Depending on the
> >> format it can take varying amounts of time. If you try to render to PDF
> >> or
> >> Excel (can Excel even take that many rows, I'm not sure what the limit is
> >> now, it was 64K in Excel 2000) it will most likely never finish. What are
> >> you trying to do, a human will never look at that many rows. If you are
> >> trying to do data extraction then there are better technologies to use.
> >> HTML
> >> is fast and might be possible but not sure what it buys you since this is
> >> probably 100,000 rows of data. I suggest reading up on drill through,
> >> that
> >> is a very good technique for navigating large amounts of data. If you
> >> explain what you are trying to do there might be some other way to
> >> accomplish it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Shane" <s.dixon@.hia.asn.auNOSPAM> wrote in message
> >> news:86D96692-5AD5-4BC0-953D-99A53D623AE3@.microsoft.com...
> >> > Hi all,
> >> >
> >> > I have a SPROC that returns 773,923 rows and takes 13mins to execute in
> >> > SQL
> >> > Query Analyzer.
> >> >
> >> > I think I have increased all available timeout and session settings,
> >> > but
> >> > the
> >> > report returns page cannot be displayed.
> >> >
> >> > The same happens when I try to create a snapshot.
> >> >
> >> > Any ideas?
> >> >
> >> > Thank you in advance.
> >> >
> >> > Cheers
> >> >
> >> > Shane
> >>
> >>
> >>
>
>

Report snapshot generation failed on MDX script

Hi,

I am running RS 2005 and Analysis Services 2005. I was able to get RS to connect to the OLAP database (via stored credential) when generating snapshot. However, it failed when processing MDX script in the report dataset. The same report works fine in browser and VStudio, but only failed during snapshot or cache generation. Below is the error message and the affected MDX script. Any help would be appreciated!

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Get Online Help

Query execution failed for data set 'PU_Floorcovering'. (rsErrorExecutingCommand) Get Online Help

Incorrect syntax near '{'. Incorrect syntax near 'Business Type'. Incorrect syntax near 'Facility'. Incorrect syntax near 'Production Units Reporting UOM'.

WITH SET [UOM] AS

' ([Raw Materials Source UOM].[Source UOM].ALLMEMBERS - [Raw Materials Source UOM].[Source UOM].[All]) *

([Raw Materials Reporting UOM].[Reporting UOM].ALLMEMBERS - [Raw Materials Reporting UOM].[Reporting UOM].[All]) *

([Production Units Source UOM].[PU Source UOM].ALLMEMBERS - [Production Units Source UOM].[PU Source UOM].[All]) *

([Production Units Reporting UOM].[PU Reporting UOM].ALLMEMBERS - [Production Units Reporting UOM].[PU Reporting UOM].[All])'

SELECT NON EMPTY

{

[Measures].[Weight], [Measures].[Weight per Production Unit Converted]

} ON COLUMNS,

NON EMPTY

{

(([Time].[Year].ALLMEMBERS - [Time].[Year].[All]) *

([Raw Materials].[Category Type].ALLMEMBERS - [Raw Materials].[Category Type].[All]) *

([Raw Materials].[Category].ALLMEMBERS - [Raw Materials].[Category].[All]) *

[UOM])

}

having not IsEmpty([Measures].[Weight]) And ([Measures].[All Facilities Production Unit Converted], [Production Units].[UOM]) > 0

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

FROM

(

SELECT ( { [Business Type].[Business Type].&[{11116DDD-FD7B-46AA-A4D8-73492E220001}]}) ON COLUMNS

FROM

(

SELECT ({[Raw Materials Reporting UOM].[Reporting UOM].&[Lb]}) ON COLUMNS

FROM

(

SELECT ({[Production Units Reporting UOM].[PU Reporting UOM].&[Yd2]}) ON COLUMNS FROM [Pinnacle]

)

)

)

WHERE

(

[Facility].[LocationType].&[1],

[Facility].[Initiative - InitiativeFacility].[Initiative].&[{11136DDD-FD7B-46AA-A4D8-73492E220002}]

)

CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

- SouBee

It was a mistake on my part. The data source was set to MS SQL Server, instead it should be MS SQL Analysis Services.

Thanks.

SouBee

Report Services Install problems!

Installing Reporting Services with IIS and Report Services running on one
machine and Reporting databases on remote SQL Server. Getting the error below
when attempting to view http://servername/reports page.
Any ideas?
Thanks.
Frank
Server Error in '/Reports' Application
----
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Unable to load file
'ReportingServicesEmailDeliveryProvider'.
Source Error:
Line 256: <add assembly="System.EnterpriseServices,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 257: <add assembly="System.Web.Mobile,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 258: <add assembly="*"/>
Line 259: </assemblies>
Line 260:
Source File: c:\nos\microsoft.net\framework\v1.1.4322\Config\machine.config
Line: 258
Assembly Load Trace: The following information can be helpful to determine
why the assembly 'ReportingServicesEmailDeliveryProvider' could not be loaded.
=== Pre-bind state information === LOG: DisplayName = ReportingServicesEmailDeliveryProvider
(Partial)
LOG: Appbase = file:///D:/ReportingServices/MSSQL/Reporting
Services/ReportManager
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===
LOG: Policy not being applied to reference at this time (private, custom,
partial, or location-based assembly bind).
LOG: Post-policy reference: ReportingServicesEmailDeliveryProvider
LOG: Attempting download of new URL
file:///C:/NOS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/reports/a21cac91/f4eaffac/ReportingServicesEmailDeliveryProvider.DLL.
LOG: Attempting download of new URL
file:///C:/NOS/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET
Files/reports/a21cac91/f4eaffac/ReportingServicesEmailDeliveryProvider/ReportingServicesEmailDeliveryProvider.DLL.
LOG: Attempting download of new URL
file:///D:/ReportingServices/MSSQL/Reporting
Services/ReportManager/bin/ReportingServicesEmailDeliveryProvider.DLL.
LOG: Publisher policy file is not found.
LOG: No redirect found in host configuration file
(C:\NOS\Microsoft.NET\Framework\v1.1.4322\aspnet.config).
LOG: Using machine configuration file from
C:\NOS\Microsoft.NET\Framework\v1.1.4322\config\machine.config.
LOG: Post-policy reference: ReportingServicesEmailDeliveryProvider,
Version=8.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032> Server Error in '/Reports' Application.
> ----
--
> Configuration Error
> Description: An error occurred during the processing of a configuration
file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
> Parser Error Message: Unable to load file
> 'ReportingServicesEmailDeliveryProvider'.
> Source Error:
>
> Line 256: <add assembly="System.EnterpriseServices,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> Line 257: <add assembly="System.Web.Mobile,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> Line 258: <add assembly="*"/>
> Line 259: </assemblies>
> Line 260:
>
Which OS? Is it a Domain controller?
I received the same message on my lab computer after making it domain
controller (Win2K, SP4). In KB824308 I found some useful information that
helped me to some extent. Now rs is at least able to show part of the
standard page.
I still receive an error, though: "Internal error. The profile for the user
is a temporary profile". Aaaaaargh!
Leif|||Windows 2003 Server. I was told that it is not a domain controller. I will
look at the kb article. hopefully it applies. Thanks. Frank
"Leif" wrote:
> > Server Error in '/Reports' Application.
> > ----
> --
> >
> > Configuration Error
> > Description: An error occurred during the processing of a configuration
> file
> > required to service this request. Please review the specific error details
> > below and modify your configuration file appropriately.
> >
> > Parser Error Message: Unable to load file
> > 'ReportingServicesEmailDeliveryProvider'.
> >
> > Source Error:
> >
> >
> > Line 256: <add assembly="System.EnterpriseServices,
> > Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> > Line 257: <add assembly="System.Web.Mobile,
> > Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> > Line 258: <add assembly="*"/>
> > Line 259: </assemblies>
> > Line 260:
> >
> Which OS? Is it a Domain controller?
> I received the same message on my lab computer after making it domain
> controller (Win2K, SP4). In KB824308 I found some useful information that
> helped me to some extent. Now rs is at least able to show part of the
> standard page.
> I still receive an error, though: "Internal error. The profile for the user
> is a temporary profile". Aaaaaargh!
> Leif
>
>

Report Services - capture userid of person running the report

I have a report which executes a stored procedure when the report is opened. What function will capture the identity ( name or user id ) of the person opening the report and therefore executing the procedure?

At what point in the stack are you trying to get the userid? Within the SP, or within the report expressions?

From within the report, you can use User!UserId. If you want to get the login that is currently executing the SP from within the SP, then you can use system_user (http://msdn2.microsoft.com/en-us/library/ms179930.aspx).

|||More specifics please|||

the first parameter of the report is UserId, string, hidden

the available value is label UserId with value =User!UserID. The default value is non-queried =User!UserID

the data source is: exec ReportBase.dbo.proc_TestUser '01/01/2006','01/02/2006',@.UserID

the procedure is:

-- =============================================

-- Create basic stored procedure template

-- =============================================

use ReportBase

GO

-- Drop stored procedure if it already exists

IF EXISTS (

SELECT *

FROM INFORMATION_SCHEMA.ROUTINES

WHERE SPECIFIC_SCHEMA = N'dbo'

AND SPECIFIC_NAME = N'proc_TestUser'

)

DROP PROCEDURE dbo.proc_TestUser

GO

CREATE PROCEDURE dbo.proc_TestUser

@.Date1 as datetime,

@.Date2 as datetime,

@.UserID as varchar(100)

AS

-- drop table ReportBase.dbo.t_UserTest

/*

create table ReportBase.dbo.t_UserTest (

[first_date] [datetime] NULL ,

[second_date] [datetime] NULL ,

[user_name] [varchar](100) NULL )

*/

insert into ReportBase.dbo.t_UserTest

select @.Date1, @.Date2, @.UserID

select * from ReportBase.dbo.t_UserTest

go

Report Services - capture userid of person running the report

I have a report which executes a stored procedure when the report is opened. What function will capture the identity ( name or user id ) of the person opening the report and therefore executing the procedure?

At what point in the stack are you trying to get the userid? Within the SP, or within the report expressions?

From within the report, you can use User!UserId. If you want to get the login that is currently executing the SP from within the SP, then you can use system_user (http://msdn2.microsoft.com/en-us/library/ms179930.aspx).

|||More specifics please|||

the first parameter of the report is UserId, string, hidden

the available value is label UserId with value =User!UserID. The default value is non-queried =User!UserID

the data source is: exec ReportBase.dbo.proc_TestUser '01/01/2006','01/02/2006',@.UserID

the procedure is:

-- =============================================

-- Create basic stored procedure template

-- =============================================

use ReportBase

GO

-- Drop stored procedure if it already exists

IF EXISTS (

SELECT *

FROM INFORMATION_SCHEMA.ROUTINES

WHERE SPECIFIC_SCHEMA = N'dbo'

AND SPECIFIC_NAME = N'proc_TestUser'

)

DROP PROCEDURE dbo.proc_TestUser

GO

CREATE PROCEDURE dbo.proc_TestUser

@.Date1 as datetime,

@.Date2 as datetime,

@.UserID as varchar(100)

AS

-- drop table ReportBase.dbo.t_UserTest

/*

create table ReportBase.dbo.t_UserTest (

[first_date] [datetime] NULL ,

[second_date] [datetime] NULL ,

[user_name] [varchar](100) NULL )

*/

insert into ReportBase.dbo.t_UserTest

select @.Date1, @.Date2, @.UserID

select * from ReportBase.dbo.t_UserTest

go

Report Server Windows Service stops running.

I have a test server running both 2000 and 2005 Reporting Services. Each day I have to restart the Report Server Windows service for the 2005 Report Server. This is the error I get when I try to access the Report Manager

The Report Server Windows service 'ReportServer$TSQL4' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) Get Online Help

After I start the Report Server Windows service using the Report Services Configuration tool I can access the 2005 Report Manager without errors. The windows service start up type is set to automatic.

I can not find why the 2005 version keeps going down.

Couple things to check:

1. Windows Event Viewer Application log

2. Report Server service log file -- ReportServerService*.log

There should be some "light" in 1 or both of these that will illuminate the underlying problem.

Report Server Windows service account

Someone posted a similar question a while ago, but I didn't see any reply.
Now I'm running into the same issue, and hopefully someone knows the
definitive answer this time.
In rssetup.chm, Microsoft recommends using Local System to run the
ReportServer service for the following reason:
"If you use a domain user account (even one that has local administrator
privileges), it will limit your choices on how to configure a data source
connection for a report as well as introduce new configuration steps that
are not otherwise required. Specifically, you cannot use prompted or stored
Windows credentials to connect to external data sources. Additionally, you
must create a special user account to support unattended report processing."
However, in readme_en.htm, Microsoft says that you must use a domain
account. Here's an excerpt from the readme file:
"1.10 Domain user account requirement for subscriptions and ReportServer
Windows service running under Windows 2000 or Windows XP
If the ReportServer Windows service is running under Windows 2000 or Windows
XP, you must configure the service to run under a domain account. If you use
an account that does not have sufficient domain permissions, subscription
delivery will fail when the report server attempts to deliver reports to
domain user accounts. The following error occurs when report delivery fails
due to authorization and domain access issues: Failure sending mail: The
Report Server has encountered a configuration error."
I guess since readme comes after the setup.chm, the formers supercedes the
latter. However, I have been running the service using Local System and have
not run into any problems so far. Now, we need to settle on a standard
regarding the service account. But I'm not sure which recommendation to
follow.
LinchiI ran into the same thing... no problems until I tried to use the file
share subscription instead of email. Even specifying a valid domain
account in the subscription config didn't help.
With a domain account I didn't have that problem (though it took me
awhile to discver that backing up and restoring the encryption key is
required when changing the service account).

Report server times out with error "report server is not responding"

Hi. We have RS2005/SP1 installed on Win2003/SP1. When we first installed it and it was running under Windows Authentication, we did not notice any slowness or timeouts while working with Report Manager or Management Studio. However, after we switched to Forms Authentication and set up the security extension sample provided, both the Report Manager and Management Studio (connected to Reporting Services) started to time out very often (even when simply browsing through the folders). It seems that Report Manager is timing out more often than Management Studio, however. After Report Manager times out, if I click the "Home" link or hit the "Back" button and try the same operation again, it usually works. The next few clicks work fine and I get a quick response, then it times out again.

Any help would be appreciated. Thanks

- Mark

Hi Mark,

We have not seen this problem reported before. I will take a look and if there is anything we can do about it, I will let you know.

|||

Hi Brad.

Have you been able to gather any information on this? Any suggestions as far as things to try to troubleshoot the issue?

Thanks

- Mark

|||

Hi Mark,

I did not get very far with this one. One person I talked to said to make the timeout in the Web.config file longer for SessionState. I looked and found the following in my web.config

<sessionState mode="InProc" cookieless="false" timeout="20" />

You could try changing this value to 100 or changing cookieless to true.

Otherwise I have not heard of anything to help on this one.

One other item to look at is the Web.Config settings in the following link.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp

Report Server Subscriptions - Job Owner

Hi,
I am trying to setup a subscription but I keep running into problems.
I setup the subscription fine, I see that it creates a job in SQL
Server. It shows a specific domain account as the owner and I can't
figure out why. The problem is that this account is in a different
domain and it's having problems authenticating when it runs. I did use
this account for the services and whatnot when I originally set it up,
but I've changed the account that SQL Server and SQL Server Agent run
under, but it still uses this account as the owner. The only other
thing I can think of is that the database owner of
SystemCenterReporting is still this account. Is this why it's listing
this account as the owner of the job? Where else could it be?
Thanks,
Bill"zinck74" <zinck74@.hotmail.com> wrote in message
news:1105995617.343495.223770@.f14g2000cwb.googlegr oups.com...
> Hi,
> I am trying to setup a subscription but I keep running into problems.
> I setup the subscription fine, I see that it creates a job in SQL
> Server. It shows a specific domain account as the owner and I can't
> figure out why. The problem is that this account is in a different
> domain and it's having problems authenticating when it runs. I did use
> this account for the services and whatnot when I originally set it up,
> but I've changed the account that SQL Server and SQL Server Agent run
> under, but it still uses this account as the owner. The only other
> thing I can think of is that the database owner of
> SystemCenterReporting is still this account. Is this why it's listing
> this account as the owner of the job? Where else could it be?
> Thanks,
> Bill

I have no idea about Reporting Services, but the SQL job owner is the SQL
login which creates the job. If RS is running under a certain domain account
to access MSSQL, then I guess that would be the account which owns the
subscription job.

The MS RS Deployment Guide is a bit vague - it seems to recommend a domain
account for the RS service, but doesn't say exactly what permissions it
needs:

http://www.microsoft.com/technet/pr...oy/rsdepgd.mspx

You might get a better response in microsoft.public.sqlserver.reportingsvcs.

Simon|||Thanks. The answer ended up being running the rsconfig.exe utility.
Didn't know this existed, but the account used with this is who the
owner is of the job.

Report server service wont start

Windows server 2000 sp4.

Has existing sql server 2000 development running.

Installed sql server 2005 as instance name=sqlserver2005.

Reporting server configuration panel - Server status - Start service fails

The tellmemore link shows:

System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

The Application event log shows:

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'NTSERVER1\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

AnyOne?

Jerry Cicierega

I found the answer:

http://support.microsoft.com/?kbid=911846

Thanx

Report Server Roles - Gaining access to

Does anyone out there know how to programatically determine the Role(s) of
the Logged In User running a report?
Thanks,
Bill MellOn Sep 19, 12:44 pm, "Bill Mell" <Bi...@.netforcement.com> wrote:
> Does anyone out there know how to programatically determine the Role(s) of
> the Logged In User running a report?
> Thanks,
> Bill Mell
You can pass back a hidden parameter from the report set to this
expression:
=User!UserID.ToString
Then in the stored procedure/query that is sourcing the report, run
the following query to obtain the associated roles.
SELECT R.ROLENAME
FROM REPORTSERVER.DBO.USERS AS U
INNER JOIN REPORTSERVER.DBO.POLICYUSERROLE AS P ON U.USERID = P.USERID
INNER JOIN REPORTSERVER.DBO.ROLES AS R ON P.ROLEID = R.ROLEID
WHERE U.USERNAME = @.UserName;
In this query, the @.UserName gets its value from the hidden parameter.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I am actually trying to get the information before the report actually runs.
I have a custom web page to gather parameters for the report.
It seems, that at the time the web page is called, the User!UserID is not
loaded (or if it is, it is empty)
It is in the web page that I need this info.
Do you know of a way to get that info in this scenario?
Thanks,
Bill Mell
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1190254670.163591.20770@.y42g2000hsy.googlegroups.com...
> On Sep 19, 12:44 pm, "Bill Mell" <Bi...@.netforcement.com> wrote:
> > Does anyone out there know how to programatically determine the Role(s)
of
> > the Logged In User running a report?
> >
> > Thanks,
> > Bill Mell
>
> You can pass back a hidden parameter from the report set to this
> expression:
> =User!UserID.ToString
> Then in the stored procedure/query that is sourcing the report, run
> the following query to obtain the associated roles.
> SELECT R.ROLENAME
> FROM REPORTSERVER.DBO.USERS AS U
> INNER JOIN REPORTSERVER.DBO.POLICYUSERROLE AS P ON U.USERID = P.USERID
> INNER JOIN REPORTSERVER.DBO.ROLES AS R ON P.ROLEID = R.ROLEID
> WHERE U.USERNAME = @.UserName;
> In this query, the @.UserName gets its value from the hidden parameter.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||We have created many User Aware Reports which pass the user id back to
the query which selects the data required.
It would seem the report should have this built in so no sensitive
data is called where as if you rely on the web page to pass this
parameter, there might be a security loop-hole.
You can pass other parameters from the web page which basically pass
these on to the parameters in the report.
If you run the report by itself and select the parameters you will see
them in the url.
The login/userid should be called there but rather as part of the
report itself as enrique has noted.
Regards,
Tom Bizannes
Microsoft Sql Server Specialist
http://www.macroview.com.au
Sydney, Australia

Report Server Not Responding

Hi ..
I installed SSRS on W2K Server machine also running SQL Server 2005; after
the install completion I keep getting the following message:
"The report server is not responding. Verify that the report server is
running and can be accessed from this computer"
when I type http://<serverName>/ReportManager into the Address box in IE 6
if I type http://<serverName>/ReportServer in I get the following:
"Reporting Services Error
An internal error occurred on the report server. See the error log for more
details. (rsInternalError)
For more information about this error navigate to the report server on the
local server machine, or enable remote errors"
All other virtual directories on the web server are working ok; one thing I
notice is that it looks like the configuration was set up to access SQL
Server Express in a connection string named "LocalSqlServer" ... I don't
have SQL Server Express installed on the machine .. and there is a
connection string pointing to an MDF file that I don't see anywhere; I
changed the connection string to point to my the SQL2005 instance but it
really seems kind of stupid and useless to do that since I don't know what
database ReportServer and ReportManager want to use ...
Right now, I'm baffled with this thing; it looks like it probably works
fine if you happen to have just the right original configuration anticipated
by the team that designed the installers ... otherwise, you have a headache
...
so if anyone has some suggestions or info links I'd really appreciate it
...
TIAHi,
I am also working on the installing reporting Services , getting a different
error .
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.
did you replace <servername> with localhost ?|||"Reshma" <Reshma@.discussions.microsoft.com> wrote in message
news:3DBD066C-F341-4AE9-9FF3-70AA30621E77@.microsoft.com...
> Hi,
> I am also working on the installing reporting Services , getting a
> different
> error .
> The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> did you replace <servername> with localhost ?
replace it where? I've used it in the IE address box ... doesn't work with
<localhost> OR <serverName> ...
all I'm getting is, "The report server is not responding. Verify that the
report server is running and can be accessed from this computer" ... well,
I'm trying to "verify" and this is the answer ... kind of stuck in a loop
here ...
The underlying Windows Service IS running, at least according to Service
Manager ... but that's not helping ...

Report Server Instance

How do I reference a URL for a Report Server Running on an instance in SQL
Server 2005. I thought it was a $ sign but this is not working (i.e.
http://REPORTSERVER$DEVDW/Reports)
Default Instance : REPORTSERVER
URL: http://REPORTSERVER/Reports
Instance 1: REPORTSERVER\DEVDW
http://?/Reports
Instance 2; REPORTSERVER\PRODDW
http://?/ReportsGot it!!!
http://REPORTSERVER/Reports$INSTANCENAME
"Scott" wrote:
> How do I reference a URL for a Report Server Running on an instance in SQL
> Server 2005. I thought it was a $ sign but this is not working (i.e.
> http://REPORTSERVER$DEVDW/Reports)
> Default Instance : REPORTSERVER
> URL: http://REPORTSERVER/Reports
> Instance 1: REPORTSERVER\DEVDW
> http://?/Reports
> Instance 2; REPORTSERVER\PRODDW
> http://?/Reports

Report Server and Report Manager on different machines

It is possible to configure a system of servers such that
the Report Manager can be running on a separate machine
than the Report Server?
We are concerned about the security issues of exposing a
server with the Front Page Server Extensions installed on
it, because it will reside outside of our corporate
firewall. As an alternative, we are hoping we can host
the Web Server/IIS box outside the firewall, and have
this machine run the Report Manager, while another box
inside the firewall runs the Report Server (which,
incidentally, will also be a separate box than the data
server).
Whether the security concerns of FPSE are real or
perceived, our clients might not like them. So, is the
type of configuration described above at all possible?
If not, please explain why. If it is possible, please
explain how.
Thanks in advance!Front Page Server extensions are not necessary for Report Manager. Just to
make sure I checked one of my servers (Windows 2003) and the default website
which has Report Manager does not have FP server extension.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Justin" <anonymous@.discussions.microsoft.com> wrote in message
news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
> It is possible to configure a system of servers such that
> the Report Manager can be running on a separate machine
> than the Report Server?
> We are concerned about the security issues of exposing a
> server with the Front Page Server Extensions installed on
> it, because it will reside outside of our corporate
> firewall. As an alternative, we are hoping we can host
> the Web Server/IIS box outside the firewall, and have
> this machine run the Report Manager, while another box
> inside the firewall runs the Report Server (which,
> incidentally, will also be a separate box than the data
> server).
> Whether the security concerns of FPSE are real or
> perceived, our clients might not like them. So, is the
> type of configuration described above at all possible?
> If not, please explain why. If it is possible, please
> explain how.
> Thanks in advance!
>|||So, FPSE are only required on a Report Designer
installtion -- is that correct?
FPSE are a requirement for VisualStudio.NET installation,
which are required for Report Designer, right?
>--Original Message--
>Front Page Server extensions are not necessary for
Report Manager. Just to
>make sure I checked one of my servers (Windows 2003) and
the default website
>which has Report Manager does not have FP server
extension.
>--
>Bruce Loehle-Conger
>MVP SQL Server Reporting Services
>"Justin" <anonymous@.discussions.microsoft.com> wrote in
message
>news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
>> It is possible to configure a system of servers such
that
>> the Report Manager can be running on a separate machine
>> than the Report Server?
>> We are concerned about the security issues of exposing
a
>> server with the Front Page Server Extensions installed
on
>> it, because it will reside outside of our corporate
>> firewall. As an alternative, we are hoping we can host
>> the Web Server/IIS box outside the firewall, and have
>> this machine run the Report Manager, while another box
>> inside the firewall runs the Report Server (which,
>> incidentally, will also be a separate box than the data
>> server).
>> Whether the security concerns of FPSE are real or
>> perceived, our clients might not like them. So, is the
>> type of configuration described above at all possible?
>> If not, please explain why. If it is possible, please
>> explain how.
>> Thanks in advance!
>
>.
>|||No. FPSE are not required for anything. The report designer does not even
have to have IIS.
You've gotten a misconception from somewhere that this is required.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<anonymous@.discussions.microsoft.com> wrote in message
news:623d01c4cc37$d426d9c0$a401280a@.phx.gbl...
> So, FPSE are only required on a Report Designer
> installtion -- is that correct?
> FPSE are a requirement for VisualStudio.NET installation,
> which are required for Report Designer, right?
>
> >--Original Message--
> >Front Page Server extensions are not necessary for
> Report Manager. Just to
> >make sure I checked one of my servers (Windows 2003) and
> the default website
> >which has Report Manager does not have FP server
> extension.
> >
> >--
> >Bruce Loehle-Conger
> >MVP SQL Server Reporting Services
> >
> >"Justin" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
> >> It is possible to configure a system of servers such
> that
> >> the Report Manager can be running on a separate machine
> >> than the Report Server?
> >>
> >> We are concerned about the security issues of exposing
> a
> >> server with the Front Page Server Extensions installed
> on
> >> it, because it will reside outside of our corporate
> >> firewall. As an alternative, we are hoping we can host
> >> the Web Server/IIS box outside the firewall, and have
> >> this machine run the Report Manager, while another box
> >> inside the firewall runs the Report Server (which,
> >> incidentally, will also be a separate box than the data
> >> server).
> >>
> >> Whether the security concerns of FPSE are real or
> >> perceived, our clients might not like them. So, is the
> >> type of configuration described above at all possible?
> >> If not, please explain why. If it is possible, please
> >> explain how.
> >>
> >> Thanks in advance!
> >>
> >
> >
> >.
> >|||Yes, I guess I do have that misconception. I thought
that in order to deploy a report from the report designer
to the report server, FPSE were required.
I'm glad to hear that this is not the case. I'll check
out our servers again and try to verify this.
Thanks.
>--Original Message--
>No. FPSE are not required for anything. The report
designer does not even
>have to have IIS.
>You've gotten a misconception from somewhere that this
is required.
>--
>Bruce Loehle-Conger
>MVP SQL Server Reporting Services
><anonymous@.discussions.microsoft.com> wrote in message
>news:623d01c4cc37$d426d9c0$a401280a@.phx.gbl...
>> So, FPSE are only required on a Report Designer
>> installtion -- is that correct?
>> FPSE are a requirement for VisualStudio.NET
installation,
>> which are required for Report Designer, right?
>>
>> >--Original Message--
>> >Front Page Server extensions are not necessary for
>> Report Manager. Just to
>> >make sure I checked one of my servers (Windows 2003)
and
>> the default website
>> >which has Report Manager does not have FP server
>> extension.
>> >
>> >--
>> >Bruce Loehle-Conger
>> >MVP SQL Server Reporting Services
>> >
>> >"Justin" <anonymous@.discussions.microsoft.com> wrote
in
>> message
>> >news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
>> >> It is possible to configure a system of servers such
>> that
>> >> the Report Manager can be running on a separate
machine
>> >> than the Report Server?
>> >>
>> >> We are concerned about the security issues of
exposing
>> a
>> >> server with the Front Page Server Extensions
installed
>> on
>> >> it, because it will reside outside of our corporate
>> >> firewall. As an alternative, we are hoping we can
host
>> >> the Web Server/IIS box outside the firewall, and
have
>> >> this machine run the Report Manager, while another
box
>> >> inside the firewall runs the Report Server (which,
>> >> incidentally, will also be a separate box than the
data
>> >> server).
>> >>
>> >> Whether the security concerns of FPSE are real or
>> >> perceived, our clients might not like them. So, is
the
>> >> type of configuration described above at all
possible?
>> >> If not, please explain why. If it is possible,
please
>> >> explain how.
>> >>
>> >> Thanks in advance!
>> >>
>> >
>> >
>> >.
>> >
>
>.
>|||What you might be confused about is thinking about using Visual Studio for
regular ASP.Net development. It is common to have FPSE for that. However,
with RS you are not deploying webpages. What you are doing is using
webservices to deploy the RDL. If you look on the server you will see that
no files are even showing up there when you deploy. That is because the RDL
is being stored in the database, not in the file system.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Justin" <anonymous@.discussions.microsoft.com> wrote in message
news:176001c4ccc2$b3afef70$a501280a@.phx.gbl...
> Yes, I guess I do have that misconception. I thought
> that in order to deploy a report from the report designer
> to the report server, FPSE were required.
> I'm glad to hear that this is not the case. I'll check
> out our servers again and try to verify this.
> Thanks.
> >--Original Message--
> >No. FPSE are not required for anything. The report
> designer does not even
> >have to have IIS.
> >
> >You've gotten a misconception from somewhere that this
> is required.
> >
> >--
> >Bruce Loehle-Conger
> >MVP SQL Server Reporting Services
> >
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:623d01c4cc37$d426d9c0$a401280a@.phx.gbl...
> >> So, FPSE are only required on a Report Designer
> >> installtion -- is that correct?
> >>
> >> FPSE are a requirement for VisualStudio.NET
> installation,
> >> which are required for Report Designer, right?
> >>
> >>
> >> >--Original Message--
> >> >Front Page Server extensions are not necessary for
> >> Report Manager. Just to
> >> >make sure I checked one of my servers (Windows 2003)
> and
> >> the default website
> >> >which has Report Manager does not have FP server
> >> extension.
> >> >
> >> >--
> >> >Bruce Loehle-Conger
> >> >MVP SQL Server Reporting Services
> >> >
> >> >"Justin" <anonymous@.discussions.microsoft.com> wrote
> in
> >> message
> >> >news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
> >> >> It is possible to configure a system of servers such
> >> that
> >> >> the Report Manager can be running on a separate
> machine
> >> >> than the Report Server?
> >> >>
> >> >> We are concerned about the security issues of
> exposing
> >> a
> >> >> server with the Front Page Server Extensions
> installed
> >> on
> >> >> it, because it will reside outside of our corporate
> >> >> firewall. As an alternative, we are hoping we can
> host
> >> >> the Web Server/IIS box outside the firewall, and
> have
> >> >> this machine run the Report Manager, while another
> box
> >> >> inside the firewall runs the Report Server (which,
> >> >> incidentally, will also be a separate box than the
> data
> >> >> server).
> >> >>
> >> >> Whether the security concerns of FPSE are real or
> >> >> perceived, our clients might not like them. So, is
> the
> >> >> type of configuration described above at all
> possible?
> >> >> If not, please explain why. If it is possible,
> please
> >> >> explain how.
> >> >>
> >> >> Thanks in advance!
> >> >>
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >|||Yes, that makes sense. I think that is exactly where I
was going wrong.
Thanks again!
>--Original Message--
>What you might be confused about is thinking about using
Visual Studio for
>regular ASP.Net development. It is common to have FPSE
for that. However,
>with RS you are not deploying webpages. What you are
doing is using
>webservices to deploy the RDL. If you look on the server
you will see that
>no files are even showing up there when you deploy. That
is because the RDL
>is being stored in the database, not in the file system.
>--
>Bruce Loehle-Conger
>MVP SQL Server Reporting Services
>"Justin" <anonymous@.discussions.microsoft.com> wrote in
message
>news:176001c4ccc2$b3afef70$a501280a@.phx.gbl...
>> Yes, I guess I do have that misconception. I thought
>> that in order to deploy a report from the report
designer
>> to the report server, FPSE were required.
>> I'm glad to hear that this is not the case. I'll check
>> out our servers again and try to verify this.
>> Thanks.
>> >--Original Message--
>> >No. FPSE are not required for anything. The report
>> designer does not even
>> >have to have IIS.
>> >
>> >You've gotten a misconception from somewhere that this
>> is required.
>> >
>> >--
>> >Bruce Loehle-Conger
>> >MVP SQL Server Reporting Services
>> >
>> ><anonymous@.discussions.microsoft.com> wrote in message
>> >news:623d01c4cc37$d426d9c0$a401280a@.phx.gbl...
>> >> So, FPSE are only required on a Report Designer
>> >> installtion -- is that correct?
>> >>
>> >> FPSE are a requirement for VisualStudio.NET
>> installation,
>> >> which are required for Report Designer, right?
>> >>
>> >>
>> >> >--Original Message--
>> >> >Front Page Server extensions are not necessary for
>> >> Report Manager. Just to
>> >> >make sure I checked one of my servers (Windows
2003)
>> and
>> >> the default website
>> >> >which has Report Manager does not have FP server
>> >> extension.
>> >> >
>> >> >--
>> >> >Bruce Loehle-Conger
>> >> >MVP SQL Server Reporting Services
>> >> >
>> >> >"Justin" <anonymous@.discussions.microsoft.com>
wrote
>> in
>> >> message
>> >> >news:13c701c4cc24$f8a701c0$a501280a@.phx.gbl...
>> >> >> It is possible to configure a system of servers
such
>> >> that
>> >> >> the Report Manager can be running on a separate
>> machine
>> >> >> than the Report Server?
>> >> >>
>> >> >> We are concerned about the security issues of
>> exposing
>> >> a
>> >> >> server with the Front Page Server Extensions
>> installed
>> >> on
>> >> >> it, because it will reside outside of our
corporate
>> >> >> firewall. As an alternative, we are hoping we
can
>> host
>> >> >> the Web Server/IIS box outside the firewall, and
>> have
>> >> >> this machine run the Report Manager, while
another
>> box
>> >> >> inside the firewall runs the Report Server
(which,
>> >> >> incidentally, will also be a separate box than
the
>> data
>> >> >> server).
>> >> >>
>> >> >> Whether the security concerns of FPSE are real or
>> >> >> perceived, our clients might not like them. So,
is
>> the
>> >> >> type of configuration described above at all
>> possible?
>> >> >> If not, please explain why. If it is possible,
>> please
>> >> >> explain how.
>> >> >>
>> >> >> Thanks in advance!
>> >> >>
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>.
>

Report Server 2005 - SQL Server 2000/2005 for DB

Hi,
I am currently running SQL Server 2000 SP3 with Reporting Services 2000 SP2.
I am unable to upgrade the SQL Instance 2005, but would really like to
upgrade RS to 2005.
RS 2000 is currently installed on a separate server to the SQL Instance, but
the RS Databases (ReportServer and ReportServerTempDB) are installed on the
SQL 2000. Would it work to upgrade RS to 2005, but leave the databases on a
SQL Server 2000?
Cheers,
NinaThis is a supported configuration. I have done this but in my case SQL
Server DB was on the same machine. However, I do know that what you want to
do is fully supported. Just do the upgrade for RS the same as it says, it
does not differ because the DB is on 2000 rather than 2005.
One point, RS 2005 management tools are integrated with the new 2005
management tools so you will need that installed somewhere.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nina" <Nina@.discussions.microsoft.com> wrote in message
news:8C9877E2-D227-43DB-8125-469272E72E31@.microsoft.com...
> Hi,
> I am currently running SQL Server 2000 SP3 with Reporting Services 2000
> SP2.
> I am unable to upgrade the SQL Instance 2005, but would really like to
> upgrade RS to 2005.
> RS 2000 is currently installed on a separate server to the SQL Instance,
> but
> the RS Databases (ReportServer and ReportServerTempDB) are installed on
> the
> SQL 2000. Would it work to upgrade RS to 2005, but leave the databases on
> a
> SQL Server 2000?
> Cheers,
> Nina
>