After Intallation

I have a box with SQL Server DataServices with W2K3 SP2 & SQL2005 SP2, then
I have a box with W2K3 with SP2 where I have Reporting Services, at the
configuration page, everything is green and all services started,
initialized and I get this error from:
http://<server>/reports
"Unable to connect to the remote server"
Any Ideas?
Thanks,
VictorOn Jun 18, 12:52 pm, "Victor Rodriguez" <lasals...@.newsgroups.nospam>
wrote:
> I have a box with SQL Server DataServices with W2K3 SP2 & SQL2005 SP2, then
> I have a box with W2K3 with SP2 where I have Reporting Services, at the
> configuration page, everything is green and all services started,
> initialized and I get this error from:
> http://<server>/reports
> "Unable to connect to the remote server"
> Any Ideas?
> Thanks,
> Victor
Have you made sure that IIS is running on your Reporting Services box?
It's turned off by default in Win2003.
rb|||I have 10 different sites on the same box and they're all working.
Victor
"roger.bigger@.good-dog.net" <roger.bigger@.gmail.com> wrote in message
news:1182186112.402444.169070@.m36g2000hse.googlegroups.com...
> On Jun 18, 12:52 pm, "Victor Rodriguez" <lasals...@.newsgroups.nospam>
> wrote:
>> I have a box with SQL Server DataServices with W2K3 SP2 & SQL2005 SP2,
>> then
>> I have a box with W2K3 with SP2 where I have Reporting Services, at the
>> configuration page, everything is green and all services started,
>> initialized and I get this error from:
>> http://<server>/reports
>> "Unable to connect to the remote server"
>> Any Ideas?
>> Thanks,
>> Victor
> Have you made sure that IIS is running on your Reporting Services box?
> It's turned off by default in Win2003.
> rb
>|||Hello Victor,
To know the issue better, please let me know the following:
1. Can you access http://<server>/reportserver properly?
2. Please check if the following ls listed properly in
RSWebApplication.config. If you have SSL enabled for the report server,
please make sure the following is listed
<UrlRoot>https://<server>/ReportServer</UrlRoot>
<ReportServerUrl>https://<server>/ReportServe</ReportServerUrl>
RSWebApplication.config is under
C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting
Services\ReportManager
In addition, this issue could occur if some Antivirus program is installed.
You may want to check if the issue occurs if they are disabled on your
server.
If you have any update, please feel free to let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||When I try to run http://<server>/reportserver, i get:
<server>/ReportServer - /
Microsoft SQL Server Reporting Services Version 9.00.3042.00
I don't have SSL on the website, don't have antivirus on the server.
Anything else I could check?
Thanks,
Victor
""Peter YangMSFT]"" <petery@.online.microsoft.com> wrote in message
news:RzcYHihsHHA.3672@.TK2MSFTNGHUB02.phx.gbl...
> Hello Victor,
> To know the issue better, please let me know the following:
> 1. Can you access http://<server>/reportserver properly?
> 2. Please check if the following ls listed properly in
> RSWebApplication.config. If you have SSL enabled for the report server,
> please make sure the following is listed
> <UrlRoot>https://<server>/ReportServer</UrlRoot>
> <ReportServerUrl>https://<server>/ReportServe</ReportServerUrl>
> RSWebApplication.config is under
> C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting
> Services\ReportManager
> In addition, this issue could occur if some Antivirus program is
> installed.
> You may want to check if the issue occurs if they are disabled on your
> server.
> If you have any update, please feel free to let's know. Thank you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>|||Hello Victor,
From the result, it seems the issue only occurs on report manager. Going
forward, please let me know what's the configuration of <UrlRoot> and
<ReportServerUrl> in the file RSWebApplication.config. Please make sure the
server name is correct, and you may want to use the FQDN such as
server.domain.com if it's a memeber server of a domain.
If the issue persists, please collect the ReportServerWebApp log under the
following folder and let's know the detailed error information:
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles
If you have other related information, please feel free to let's know.
Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks for your response,
I don't have UrlRoot and the <ReportServerUrl></ReportServerUrl> is like
this.
This is the error I get on the logfile:
w3wp!ui!5!6/20/2007-11:28:57:: e ERROR: Unable to connect to the remote
server
w3wp!ui!5!6/20/2007-11:28:58:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: Unable to connect to the remote server -->
System.Net.Sockets.SocketException: No connection could be made because the
target machine actively refused it
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot,
SocketAddress socketAddress)
at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure,
Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState
state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
-- End of inner exception stack trace --
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!6/20/2007-11:29:00:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
Victor
""Peter YangMSFT]"" <petery@.online.microsoft.com> wrote in message
news:S20P4KwsHHA.2316@.TK2MSFTNGHUB02.phx.gbl...
> Hello Victor,
> From the result, it seems the issue only occurs on report manager. Going
> forward, please let me know what's the configuration of <UrlRoot> and
> <ReportServerUrl> in the file RSWebApplication.config. Please make sure
> the
> server name is correct, and you may want to use the FQDN such as
> server.domain.com if it's a memeber server of a domain.
> If the issue persists, please collect the ReportServerWebApp log under the
> following folder and let's know the detailed error information:
> C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles
> If you have other related information, please feel free to let's know.
> Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>|||Hello Victor,
Did you try to change <ReportServerUrl></ReportServerUrl> to
ReportServerUrl>http://servername/ReportServer</ReportServerUrl>?
Also, please check the appliation pool of report manager by running
"inetmgr", and make sure the user of appliation pool has the full
permission of reporting service physical folder.
I look forward to your reply. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks for your response, I tried all your recommendation and still in the
same place, any other suggestions?
Victor
""Peter YangMSFT]"" <petery@.online.microsoft.com> wrote in message
news:FA1vfM9sHHA.2316@.TK2MSFTNGHUB02.phx.gbl...
> Hello Victor,
> Did you try to change <ReportServerUrl></ReportServerUrl> to
> ReportServerUrl>http://servername/ReportServer</ReportServerUrl>?
> Also, please check the appliation pool of report manager by running
> "inetmgr", and make sure the user of appliation pool has the full
> permission of reporting service physical folder.
> I look forward to your reply. Thank you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>|||Hello,
Will you post the content of the file RSWebApplication.config? You may want
to check if it has the following lines:
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
Also, please change the <UrlRoot>machine name/reportserver</<UrlRoot> to
<UrlRoot>FQDN/reportserver</<UrlRoot> in RSReportServer.config file.
You may want to restart IIS by running "iisrest" to take effect.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Victor, have you made it by this time?
I still can't figure it out. If I fill the <ReportServerUrl> (which is
blank by default in my environment) I get the following error message:
"The configuration file contains an element that is not valid. The
ReportServerUrl element is not a configuration file element."
I do not have SSL. Does anyone have an idea? Still stuck on this
issue... :-(
Leo Lopes @. L3