ReportBuilder

I installed RS 2005 on my machine. Everything works except the reportbuilder.
When I launch it I get the message
An unhandled exception of type
'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
Additional information: The attempt to connect to the report server failed.
Check your connection information and that the report server is a compatible
version.
Any ideasRoland,
Which build of SQL Server 2005 are you using?
Which OS?
Was it a clean install or after uninstall of earlier builds?
I don't recall seeing this specific error reported before although
there were some problems with early builds of Report Builder.
You might want to visit
http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
for any similar reports.
Andrew Watt
MVP - InfoPath
On Sat, 15 Oct 2005 01:13:01 -0700, Roland
<Roland@.discussions.microsoft.com> wrote:
>I installed RS 2005 on my machine. Everything works except the reportbuilder.
>When I launch it I get the message
>An unhandled exception of type
>'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
>Additional information: The attempt to connect to the report server failed.
>Check your connection information and that the report server is a compatible
>version.
>Any ideas|||I installed it from the MSDN Visual Studio 2005 Beta 2 DVD
Select @.@.version in SQL gives
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
The reportbuilder.exe : version 9.0.1116.0, assembly version 9.0.242.0
Installed on a Windows XP (with SP2) machine
Is it possible that the fact my installed OS is Dutch, is causing the
problem ?
"Andrew Watt [MVP - InfoPath]" wrote:
> Roland,
> Which build of SQL Server 2005 are you using?
> Which OS?
> Was it a clean install or after uninstall of earlier builds?
> I don't recall seeing this specific error reported before although
> there were some problems with early builds of Report Builder.
> You might want to visit
> http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
> for any similar reports.
> Andrew Watt
> MVP - InfoPath
> On Sat, 15 Oct 2005 01:13:01 -0700, Roland
> <Roland@.discussions.microsoft.com> wrote:
> >I installed RS 2005 on my machine. Everything works except the reportbuilder.
> >When I launch it I get the message
> >An unhandled exception of type
> >'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
> >
> >Additional information: The attempt to connect to the report server failed.
> >Check your connection information and that the report server is a compatible
> >version.
> >
> >Any ideas
>|||Hi
That was the April CTP.
Between then and now, there were 2 more CTP's. Probably a bug with that old
version.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Roland" <Roland@.discussions.microsoft.com> wrote in message
news:CE1A6B37-EFE2-4537-A39A-0016A7B7A503@.microsoft.com...
>I installed it from the MSDN Visual Studio 2005 Beta 2 DVD
> Select @.@.version in SQL gives
> Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
> Apr 9 2005 20:56:37
> Copyright (c) 1988-2004 Microsoft Corporation
> Beta Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> The reportbuilder.exe : version 9.0.1116.0, assembly version 9.0.242.0
> Installed on a Windows XP (with SP2) machine
> Is it possible that the fact my installed OS is Dutch, is causing the
> problem ?
> "Andrew Watt [MVP - InfoPath]" wrote:
>> Roland,
>> Which build of SQL Server 2005 are you using?
>> Which OS?
>> Was it a clean install or after uninstall of earlier builds?
>> I don't recall seeing this specific error reported before although
>> there were some problems with early builds of Report Builder.
>> You might want to visit
>> http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
>> for any similar reports.
>> Andrew Watt
>> MVP - InfoPath
>> On Sat, 15 Oct 2005 01:13:01 -0700, Roland
>> <Roland@.discussions.microsoft.com> wrote:
>> >I installed RS 2005 on my machine. Everything works except the
>> >reportbuilder.
>> >When I launch it I get the message
>> >An unhandled exception of type
>> >'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException'
>> >occurred in ReportBuilder.exe
>> >
>> >Additional information: The attempt to connect to the report server
>> >failed.
>> >Check your connection information and that the report server is a
>> >compatible
>> >version.
>> >
>> >Any ideas|||Roland,
April CTP was, if I remember correctly, only the second public build
with Report Builder in it. I remember having problems connecting to
Report Builder in one early build but don't remember if it was April
CTP.
If you have access to MSDN or BetaPlace I suggest you update to
September CTP. You will need a matching copy of Visual Studio 2005
(which is the VS2005 Release Candidate).
Uninstall order of the April CTP is VERY important. Read the Sept CTP
/ Visual Studio 2005 RC documentation CAREFULLY.
After a successful uninstall, the install order is SQL Server 2005
Sept CTP first then Visual Studio 2005 Release Candidate.
Andrew Watt
MVP - InfoPath
On Sun, 16 Oct 2005 11:13:01 -0700, Roland
<Roland@.discussions.microsoft.com> wrote:
>I installed it from the MSDN Visual Studio 2005 Beta 2 DVD
>Select @.@.version in SQL gives
>Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
> Apr 9 2005 20:56:37
> Copyright (c) 1988-2004 Microsoft Corporation
> Beta Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>The reportbuilder.exe : version 9.0.1116.0, assembly version 9.0.242.0
>Installed on a Windows XP (with SP2) machine
>Is it possible that the fact my installed OS is Dutch, is causing the
>problem ?
>"Andrew Watt [MVP - InfoPath]" wrote:
>> Roland,
>> Which build of SQL Server 2005 are you using?
>> Which OS?
>> Was it a clean install or after uninstall of earlier builds?
>> I don't recall seeing this specific error reported before although
>> there were some problems with early builds of Report Builder.
>> You might want to visit
>> http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
>> for any similar reports.
>> Andrew Watt
>> MVP - InfoPath
>> On Sat, 15 Oct 2005 01:13:01 -0700, Roland
>> <Roland@.discussions.microsoft.com> wrote:
>> >I installed RS 2005 on my machine. Everything works except the reportbuilder.
>> >When I launch it I get the message
>> >An unhandled exception of type
>> >'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
>> >
>> >Additional information: The attempt to connect to the report server failed.
>> >Check your connection information and that the report server is a compatible
>> >version.
>> >
>> >Any ideas|||Installing the Sept CTP Release of SQL 2005 did solve my problem of using the
reportbuilder. Indeed the installation order is important; as I also have SQL
2000 with Reporting Services 2000/SP2 on the same machine I had to reinstall
also the SP2 of RS 2000 because the uninstall of the version of RS2005 also
influences the behaviour of RS2000
"Andrew Watt [MVP - InfoPath]" wrote:
> Roland,
> April CTP was, if I remember correctly, only the second public build
> with Report Builder in it. I remember having problems connecting to
> Report Builder in one early build but don't remember if it was April
> CTP.
> If you have access to MSDN or BetaPlace I suggest you update to
> September CTP. You will need a matching copy of Visual Studio 2005
> (which is the VS2005 Release Candidate).
> Uninstall order of the April CTP is VERY important. Read the Sept CTP
> / Visual Studio 2005 RC documentation CAREFULLY.
> After a successful uninstall, the install order is SQL Server 2005
> Sept CTP first then Visual Studio 2005 Release Candidate.
> Andrew Watt
> MVP - InfoPath
> On Sun, 16 Oct 2005 11:13:01 -0700, Roland
> <Roland@.discussions.microsoft.com> wrote:
> >I installed it from the MSDN Visual Studio 2005 Beta 2 DVD
> >Select @.@.version in SQL gives
> >
> >Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
> > Apr 9 2005 20:56:37
> > Copyright (c) 1988-2004 Microsoft Corporation
> > Beta Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> >
> >The reportbuilder.exe : version 9.0.1116.0, assembly version 9.0.242.0
> >
> >Installed on a Windows XP (with SP2) machine
> >Is it possible that the fact my installed OS is Dutch, is causing the
> >problem ?
> >
> >"Andrew Watt [MVP - InfoPath]" wrote:
> >
> >> Roland,
> >>
> >> Which build of SQL Server 2005 are you using?
> >>
> >> Which OS?
> >>
> >> Was it a clean install or after uninstall of earlier builds?
> >>
> >> I don't recall seeing this specific error reported before although
> >> there were some problems with early builds of Report Builder.
> >>
> >> You might want to visit
> >> http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
> >> for any similar reports.
> >>
> >> Andrew Watt
> >> MVP - InfoPath
> >>
> >> On Sat, 15 Oct 2005 01:13:01 -0700, Roland
> >> <Roland@.discussions.microsoft.com> wrote:
> >>
> >> >I installed RS 2005 on my machine. Everything works except the reportbuilder.
> >> >When I launch it I get the message
> >> >An unhandled exception of type
> >> >'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
> >> >
> >> >Additional information: The attempt to connect to the report server failed.
> >> >Check your connection information and that the report server is a compatible
> >> >version.
> >> >
> >> >Any ideas
> >>
>sql

Report Timeout problem ;Out of memory exception

I am having a problem with report rendering.
The MSSRS Report runs for around 15 minutes and then the report page times
out giving the error as
"Out of memory exception. Server application unavailable".
When i check the query execution time in query analyser, query returns
results in 10 minutes.
There are about 3 groups in the RDL design.
Please provide any suggestions to overcome this problem.
Thanks in advance.
Thanks and Cheers,
TruptiSounds like your report is just too big. RS renders reports in memory, thus
the 'Out of memory exception'. Try redesigning the report or adding more
memory to your machine/server.
Also, if you get the report to successfully run you can try to pin point
what's taking so long. Look in the ReportServer database; the ExecutionLog
table. It shows what report ran, when, the amount of time for data
retrieval, processing time, and rendering time. It also shows what render
format, render status (fail or success), query row count and byte size of
the rendered file.
--
Adrian M.
MCP
"Trupti" <gettrupti@.hotmail.com> wrote in message
news:e0Tt9bcNFHA.1392@.TK2MSFTNGP10.phx.gbl...
>I am having a problem with report rendering.
> The MSSRS Report runs for around 15 minutes and then the report page
> times out giving the error as
> "Out of memory exception. Server application unavailable".
> When i check the query execution time in query analyser, query returns
> results in 10 minutes.
> There are about 3 groups in the RDL design.
> Please provide any suggestions to overcome this problem.
> Thanks in advance.
> Thanks and Cheers,
> Trupti
>
>

Report Server Windows service - unable to start

Hi,
For some reason I am unable to start RS Windows service. Here are the
details of Exception that I get -
****************************
System.ServiceProcess.TimeoutException: Time out has expired and the
operation has not been completed.
at
System.ServiceProcess.ServiceControoler.WaitForStatus(ServiceControllerStatus
desiredStatus, TimeSpan timeout)
at
ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(boolean start)
****************************
Both database and reporting servers are installed in a stand alone server
(MS Windows Server 2003 R2 Enterprise Edition SP1)
Any idea what could be wrong here please?
Many thanks in advance,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Hi
You have the same problem as described in the following article (it applies
in your case, except for the hotfix). Certificate Revocation List is not
accessible.
http://support.microsoft.com/kb/918644
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:D7ED0B0A-F196-4FED-89B9-5A4310B24A32@.microsoft.com...
> Hi,
> For some reason I am unable to start RS Windows service. Here are the
> details of Exception that I get -
> ****************************
> System.ServiceProcess.TimeoutException: Time out has expired and the
> operation has not been completed.
> at
> System.ServiceProcess.ServiceControoler.WaitForStatus(ServiceControllerStatus
> desiredStatus, TimeSpan timeout)
> at
> ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(boolean
> start)
> ****************************
> Both database and reporting servers are installed in a stand alone server
> (MS Windows Server 2003 R2 Enterprise Edition SP1)
> Any idea what could be wrong here please?
> Many thanks in advance,
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||Hi Mike
Thanks for your reply.
Just to clarify - I noticed that the KB article refers to SSIS service. The
same applies to Reporting services as well is it?
Once again thanks for your response.
Regards,
Harish
--
"Michael Epprecht [MSFT]" wrote:
> Hi
> You have the same problem as described in the following article (it applies
> in your case, except for the hotfix). Certificate Revocation List is not
> accessible.
> http://support.microsoft.com/kb/918644
> Regards
> --
> Mike
> This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Harish,
Thank you for using MSDN Managed Newsgroup Support.
I would like to know some additional information:
1. What's the Reporting Services Version? SQL Server 2005 or SQL Server
2000? Have you applied any Services Pack?
2. What's the result when you access the Report Server and Report Manager?
3. How do you try to start the Reporting Services?
Please let me know the result and so that I can provide further assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Many thanks for your response. Here are the answers -
1. It is SQL Server 2005 (9.00.1399.00). I have not applied any SP1 yet
2 and 3 -
I receive the error message while trying to start Report server via
Reporting Services Configuration Manager.
Also now I am getting this different error message from the Database
connection -
***************************************
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases
for databas 'DynamicsTempDB'. No entry found with that name. Make sure that
the name is entered correctly.
.......
***************************************
I am trying to get Report server connect to an existing database called
'Dynamics'.
Could you kindly let me know how to get this up and running please?
Thanks in advance,
Harish
_____________________________________
"Wei Lu" wrote:
> Hi Harish,
> Thank you for using MSDN Managed Newsgroup Support.
> I would like to know some additional information:
> 1. What's the Reporting Services Version? SQL Server 2005 or SQL Server
> 2000? Have you applied any Services Pack?
> 2. What's the result when you access the Report Server and Report Manager?
> 3. How do you try to start the Reporting Services?
> Please let me know the result and so that I can provide further assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support|||Hi Wei,
Forgot to add this - I did search for 'DynamicsTempDB' in the
rsreportserver.config file but couldn'd find this.
Regards,
Harish|||Hi Harish,
Thank you for your update.
From the description, my understanding of this is that: You get the
following error when you try to start the Reporting Services:
***************************************
System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases
for databas 'DynamicsTempDB'. No entry found with that name. Make sure that
the name is entered correctly.
......
***************************************
If I misunderstood your concern, please feel free to let me know.
Firstly, please try to confirm the database DynamicsTempDB is existed in
your database server.
It seems that you are trying to connect to a Report Server database. Please
make sure the Dynamics database is a Report Server database.
Please try to use the rsconfig utility to connect to the database.
rsconfig Utility
http://msdn2.microsoft.com/en-us/library/ms162837.aspx
rsconfig -c -s <SQLSERVERNAME> -d reportserver -a Windows -u
<MYDOMAIN\MYACCOUNT> -p <PASSWORD>
Secondly, would you please send the Reporting Service Error log to me if
the above steps does not resolve the issue?By default, the log file is
located at \Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\LogFiles. You may zip the folder and send to me directly. I
understand the information may be sensitive to you, my direct email address
is weilu@.ONLINE.microsoft.com(Please remove ONLINE when you send the
email), you may send the file to me directly and I will keep it secure.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for your assistance.
I tried your suggestion without any luck (:
As mentioned I have sent those log files in Zip format. Would very much
appreciate if you could kindly help me.
Sincerely,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
"Wei Lu" wrote:
> Secondly, would you please send the Reporting Service Error log to me if
> the above steps does not resolve the issue?By default, the log file is
> located at \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\LogFiles. You may zip the folder and send to me directly. I
> understand the information may be sensitive to you, my direct email address
> is weilu@.ONLINE.microsoft.com(Please remove ONLINE when you send the
> email), you may send the file to me directly and I will keep it secure.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support|||Hi Harish,
Thank you for the update.
I have checked the Log file you send to me.
According to the error message, I would like to get the config file from
you.
Please provide the following config files:
\Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\ReportManager\RSWebApplication.config
\Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\ReportManager\Web.config
\Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\ReportServe\rsreportserver.config
\Microsoft SQL Server\<SQL Server Instance>\Reporting
Services\ReportServe\web.config
Please zip these files and send to me. Thank you !
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Many thanks for your help.
As required I have mailed you the config files. Looking forward to hearing
from you.
Once again many many thanks for your assitance. Much appreciated :)
Sincerely,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
"Wei Lu" wrote:
> Hi Harish,
> Thank you for the update.
> I have checked the Log file you send to me.
> According to the error message, I would like to get the config file from
> you.
> Please provide the following config files:
> \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\ReportManager\RSWebApplication.config
> \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\ReportManager\Web.config
> \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\ReportServe\rsreportserver.config
> \Microsoft SQL Server\<SQL Server Instance>\Reporting
> Services\ReportServe\web.config
> Please zip these files and send to me. Thank you !
> Sincerely,
> Wei Lu
> Microsoft Online Community Support|||Hi Harish,
Thank you for the update.
Would you please try to modify the <WebServiceIdentity> Entry in the
rsreportserver.config file?
Currently, it was <WebServiceIdentity>Local System</WebServiceIdentity>.
Please modify it to
<WebServiceIdentity>NT Authority\System</WebServiceIdentity>
After doing this, please try to start Reporting Services.
Here is an article for your reference:
You may not be able to access Reporting Services after you create an
application pool that runs under the LocalSystem account
http://support.microsoft.com/kb/907267/en-us
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Harish,
Just checking in to see if the suggestions were helpful. Please let us know
if you would like further assistance.
Have a great day!
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks to your excellent support at last I managed to resolve the problem.
Thanks for your help :)
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/|||Hi Harish,
Thank you for your update and glad to hear the information is helpful!
If you have any questions or concerns, please feel free to let us know!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Wei Lu!
I read this thread in its entirety and I am having the exact same problem.
However when I went to modify my rsreportserver.config file based on your
instruction below, my config file was already set to <WebServiceIdentity>NT
Authority\System</WebServiceIdentity>.
Do you have any other thoughts on how I can resolve this problem? Thanks!
Amedeo Feroce
"Wei Lu" <weilu@.online.microsoft.com> wrote in message
news:%23g9GfASlGHA.4948@.TK2MSFTNGXA01.phx.gbl...
> Hi Harish,
> Thank you for the update.
> Would you please try to modify the <WebServiceIdentity> Entry in the
> rsreportserver.config file?
> Currently, it was <WebServiceIdentity>Local System</WebServiceIdentity>.
> Please modify it to
> <WebServiceIdentity>NT Authority\System</WebServiceIdentity>
> After doing this, please try to start Reporting Services.
> Here is an article for your reference:
> You may not be able to access Reporting Services after you create an
> application pool that runs under the LocalSystem account
> http://support.microsoft.com/kb/907267/en-us
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||I've seen this issue on quite a few message boards. With that being said, I
am sharing the solution that worked for me.
I simply installed SQL SERVER 2005 SP1 and re-booted the server. I opened
the reporting services configuration
tool and and reporting services was already running (keep in mind that I had
previously configured all of the other settings when I could not start
reporting services).
I hope this helps!
Amedeo
"Amedeo Feroce" <aferoce@.akdhc.com> wrote in message
news:%23HIknFtpGHA.3820@.TK2MSFTNGP05.phx.gbl...
> Hello Wei Lu!
> I read this thread in its entirety and I am having the exact same problem.
> However when I went to modify my rsreportserver.config file based on your
> instruction below, my config file was already set to
> <WebServiceIdentity>NT Authority\System</WebServiceIdentity>.
> Do you have any other thoughts on how I can resolve this problem? Thanks!
> Amedeo Feroce
> "Wei Lu" <weilu@.online.microsoft.com> wrote in message
> news:%23g9GfASlGHA.4948@.TK2MSFTNGXA01.phx.gbl...
>> Hi Harish,
>> Thank you for the update.
>> Would you please try to modify the <WebServiceIdentity> Entry in the
>> rsreportserver.config file?
>> Currently, it was <WebServiceIdentity>Local System</WebServiceIdentity>.
>> Please modify it to
>> <WebServiceIdentity>NT Authority\System</WebServiceIdentity>
>> After doing this, please try to start Reporting Services.
>> Here is an article for your reference:
>> You may not be able to access Reporting Services after you create an
>> application pool that runs under the LocalSystem account
>> http://support.microsoft.com/kb/907267/en-us
>> Hope this will be helpful!
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> ==================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>

Report server not inizialized after installation

Platform : SQL Server Express SP2 with advanced services

I have an install script that installs all of the services and features with the exception of management studio express. My install script is very basic, the only addition was to have RSSQLOCAL=1, and I set RSCONFIGURATION=Default.

After the installation, when I navigate to localhost\Reports$SQLEXPRESS or localhost\ReportServer$SQLEXPRESS, I get an authentication error. When I go into the reporting services configuration manager, everything looks OK, but the 'Initialized' status is 'NO' under status. If I go to 'Database Setup', choose Connect, and then 'Apply', the reporting services now becomes initialized, and everything seems to be OK.

What is the reason for this manual step in the reporting configuration manager? Any ideas?
I don't know why that happens either. A bit of a mystery...but trust me, if that is the only problem you had installing....... You're Lucky.|||Hmmm,

Thanks for the reply.

Sounds like installation can be a huge headache for SSRS. Has anyone compiled a page with install issues and resolutions for SSRS?
|||According to this post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=838483&SiteID=1

You simply have to restart the PC for it to be initialized.
|||

ajhuddy wrote:

Hmmm,
Has anyone compiled a page with install issues and resolutions for SSRS?

Yes, a good portion of these forums.

Report Server Installation Issue

Hi,
I followed the article, here is the error I am still recieving:
Server Error in '/REPORTSERVER' Application.
----
Security Exception
Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the
permission of type System.Web.AspNetHostingPermission, System,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[SecurityException: Request for the permission of type
System.Web.AspNetHostingPermission, System, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.]
System.Type.GetType(String typeName, Boolean throwOnError) +0
System.Web.Configuration.HandlerBase.GetAndRemoveTypeAttributeInternal(XmlNode node, String attrib, Boolean fRequired, Type& val) +52
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573
Thanks
Eric
"Cooper" wrote:
> Try this for your error
> http://support.microsoft.com/kb/887787
>
>
>
> "ejswanson" wrote:
>
> > I need to install the sql server report service on 2 web sites on the same
> > server. The urls are www.xxxx.us and test.xxxx.us. How do I go about doing
> > this?
> >
> > I successfully installed the report service on the default web site of this
> > server, but normally it is not started. I copied the virtual directories
> > from the default site to my other sites, but I am now getting the following
> > error message:
> >
> > Security Exception
> > Description: The application attempted to perform an operation not allowed
> > by the security policy. To grant this application the required permission
> > please contact your system administrator or change the application's trust
> > level in the configuration file.
> >
> > Exception Details: System.Security.SecurityException: Request for the
> > permission of type System.Web.AspNetHostingPermission, System,
> > Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> >
> > Source Error:
> >
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > Stack Trace:
> >
> >
> > [SecurityException: Request for the permission of type
> > System.Web.AspNetHostingPermission, System, Version=1.0.5000.0,
> > Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.]
> > System.Type.GetType(String typeName, Boolean throwOnError) +0
> >
> > System.Web.Configuration.HandlerBase.GetAndRemoveTypeAttributeInternal(XmlNode node, String attrib, Boolean fRequired, Type& val) +52
> >
> >
> >
> > Both of these web sites already are running asp.net applications. How do I
> > resolve this issue on the websites that are not the default web site?
> >
> > If I have a test site and a production site, how do I move the reports
> > between the sites? Is the database connection site specfic?
> >
> > Thanks
> >
> > Eric
> >
> >
> >
Expand AllCollapse AllHi ejswanson,
From your descriptions, I understood that you followed KB article Q887787
but it still report the error message "The application attempted to perform
an operation not allowed by the security policy." If I have misunderstood
your concern, please feel free to point it out.
First of all, I would like to double confirm that you have download .config
files from KB article Q887787
http://download.microsoft.com/download/9/8/C/98CEED6D-3489-4504-BBB5-586B630
01CE0/887787.exe
and you have replaced your current .config files with the .config files
from the package as KB described and restart machine finally.
Secondly, are you logon the system with the privilege as local
administrator? More detailed information, I beileve, will make us closer to
the resolution.
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael,
I did download the patch and installed it on the machine. I also rebooted
the machine a number of times.
Yes, I am logged on as local administrator.
Do I need to make sure that the reporting service is logged on as a local
administrator?
The particular web site that I am attempting to get reporting services
running also has another asp.net web application running in it. Would this
cause this issue? Please send me any other questions or other files that you
need in order to determine the resolution.
Thanks
Eric
"Michael Cheng [MSFT]" wrote:
> Hi ejswanson,
> From your descriptions, I understood that you followed KB article Q887787
> but it still report the error message "The application attempted to perform
> an operation not allowed by the security policy." If I have misunderstood
> your concern, please feel free to point it out.
> First of all, I would like to double confirm that you have download .config
> files from KB article Q887787
> http://download.microsoft.com/download/9/8/C/98CEED6D-3489-4504-BBB5-586B630
> 01CE0/887787.exe
> and you have replaced your current .config files with the .config files
> from the package as KB described and restart machine finally.
> Secondly, are you logon the system with the privilege as local
> administrator? More detailed information, I beileve, will make us closer to
> the resolution.
> If you have any questions or concerns, don't hesitate to let me know. We
> are always here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Eric,
A long shot. The other ASP.NET application isn't running on ASP.NET
2.0 is it?
I had a similar problem when trying (in a test situation) to run an
ASP.NET 2.0 app (RS2005) alongside an ASP.NET 1.1 app.
Andrew Watt
MVP - InfoPath
On Thu, 7 Apr 2005 04:23:02 -0700, ejswanson
<ejswanson1@.community.nospam> wrote:
>Hi Michael,
>I did download the patch and installed it on the machine. I also rebooted
>the machine a number of times.
>Yes, I am logged on as local administrator.
>Do I need to make sure that the reporting service is logged on as a local
>administrator?
>The particular web site that I am attempting to get reporting services
>running also has another asp.net web application running in it. Would this
>cause this issue? Please send me any other questions or other files that you
>need in order to determine the resolution.
>Thanks
>Eric
>"Michael Cheng [MSFT]" wrote:
>> Hi ejswanson,
>> From your descriptions, I understood that you followed KB article Q887787
>> but it still report the error message "The application attempted to perform
>> an operation not allowed by the security policy." If I have misunderstood
>> your concern, please feel free to point it out.
>> First of all, I would like to double confirm that you have download .config
>> files from KB article Q887787
>> http://download.microsoft.com/download/9/8/C/98CEED6D-3489-4504-BBB5-586B630
>> 01CE0/887787.exe
>> and you have replaced your current .config files with the .config files
>> from the package as KB described and restart machine finally.
>> Secondly, are you logon the system with the privilege as local
>> administrator? More detailed information, I beileve, will make us closer to
>> the resolution.
>> If you have any questions or concerns, don't hesitate to let me know. We
>> are always here to be of assistance!
>>
>> Sincerely yours,
>> Michael Cheng
>> Microsoft Online Partner Support
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>> =====================================================>> This posting is provided "AS IS" with no warranties, and confers no rights.
>>|||Unfortunately not. Both sites are asp.net 1.1.
Thanks
Eric
"Andrew Watt [MVP - InfoPath]" wrote:
> Eric,
> A long shot. The other ASP.NET application isn't running on ASP.NET
> 2.0 is it?
> I had a similar problem when trying (in a test situation) to run an
> ASP.NET 2.0 app (RS2005) alongside an ASP.NET 1.1 app.
> Andrew Watt
> MVP - InfoPath
> On Thu, 7 Apr 2005 04:23:02 -0700, ejswanson
> <ejswanson1@.community.nospam> wrote:
> >Hi Michael,
> >
> >I did download the patch and installed it on the machine. I also rebooted
> >the machine a number of times.
> >
> >Yes, I am logged on as local administrator.
> >
> >Do I need to make sure that the reporting service is logged on as a local
> >administrator?
> >
> >The particular web site that I am attempting to get reporting services
> >running also has another asp.net web application running in it. Would this
> >cause this issue? Please send me any other questions or other files that you
> >need in order to determine the resolution.
> >
> >Thanks
> >
> >Eric
> >
> >"Michael Cheng [MSFT]" wrote:
> >
> >> Hi ejswanson,
> >>
> >> From your descriptions, I understood that you followed KB article Q887787
> >> but it still report the error message "The application attempted to perform
> >> an operation not allowed by the security policy." If I have misunderstood
> >> your concern, please feel free to point it out.
> >>
> >> First of all, I would like to double confirm that you have download .config
> >> files from KB article Q887787
> >> http://download.microsoft.com/download/9/8/C/98CEED6D-3489-4504-BBB5-586B630
> >> 01CE0/887787.exe
> >>
> >> and you have replaced your current .config files with the .config files
> >> from the package as KB described and restart machine finally.
> >>
> >> Secondly, are you logon the system with the privilege as local
> >> administrator? More detailed information, I beileve, will make us closer to
> >> the resolution.
> >>
> >> If you have any questions or concerns, don't hesitate to let me know. We
> >> are always here to be of assistance!
> >>
> >>
> >> Sincerely yours,
> >>
> >> Michael Cheng
> >> Microsoft Online Partner Support
> >>
> >> When responding to posts, please "Reply to Group" via your newsreader so
> >> that others may learn and benefit from your issue.
> >> =====================================================> >>
> >> This posting is provided "AS IS" with no warranties, and confers no rights.
> >>
> >>
>|||Hi Eric,
It seems strange so that please collect the following information in a
zipped file and send to me direcly v-mingqc@.online.microsoft.com (please
remove 'online' as it is only for SPAM)
1. Send me these two configuration files
%ProgramFiles%\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\rssrvpolicy.config
%ProgramFiles%\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\rsmgrpolicy.config
2. Send me Reporting Services Error Logs
Additionally, please let me know whether Reporting Services works fine
before or it fails with this error message right after the installation?
Last but not the least, please understand that this issue might tend to be
very complex and hard to troubleshoot in newsgroups. If you need further
assistance, I recommend that you open a Support incident with Microsoft
Customer Service and Support (CSS) so that a dedicated Support Professional
can work with you in a more timely and efficient manner. If you need any
help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks, I will call ms support.
"Michael Cheng [MSFT]" wrote:
> Hi Eric,
> It seems strange so that please collect the following information in a
> zipped file and send to me direcly v-mingqc@.online.microsoft.com (please
> remove 'online' as it is only for SPAM)
> 1. Send me these two configuration files
> %ProgramFiles%\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\rssrvpolicy.config
> %ProgramFiles%\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\rsmgrpolicy.config
> 2. Send me Reporting Services Error Logs
> Additionally, please let me know whether Reporting Services works fine
> before or it fails with this error message right after the installation?
> Last but not the least, please understand that this issue might tend to be
> very complex and hard to troubleshoot in newsgroups. If you need further
> assistance, I recommend that you open a Support incident with Microsoft
> Customer Service and Support (CSS) so that a dedicated Support Professional
> can work with you in a more timely and efficient manner. If you need any
> help in this regard, please let me know.
> For a complete list of Microsoft Customer Service and Support phone
> numbers, please go to the following address on the World Wide Web:
> <http://support.microsoft.com/directory/overview.asp>
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Eric,
Thanks for your understanding and cooperation, If you have any questions or
concerns on SQL Server next time, don't hesitate to let me know. We are
always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.