Reporting Services 2005 on Vista

Hi All
When I go to http://localhost/reports on my laptop running Vista and SQL
Server Reporting Services 2005 SP2 I recive the following error:
HTTP Error 401.1 - Unauthorized
Description: You do not have permission to view this directory or page using
the credentials that you supplied.
Does anyone know how to resolve this?
Thanks
- DavidNot sure if this is to do with you having to be logged in to the machine as
Admin or someone with admin rights.
"David" wrote:
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>|||I don't run Vista but here is a post I saved that might help you:
>>>>>
1) Control Panel / User Accounts / Turn User Account Control - off
2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
>>>>>>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <David@.discussions.microsoft.com> wrote in message
news:90D7717A-5883-4EB8-BFDF-A97EE9E5FE40@.microsoft.com...
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page
> using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>

REPORTING SERVICES 2005 AND VISUAL STUDIO 2003

Hi everyone
I would like to put the following question...
I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
MSQL2000 Database?
Do I need to Install Visual Studio 2005 ?
Thanks a lot
MiltosRS 2005 comes with a version of VS 2005. You do not have to purchase it.
Just install the BI tools from the SQL Server 2005 disk. RS 2005 can use SQL
Server 2000 db for its object/metadata (as long as you have the SQL Server
2005 license) the biggest issue is installing side by side on the database
with RS 2000. The other issue is IIS. One part of IIS (RS 2000) needs to
stay at 1.1, the other needs to be at 2.0. So you upgrade IIS with 2.0
framework and then you have to get the initial sites back to 1.1.
I believe all of this is possible but it is non-trivial.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<milmen@.tellas.gr> wrote in message
news:1155895924.922028.277620@.m79g2000cwm.googlegroups.com...
> Hi everyone
> I would like to put the following question...
> I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
> and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
> MSQL2000 Database?
> Do I need to Install Visual Studio 2005 ?
> Thanks a lot
> Miltos
>|||I have the same predicament.
I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
RS2000
The client wanted to upgrade SQL to 2005 but now I have difficulties
running my application which runs on Framework 1.1 to call RS2005 now
using Framework 2.
So to solve it, I downgraded RS back to 2000.|||There was no reason to downgrade RS. There are two ways to be integrating:
URL Integration and Web Services. Both are still available to you from your
application. The web server has to be told which sites are still running
1.1, then the sites used by RS 2005 use 2.0.
Also, his case was that he wanted to have RS 2000 and RS 2005 side by side.
That does not seem to be the case for you. Your situation seemed to be one
of integration which should not be a problem at all.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rGenius" <ruellacaste@.gmail.com> wrote in message
news:1156490695.127315.56360@.b28g2000cwb.googlegroups.com...
>I have the same predicament.
> I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
> RS2000
> The client wanted to upgrade SQL to 2005 but now I have difficulties
> running my application which runs on Framework 1.1 to call RS2005 now
> using Framework 2.
> So to solve it, I downgraded RS back to 2000.
>

Reporting Services 2005 : The report server cannot open a connection to the report server databa

Hi,

I am getting the following error whenever I try to open the reportserver 2005 default web page

http://home/reportserver

Reporting Services Error
--
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

--
SQL Server Reporting Services

SQL SERVER 2005 DEVELOPER EDITION ERROR LOG
2006-01-24 17:54:52.65 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.

REPORTING SERVICES 2005 ERROR LOG
aspnet_wp!runningjobs!15!1/24/2006-18:41:26:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

SURFACE AREA CONFIGURATION TOOL
SQL Server 2005 -> Reporting Services -> Integrated Security hangs 60 seconds

Next, long error stack trace follows with a message near the beginning ...

The report server can not open a connection to the SQL Server database.

All of my instances are up and running.
All of my instances allow both Windows Authentication and SQL Server Authentication.
Each has an sa password. (They are all the same.) I have tested each and can connect to each instance.
All of my instances allow remote connections. I have up'ed the connection timeout to 60 seconds.

Any ideas?

Any place that I could look to find SQL Server 2005 Reporting Services database connection Troubleshooting documentation?

Thank you very much.

AIMDBA

This error sounds like reporting services cannot communicate to the reportservices database, which is just a standard sql server 2005 database. Are you hosting the database server and reporting services on the same physical machine?|||

JonM,

Yes, I am hosting SQL Server 2005 Developers Edition database edition and SQL Server 2005 Reporting Services Developer Edition reporting server on the same machine. I just went through the regular install.

Any directions to try to start debugging this problem?

AIMDBA

|||The first thing to do is to go the 'Reporting Services Configuration Manager' Please make sure there is a green check mark next to everything (except encryption keys and execution accounts). Many common problems can be diagnosed here. Specifically make sure the 'Database Setup' looks correct.|||

Yes,

The SQL Server 2005 Developer Edition Report Server and the SQL Server 2005 Developer Edition Database Server are on the same machine.

I also did the following ...

Went into Report Server configuration ...

Set and Tested the login creditions to be

SQL Server Credentials

.

SA

password

I used a . for the local database. That all worked fine.

Next, I changed the Execution Account to be .\Administrator.

That seems O.K.

Next, I changes the Reporting Services Service to run under .\Administrator.

I shut down and restarted everything.

When I do : http://localhost/reportserver

Now, I get a new message:

Reporting Services Error

---

The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) Get Online Helpsql

Reporting Services 2005 : The report server cannot open a connection to the report server databa

Hi,

I am getting the following error whenever I try to open the reportserver 2005 default web page

http://home/reportserver

Reporting Services Error
--
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

--
SQL Server Reporting Services

SQL SERVER 2005 DEVELOPER EDITION ERROR LOG
2006-01-24 17:54:52.65 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.

REPORTING SERVICES 2005 ERROR LOG
aspnet_wp!runningjobs!15!1/24/2006-18:41:26:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

SURFACE AREA CONFIGURATION TOOL
SQL Server 2005 -> Reporting Services -> Integrated Security hangs 60 seconds

Next, long error stack trace follows with a message near the beginning ...

The report server can not open a connection to the SQL Server database.

All of my instances are up and running.
All of my instances allow both Windows Authentication and SQL Server Authentication.
Each has an sa password. (They are all the same.) I have tested each and can connect to each instance.
All of my instances allow remote connections. I have up'ed the connection timeout to 60 seconds.

Any ideas?

Any place that I could look to find SQL Server 2005 Reporting Services database connection Troubleshooting documentation?

Thank you very much.

AIMDBA

This error sounds like reporting services cannot communicate to the reportservices database, which is just a standard sql server 2005 database. Are you hosting the database server and reporting services on the same physical machine?|||

JonM,

Yes, I am hosting SQL Server 2005 Developers Edition database edition and SQL Server 2005 Reporting Services Developer Edition reporting server on the same machine. I just went through the regular install.

Any directions to try to start debugging this problem?

AIMDBA

|||The first thing to do is to go the 'Reporting Services Configuration Manager' Please make sure there is a green check mark next to everything (except encryption keys and execution accounts). Many common problems can be diagnosed here. Specifically make sure the 'Database Setup' looks correct.|||

Yes,

The SQL Server 2005 Developer Edition Report Server and the SQL Server 2005 Developer Edition Database Server are on the same machine.

I also did the following ...

Went into Report Server configuration ...

Set and Tested the login creditions to be

SQL Server Credentials

.

SA

password

I used a . for the local database. That all worked fine.

Next, I changed the Execution Account to be .\Administrator.

That seems O.K.

Next, I changes the Reporting Services Service to run under .\Administrator.

I shut down and restarted everything.

When I do : http://localhost/reportserver

Now, I get a new message:

Reporting Services Error

---

The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) Get Online Help

Reporting Services 2005 - Matrix Grouped Report - Calculating Percentages %

Hi,

Could someone help with the following problem, I what to create a cross-tab report of the following data, grouped by Colour:

RAW DATA

Name Colour Sarah Black Kim Red Jane Black Jane Pink Robert Yellow Tom Green Tom Black Billy Black Sarah Black Sarah Black Tom Pink Kim Pink Robert Black

Group Colours by Names Report

Number Proportions % Name Black Green Pink Red Yellow Total by Name Black Green Pink Red Yellow Billy 1 1 100.00% 0.00% 0.00% 0.00% 0.00% Jane 1 1 2 50.00% 0.00% 50.00% 0.00% 0.00% Kim 1 1 2 0.00% 0.00% 50.00% 50.00% 0.00% Robert 1 1 2 50.00% 0.00% 0.00% 0.00% 50.00% Sarah 3 3 100.00% 0.00% 0.00% 0.00% 0.00% Tom 1 1 1 3 33.33% 33.33% 33.33% 0.00% 0.00%

I want to produce a Matrix cross-tab report, like the above, within Reporting Services. Any suggestions welcome

Many Thanks,

Radha

This is a pretty basic matrix report. Make sure to add a matrix to the layout design and then...

1. add name to row

2. add color to column

3. add name to data and change the expression to count(name.....)

4. add name to data again but to the right of the first one. You will see a light blue/green line appear and then release your mouse. Now you need to change the expression to formatpercent(count(name...))

This should do it.

|||

fsugeiger

Thanks for the above response, but now I am getting 300% for Name, Sarah for the colour Black . I need to show this as the percentage of the "Total by Name" that should = 100%.

For Tom the % should be 33%, not 100% results now:-

Name Black Green Pink Red Yellow Total by Name Black Green Pink Red Yellow Sarah 3 3 300.00% 0.00% 0.00% 0.00% 0.00% Tom 1 1 1 3 100.00% 100.00% 100.00% 0.00% 0.00%

Solution to this would be very welcome, and greatly appreciated, from anyone.

Thanks

Radha

|||Hi , i m currently building a report that will calculate frequencies using a MATRIX .

I have a column that contains multiple groups of answers as you can see in the following screenshot.

In each group of answers i compute the total (calling the subtotal function) .

The problem is that now i want to compute the frequencies for each answer.. So for the first group of answers i want to divide each cell with each corresponding total .

I cant do that at the current moment because the number of answers in each group is diffirent (im using a matrix) and there is no way to know the total because it is computed on the fly.

Is there a way i can do that?

Thnx in advance

Reporting Services 2005 - Matrix Grouped Report - Calculate Percentages

Hi,

Could someone help with the following problem, I what to create a cross-tab report of the following data, grouped by Colour:

RAW DATA

Name Colour Sarah Black Kim Red Jane Black Jane Pink Robert Yellow Tom Green Tom Black Billy Black Sarah Black Sarah Black Tom Pink Kim Pink Robert Black

Group Colours by Names Report

Number Proportions % Name Black Green Pink Red Yellow Total by Name Black Green Pink Red Yellow Billy 1 1 100.00% 0.00% 0.00% 0.00% 0.00% Jane 1 1 2 50.00% 0.00% 50.00% 0.00% 0.00% Kim 1 1 2 0.00% 0.00% 50.00% 50.00% 0.00% Robert 1 1 2 50.00% 0.00% 0.00% 0.00% 50.00% Sarah 3 3 100.00% 0.00% 0.00% 0.00% 0.00% Tom 1 1 1 3 33.33% 33.33% 33.33% 0.00% 0.00%

I want to produce a Matrix cross-tab report, like the above, within Reporting Services. Any suggestions welcome

Many Thanks,

Radha

This is a pretty basic matrix report. Make sure to add a matrix to the layout design and then...

1. add name to row

2. add color to column

3. add name to data and change the expression to count(name.....)

4. add name to data again but to the right of the first one. You will see a light blue/green line appear and then release your mouse. Now you need to change the expression to formatpercent(count(name...))

This should do it.

|||

fsugeiger

Thanks for the above response, but now I am getting 300% for Name, Sarah for the colour Black . I need to show this as the percentage of the "Total by Name" that should = 100%.

For Tom the % should be 33%, not 100% results now:-

Name Black Green Pink Red Yellow Total by Name Black Green Pink Red Yellow Sarah 3 3 300.00% 0.00% 0.00% 0.00% 0.00% Tom 1 1 1 3 100.00% 100.00% 100.00% 0.00% 0.00%

Solution to this would be very welcome, and greatly appreciated, from anyone.

Thanks

Radha

|||Hi , i m currently building a report that will calculate frequencies using a MATRIX .

I have a column that contains multiple groups of answers as you can see in the following screenshot.

In each group of answers i compute the total (calling the subtotal function) .

The problem is that now i want to compute the frequencies for each answer.. So for the first group of answers i want to divide each cell with each corresponding total .

I cant do that at the current moment because the number of answers in each group is diffirent (im using a matrix) and there is no way to know the total because it is computed on the fly.

Is there a way i can do that?

Thnx in advance

Reporting services 2005

Hello,

I installed SQL Server 2005 into a Windows 2005 Pro machine, I have following question:

1. will I be able to use Reporting services to deploy the reports to the same machine as a report server?

2. Can I modify and deploy mo old reports written in RS2000

3. Is there any web site that show step by step how I can work with RS2005?

Thanks,

for the first question, of course, you can
for the third question, you can view the tutorial on reporting servicein sqlserver2005 help, first you should install both 'adventurework'database and 'adventureworkdw'database which are used in the tutorial.The install manual is also in sqlserver2005 help

Reporting Services

Hi,

I have a question please somebody help me on this. As I was working on my report , done some changes and didn't save it. Got the following message after some time:

Deserialization is not a valid value.

then i am unable to open my report. What could have happend?

I have created some data sets for the report. Is there a way i could the data sets created for that report.

It looks like, I have to create a whole new report again.

Thanks

Sudha

No, the dataset definitions for the report are contained within the rdl file. What you could possibly do is open the rdl file in an XML editor, extract the appropriate dataset nodes, and insert them into a new copy of the report that does not have the problem. It is up to you how to get that copy of the report that still works, ideally you should have it in a source repository and you can just revert (roll back) to a previous version.

Reporting Service ReportRendering Error

Hello,
After running a report using reporting services, we are receiving the
following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
An error has occurred during rendering of chart chart1. Details: Cannot find
font '?'. (rsErrorDuringChartRendering) Get Online Help
Cannot find font '?'.
Has anyone experienced this problem?
We have installed Service Pack 1 for Reporting Services.
We are running SQL Server 2000 Service Pack 3.
IIS 5.0
Windows Server 2000
Thank you.Did you ever resolve this? I'm getting the same error; it happens only on
the one report we have that generates a line chart. We're on SQL Server 2000
SP4 and RS SP2. We've tried copying the fonts from another server where the
problem does not occur, but it still fails.
"Dudi Nissan" wrote:
> Hello,
> After running a report using reporting services, we are receiving the
> following error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> An error has occurred during rendering of chart chart1. Details: Cannot find
> font '?'. (rsErrorDuringChartRendering) Get Online Help
> Cannot find font '?'.
> Has anyone experienced this problem?
> We have installed Service Pack 1 for Reporting Services.
> We are running SQL Server 2000 Service Pack 3.
> IIS 5.0
> Windows Server 2000
> Thank you.

Reporting service install fail

Hello I get the following in the a log file when I install RS, any ideas wha
t the problem is.
<Header><Product>Microsoft SQL Server Reporting Services Version 8.00.743.00
</Product><Locale>en-US</Locale><TimeZone>GMT Daylight Time</TimeZone><Path>
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\Repo
rtServerService__main_05_07
_2004_16_00_31.log</Path><SystemName>PSLDEV-UT01</SystemName><OSName>Microso
ft Windows NT 5.0.2195.0</OSName><OSVersion>5.0.2195.0</OSVersion></Header>
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration f
ile.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing DatabaseQueryTimeout to '120' second(s) as specified in Configuration fi
le.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing RunningRequestsScavengerCycle to '60' second(s) as specified in Configur
ation file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing RunningRequestsDbCycle to '60' second(s) as specified in Configuration f
ile.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file
.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializ
ing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutiliti
es!ad0!07/05/2004-16:00:34:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!servicecontroll
er!ae4!07/05/2004-16:00:34:: Total P
hysical memory: 402112512
ReportingServicesService!servicecontroll
er!ad0!07/05/2004-16:00:35:: i INFO:
RPC Server started
ReportingServicesService!servicecontroll
er!a5c!07/05/2004-16:00:36:: i INFO:
RPC Server stopped
ReportingServicesService!servicecontroll
er!ae4!07/05/2004-16:00:37:: Service
Maintenance thread caught an exception, restarting Service Maintenance thre
ad. Error Message System.AppDomainUnloadedException: The target application
domain has been unloaded.
Server stack trace:
at System.Threading.Thread.EnterContextInternal(Context ctx, Int32 id, Int32
appDomainID, ContextTransitionFrame& frame)
at System.Runtime.Remoting.Channels.CrossAppDomainSink.DoTransitionDispatch(
Byte[] reqStmBuff, SmuggledMethodCallMessage smuggledMcm, SmuggledMethod
ReturnMessage& smuggledMrm)
at System.Runtime.Remoting.Channels.CrossAppDomainSink.SyncProcessMessage(IM
essage reqMsg)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage re
qMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgD
ata, Int32 type)
at Microsoft.ReportingServices.Library.AppDomainProxy.get_IsPollingWorking()
at Microsoft.ReportingServices.Library.ServiceAppDomainController.ServiceMai
ntenance().
ReportingServicesService!servicecontroll
er!a5c!07/05/2004-16:00:41:: Service
shutting down.Hello,
If I understand your problem correctly this is a reporting service issue.
This is beyond the scope of the datawarehouse and would be best handled by
the reportingsvcs group. If you would, please post this question in the
reportingsvcs newsgroup microsoft.public.sqlserver.reportingsvcs. The
reportingsvcs newsgroup is primarily for issues involving reporting
services. The reason why we recommend posting appropriately is you will get
the most qualified pool of respondents, and other partners who read the
newsgroups regularly can either share their knowledge or learn from your
interaction with us.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Reporting service install fail

Hello I get the following in the a log file when I install RS, any ideas what the problem is.
<Header><Product>Microsoft SQL Server Reporting Services Version 8.00.743.00</Product><Locale>en-US</Locale><TimeZone>GMT Daylight Time</TimeZone><Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServerService__main_05_07
_2004_16_00_31.log</Path><SystemName>PSLDEV-UT01</SystemName><OSName>Microsoft Windows NT 5.0.2195.0</OSName><OSVersion>5.0.2195.0</OSVersion></Header>
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!ad0!07/05/2004-16:00:32:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutilities!ad0!07/05/2004-16:00:34:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!servicecontroller!ae4!07/05/2004-16:00:34:: Total Physical memory: 402112512
ReportingServicesService!servicecontroller!ad0!07/05/2004-16:00:35:: i INFO: RPC Server started
ReportingServicesService!servicecontroller!a5c!07/05/2004-16:00:36:: i INFO: RPC Server stopped
ReportingServicesService!servicecontroller!ae4!07/05/2004-16:00:37:: Service Maintenance thread caught an exception, restarting Service Maintenance thread. Error Message System.AppDomainUnloadedException: The target application domain has been unloaded.
Server stack trace:
at System.Threading.Thread.EnterContextInternal(Conte xt ctx, Int32 id, Int32 appDomainID, ContextTransitionFrame& frame)
at System.Runtime.Remoting.Channels.CrossAppDomainSin k.DoTransitionDispatch(Byte[] reqStmBuff, SmuggledMethodCallMessage smuggledMcm, SmuggledMethodReturnMessage& smuggledMrm)
at System.Runtime.Remoting.Channels.CrossAppDomainSin k.SyncProcessMessage(IMessage reqMsg)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData& msgData, Int32 type)
at Microsoft.ReportingServices.Library.AppDomainProxy .get_IsPollingWorking()
at Microsoft.ReportingServices.Library.ServiceAppDoma inController.ServiceMaintenance().
ReportingServicesService!servicecontroller!a5c!07/05/2004-16:00:41:: Service shutting down.
Hello,
If I understand your problem correctly this is a reporting service issue.
This is beyond the scope of the datawarehouse and would be best handled by
the reportingsvcs group. If you would, please post this question in the
reportingsvcs newsgroup microsoft.public.sqlserver.reportingsvcs. The
reportingsvcs newsgroup is primarily for issues involving reporting
services. The reason why we recommend posting appropriately is you will get
the most qualified pool of respondents, and other partners who read the
newsgroups regularly can either share their knowledge or learn from your
interaction with us.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.