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
