Report Viewer web part (sp2)

Does anyone know how to pass parameters through to the Sharepoint
Report Viewer web part?
Thanks,
Paul.Go to the site:
http://blogs.sqlxml.org/bryantlikes/articles/628.aspx
It's give some advices. I hope that will help you

Report Server Windows Service (MSSQLSERVER)

I'm really stuck and I'm not sure what I'm supposed to do!?
I've started receiving the following error in my SBS2003 R2 SP2 server
performance report.
Source: Report Server Windows Service (MSSQLSERVER)
Event ID: 120
Total Occurrences: *2
The report server cannot decrypt the symmetric key. Most likely, the service
account or password has changed. To continue, run rsconfig.exe to update the
report server account information.\r\n
I'm not totally sure what commands I need to use with rsconfig.exe.
And I'm not sure if I select Delete from SQL Server 2005\Configuration
Tools\Reporting Services Configuration will cause more problems.
I've tried to Backup encryption key from Reporting Services Configuration
but it gave me the error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server
cannot decrypt the symmetric key used to access sensitive or encrypted data
in a report server database. You must either restore a backup key or delete
all encrypted content. Check the documentation for more information.
(rsReportServerDisabled)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at
ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[]& encryptedBytes, String password)
which is weird becuase I've never taken a backup when I originally installed
SBS2003 R2 so I can't even Restore the encryption key.
I've tried following the threads but again I'm not totally sure.
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=cbc4ecc2-1023-4449-9838-5577a9c3b17c&sloc=en-us
Is there a way to correct this using Report Service Configuration tool or
SQL Server 2005'I hit the same issue, I dont know how. I must have installed Reporting
Services at least 6 times and 4 out of 6 times I have had wierd issues
and not the same one. ANyways..
for your problem - I just deleted the encrypted content, hit apply.
Restarted the Reporting Services and then I was able to backup the
keys fine.
On May 22, 5:57 am, ck <c...@.discussions.microsoft.com> wrote:
> I'm really stuck and I'm not sure what I'm supposed to do!?
> I've started receiving the following error in my SBS2003 R2 SP2server
> performancereport.
> Source:ReportServerWindows Service (MSSQLSERVER)
> Event ID: 120
> Total Occurrences: *2
> Thereportservercannotdecryptthesymmetrickey. Most likely, the service
> account or password has changed. To continue, run rsconfig.exe to update =thereportserveraccount information.\r\n
> I'm not totally sure what commands I need to use with rsconfig.exe.
> And I'm not sure if I selectDeletefrom SQLServer2005\Configuration
> Tools\Reporting Services Configuration will cause more problems.
> I've tried toBackupencryptionkeyfrom Reporting Services Configuration
> but it gave me the error:
> ReportServicesConfigUI.WMIProvider.WMIProviderException: Thereportserverc=annotdecryptthesymmetrickeyusedtoaccesssensitiveorencrypteddata
> in areportserverdatabase.Youmusteitherrestoreabackupkeyordeleteallencrypt=edcontent. Check the documentation for more information.
> (rsReportServerDisabled)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(Manag=em=ADentBaseObject mo)
> at
> ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKe=y(=ADByte[]& encryptedBytes, String password)
> which is weird becuase I've never taken abackupwhen I originally installed
> SBS2003 R2 so I can't evenRestorethe encryptionkey.
> I've tried following the threads but again I'm not totally sure.
> http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us...
> Is there a way to correct this usingReportService Configuration tool or
> SQLServer2005'

Report server spawning multiple w3wp.exe threads

We have Win2003 SP1, SQL 2000 SP4, RS 2000 SP2 installed on our dev
machine and it works ok - having problems using anonamous access under
IIS but that is another issue.....
On our production server ( win2003 SP1, SQL 2000 SP4 ) we installed RS
2000 and SP2, accepting all the default installation options accept
SSL, and we have the following problems....
When we try to access http:\\servername\reports it takes a good few
minutes to load the web page, after asking for a domain user account,
and then the whole server runs like a dog.
Just getting to the first web page creates 12-15 copies of w3wp.exe,
each of which swallow between 20 and 130 MB of memory, and ramps up the
CPU usage.
I you try to upload a report, or access an existing report it spawns
off another 8-10 copies of w3wp.exe and eats more memory, and seriously
slows the server down.
The only way to release the resources it has useems to be to restart
IIS.
I "think" that this may be due to some hardening or lock down of
production server, but I am struggling on what to do next.
The RS logs do not seem to show any problems, but the Win App log shows
"ID 124 ReportServer Service has been activated" 5-6 times for every
action you take against reporting services.
I have been through the "checking reporting services is installed"
guides and it all seems ok, so there is something key I am missing here
!!!
Anyone else had similar problems and found the solution, or could at
least point me in the right direction to progress this issue !An update...
Thanks our freinds at the hosting company, it turns out this was all
due to .Net framework and IIS
We have apps running under 1.1 and 2.0 frameworks, and RS was set to
use default app pool on the IIS config.
Created a new app pool, and let both RS directories use that instead -
bingo !
Lots of w3wp.exe still created, but not hosing the box, and the number
goes up and down as usage changes.
Advice has been to create a new app pool just for reporting services,
as it is a hungry beast !

report server service stopping unexpectedly

we run ssrs 2005 sp2 hotfix applied - how do we troubleshoot a problem where the report server service is stopping unexpectedly several times a day. When this happens please tell me what happens to the reports that are currently running. I believe that

1) a current subscription that is running will fail - not sure if it will try to restart itself 3 times or not

2) connection to the report server db cannot be made when that occurs

this is a huge problem for us and we dont know what is causing it or how to fix it. Any suggestions would help. I can tell you that our customers flood the server with subscriptions

Hi,

You can find detailed informaion about the SSRS service in the log files at this location:

<drive:>\Program Files\Microsoft SQL Server\MSSQL.<n>\Reporting Services\LogFiles\

It should help to identify the problem.

Regards,

Janos

|||

thanks - but I am already aware of the log files at that location and looking in them is not telling me the reason why the service is stopping unexpectedly. There isnt anything in the log file that I can see which would indicate that behavior.

Please ... if there is something I am missing that you are aware of ... a particular type of error that would cause the service to stop then let I would like to know about it. Thank you.

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 is not responding for XP2 sp2 and SQL Server 05 Dev

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

REPORT SERVER COULD NOT FOUND http:\\localhost ?

Hi Gurus;

How can Start Report Server At my local Machine

I installed Reporting Services and Reporting Services SP2, Sql Server 2000 and Sql Server 2004 SP4 ,IIS and VS.net 2003 and 2005.

And Another Question ?f you not busy :)

How can show my report in my programs ?

Your report server can be reached with this url

http://localhost/reports

If you want to put reports on your apllications the easies way is to use the reportviewer, its a free control that you can download for visual studio .net 2003 and its included on the toolbox on visual studio 2005.

There are many ways more to render but thats the easier to start.

|||

thanks for your reply .

but ? cant work report server so http://localhost/reports doesn't consist on my machine and it is not appear Services(Local).

My first problem this is. How I can make Report Server works in my machine?

|||

welll your english a little difficult to understand.

1. Did u already install it?

2. It seems that you installed sql server without reporting services because there is no service on the service manager.

Install it again.

report server compatability issues

Hello!

I have sql server 2000(sp2) rs installed on one of my mashine and I am using VS,NET 2005 to develop some reports.

At the deploing step I am getting some error:

"Connection could not be made to the report server http://..."

Additional information on error message says:

"The attempt to connect to report server failed.Check your connection information and that report server is a compatible version. (Microsoft.ReportingServices.Designer)."

Can't find any information about this issue. Is there anything I have to do to fix this.

Reports made in VS2005 are not compatible with the 2000 version of Reporting Services. You will need RS2005 to work with VS2005 reports.

|||

I have vs2005 with rs2005 installed and I still get the same problem.

I have been trying anything I could think about, but nothing helps.

Here are my details:

TargetDataSourceFolder: Data Sources

TargetReportFolder: reportserver

TargetServerURL: http://localhost/reportserver

Whats am I doing wrong? The iis is properly installed....

Please help,

Uri

report server cannot be initialized

Hi!
I have a problem while i want to test the status of the report server in my
win xp os:
-my os is win xp professional + sp2
-first i installed iis
-then i installed sql server 2005 standard edition
but when i want to initialize reporting service (using configure report
server page) , the "initialized "
option is disabled, and when i type http://localhost/reportserver in IE, IE
changes the address to a search keyword and
doesn't display report server page.
please, give me a solution for this!
thanks!Verify your web server is running and make sure you have asp.net installed,
run %WINNT%\Microsoft.NET\Framework\%framework version%\aspnet_regiis.exe -i.
Open IIS console and verify that the virtual directory reportserver and
reports exist, browse the default the root of the reprtserver virtual from
IIS. Did you change the default virtual directory during the install..?
"fazarmnia" wrote:
> Hi!
> I have a problem while i want to test the status of the report server in my
> win xp os:
> -my os is win xp professional + sp2
> -first i installed iis
> -then i installed sql server 2005 standard edition
> but when i want to initialize reporting service (using configure report
> server page) , the "initialized "
> option is disabled, and when i type http://localhost/reportserver in IE, IE
> changes the address to a search keyword and
> doesn't display report server page.
> please, give me a solution for this!
> thanks!

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
>

Report render to PDF hangs

I've got a complex report with many subreports that is running on a reporting services 2005 machine with sp2 installed. The report was working well, producing a 2800 page report in under 10 minutes. I made a change to an expression in a table's column header and one change to the detail and the report stopped working. It would just hang for hours with no messages in the logs.

I tried to simplify what the report server had to do by removing the sum's to the database side's stored proc but that didn't work. I finally managed to get the report to work by removing a totals section to a subreport. I've also had the same hanging condition occur when I merged some columns in the table. I also found a workaround for this problem.

Is anyone else finding problems like this? They don't seem to be code related.

Is there a limit to how complex a report can be in reporting services or the PDF rendering part of the process?

Thanks for any info

There is no easy to define limit to how "much" of a report can be rendered to PDF. It depends on size and complexity of the report and muscle of the server(s). Can you describe the hardware a bit? If you capture a perfmon while the hang is occuring, how does CPU, memory, disk, and network look? Also, is this reproducible? If you revert the change, does the report export?

Thank you.

|||

The machines running are 4 processor 3.2Ghz zeon's with 3GB Ram.

We didn't run perfmon, but normally get paged if there are performance issues.

I am able to reproduce this problem. I narrowed the recordset down to a particular agency, a subset of the full recordset The subset recordset contains 59 rows for the main report and 20 rows for the subreport, so it's not a large amount of data. We have agencies that are many times more complicated that print fine.

Strangely enough, I got it to work, when I pushed off the totals section to a subreport. That section had 2 running sums in it and some expressions based on data fields. I passed those over to the subreport as parameters and it worked fine.

This is not the only time, we've had this hang and had to look for a workaround. I also had a problem like this when I merged some columns in a table. The problem was happening to a completely different agency than before. Now when I develop in this report, I do one thing at a time, then deploy and run to be sure I didn't introduce another hang situation.

Is this behavior common to reporting services?

|||

If the dataset is large, the report is complex, the hardware is underpowered, or some combination of the three, exporting to PDF can get bogged down, even in SQL Server 2005 SP2. One way to figure out what's going on is to look at the ExecutionLog table in the ReportServer database.

Execute the report and then look at the last 5 columns. If RowCount is large, consider pushing off some data filtering into the TSQL - this should also decrease TimeDataRetrieval. If TimeProcessing is large, see if there is anything you're doing in the report that can be better handled by SQL server - like, sorting or aggregation. Also, try and reduce the complexity of any expressions you have in the report. If TimeRendering is large, it could be you're running into inefficiencies in the rendering engine. We've made good progress and improved perf in RS 2005 but we're still not where I'd like us to be so have more work to do. If ByteCount is large, consider breaking the report up so users don't have to deal with 50M PDF files. If archival is your goal, you might consider a different format like HTML that is much easier to grep later than PDF. Tudor has some suggestions as well on http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx.

"Hanging" is not common, though slow rendering when there's a lot to do or not enough hardware to do it on is more common.

I don't understand why merging columns would make that much of an impact, however. If you have a repro, please open a bug so I can take a look. If you can't get to http://connect.microsoft.com, you can email me the details directly (click on my name to the left and you'll find my email address).

Thank you.

|||

Hi Donovan,

Thanks for your help.

I've got a question still, I'm not sure that this is bug ticket worthy so I figured I'll run it by you here first.

This is from the ExecutionLog table.

This report was successful. This record is the full recordset and produced. I moved a totals section to a sub report to get it to work.

RequestType Format TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount

-- -- -- -- -- - --

0 PDF 2007-03-09 10:14:42.723 2007-03-09 10:22:30.500 19070 269112 179356 1 rsSuccess 8969543 8569

This recordset here, is one that didn't work. This code is prior to me moving the totals section out to a subreport. Also, this recordset is a subset, just one agency and it's associated records. After a half hour I cancelled the job.

The TimeRendering is very large and the TimeDataRetrieval also seems large for that recordset.

RequestType Format TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount

-- - -- -- -- -- - - --

0 PDF 2007-03-08 10:47:09.303 2007-03-08 11:15:53.803 20642 2690 1700930 1 rsJobWasCanceled 0 131

The difference between the 2 versions of code, is that the one that's failing has 3 footer rows for the same grouping, 4 of the text boxes contain =FormatCurrency(Fields!XYZ.Value) type values and one contains an =IIF(Fields!CompType.Value = "SA", "XYZ Based Compensation", "ABC Based Compensation") + " Totals For This Period:"

I replaced those 3 footers, with one footer that calls a subreport, ironically, the sub reports parameters contains the same formatcurrency items and the iif.

I'm not sure what to think, it looks like a bug, but wouldn't TimeDataRetrieval indicate database side inefficiency?

What do you think?

Scott

|||

That doesn't sound right - time rendering seems too high. Would you please email me a copy of the rdls so I can see what's happening in the code?

The TIFF and PDF renderer share a lot of the same code. Is TIFF also that slow in exporting that report?

Regarding the TimeDataRetrieval column, if you take the queries out of the reports and run them against the server manually, how do the times compare?

Thank you.

Report render to PDF hangs

I've got a complex report with many subreports that is running on a reporting services 2005 machine with sp2 installed. The report was working well, producing a 2800 page report in under 10 minutes. I made a change to an expression in a table's column header and one change to the detail and the report stopped working. It would just hang for hours with no messages in the logs.

I tried to simplify what the report server had to do by removing the sum's to the database side's stored proc but that didn't work. I finally managed to get the report to work by removing a totals section to a subreport. I've also had the same hanging condition occur when I merged some columns in the table. I also found a workaround for this problem.

Is anyone else finding problems like this? They don't seem to be code related.

Is there a limit to how complex a report can be in reporting services or the PDF rendering part of the process?

Thanks for any info

There is no easy to define limit to how "much" of a report can be rendered to PDF. It depends on size and complexity of the report and muscle of the server(s). Can you describe the hardware a bit? If you capture a perfmon while the hang is occuring, how does CPU, memory, disk, and network look? Also, is this reproducible? If you revert the change, does the report export?

Thank you.

|||

The machines running are 4 processor 3.2Ghz zeon's with 3GB Ram.

We didn't run perfmon, but normally get paged if there are performance issues.

I am able to reproduce this problem. I narrowed the recordset down to a particular agency, a subset of the full recordset The subset recordset contains 59 rows for the main report and 20 rows for the subreport, so it's not a large amount of data. We have agencies that are many times more complicated that print fine.

Strangely enough, I got it to work, when I pushed off the totals section to a subreport. That section had 2 running sums in it and some expressions based on data fields. I passed those over to the subreport as parameters and it worked fine.

This is not the only time, we've had this hang and had to look for a workaround. I also had a problem like this when I merged some columns in a table. The problem was happening to a completely different agency than before. Now when I develop in this report, I do one thing at a time, then deploy and run to be sure I didn't introduce another hang situation.

Is this behavior common to reporting services?

|||

If the dataset is large, the report is complex, the hardware is underpowered, or some combination of the three, exporting to PDF can get bogged down, even in SQL Server 2005 SP2. One way to figure out what's going on is to look at the ExecutionLog table in the ReportServer database.

Execute the report and then look at the last 5 columns. If RowCount is large, consider pushing off some data filtering into the TSQL - this should also decrease TimeDataRetrieval. If TimeProcessing is large, see if there is anything you're doing in the report that can be better handled by SQL server - like, sorting or aggregation. Also, try and reduce the complexity of any expressions you have in the report. If TimeRendering is large, it could be you're running into inefficiencies in the rendering engine. We've made good progress and improved perf in RS 2005 but we're still not where I'd like us to be so have more work to do. If ByteCount is large, consider breaking the report up so users don't have to deal with 50M PDF files. If archival is your goal, you might consider a different format like HTML that is much easier to grep later than PDF. Tudor has some suggestions as well on http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx.

"Hanging" is not common, though slow rendering when there's a lot to do or not enough hardware to do it on is more common.

I don't understand why merging columns would make that much of an impact, however. If you have a repro, please open a bug so I can take a look. If you can't get to http://connect.microsoft.com, you can email me the details directly (click on my name to the left and you'll find my email address).

Thank you.

|||

Hi Donovan,

Thanks for your help.

I've got a question still, I'm not sure that this is bug ticket worthy so I figured I'll run it by you here first.

This is from the ExecutionLog table.

This report was successful. This record is the full recordset and produced. I moved a totals section to a sub report to get it to work.

RequestType Format TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount -- -- -- -- -- - -- 0 PDF 2007-03-09 10:14:42.723 2007-03-09 10:22:30.500 19070 269112 179356 1 rsSuccess 8969543 8569

This recordset here, is one that didn't work. This code is prior to me moving the totals section out to a subreport. Also, this recordset is a subset, just one agency and it's associated records. After a half hour I cancelled the job.

The TimeRendering is very large and the TimeDataRetrieval also seems large for that recordset.

RequestType Format TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount -- - -- -- -- -- - - -- 0 PDF 2007-03-08 10:47:09.303 2007-03-08 11:15:53.803 20642 2690 1700930 1 rsJobWasCanceled 0 131

The difference between the 2 versions of code, is that the one that's failing has 3 footer rows for the same grouping, 4 of the text boxes contain =FormatCurrency(Fields!XYZ.Value) type values and one contains an =IIF(Fields!CompType.Value = "SA", "XYZ Based Compensation", "ABC Based Compensation") + " Totals For This Period:"

I replaced those 3 footers, with one footer that calls a subreport, ironically, the sub reports parameters contains the same formatcurrency items and the iif.

I'm not sure what to think, it looks like a bug, but wouldn't TimeDataRetrieval indicate database side inefficiency?

What do you think?

Scott

|||

That doesn't sound right - time rendering seems too high. Would you please email me a copy of the rdls so I can see what's happening in the code?

The TIFF and PDF renderer share a lot of the same code. Is TIFF also that slow in exporting that report?

Regarding the TimeDataRetrieval column, if you take the queries out of the reports and run them against the server manually, how do the times compare?

Thank you.