Long running reports

We have several business areas that want to run a scheduled batch job to
render reports in a pdf file to them. We seem to be hitting an issue with
reports that take longer than 15 minutes to render.
We get the error message, " The underlying connection was closed: Could not
establish secure channel for SSL/TLS" and "An existing connection was
forcibly closed by the remote host"
I have been able to render the reports from the report manager after I set
the default timeout setting to nothing and let the report churn for in some
cases 45 minutes. We have larger volumes of financial data.
Corporately we are looking at setting a timeout standard and having the
report builders create temp tables to report from for the longer running
reports, but more specifiically I am wondering what are all the possible
timeout setting that could be forcing the connection closed? Report
manager? IIS? and has anyone else dealt with this issue and if so how did
you address it?Hello,
I think this issue is caused by IIS timeout settings:
1. Click "Start", and then click "Control Panel".
2. Double-click "Administrative Tools", and then double-click "Internet
Information Services Manager".
3. Expand "Web Sites", right-click "Default Web Site" , and then click
"Properties".
4. Click the "Web Site" tab.
5. In the "Connections" section, in the "Connection timeout" box, increase
the seconds to a value that is sufficient for the length of the import.
Also, please disable Keep-Alives.
6. Click "OK".
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.
| Thread-Topic: Long running reports
| thread-index: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==| X-WBNR-Posting-Host: 64.73.98.126
| From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
| Subject: Long running reports
| Date: Tue, 31 May 2005 15:58:11 -0700
| Lines: 18
| Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45040
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| We have several business areas that want to run a scheduled batch job to
| render reports in a pdf file to them. We seem to be hitting an issue with
| reports that take longer than 15 minutes to render.
|
| We get the error message, " The underlying connection was closed: Could
not
| establish secure channel for SSL/TLS" and "An existing connection was
| forcibly closed by the remote host"
|
| I have been able to render the reports from the report manager after I
set
| the default timeout setting to nothing and let the report churn for in
some
| cases 45 minutes. We have larger volumes of financial data.
|
| Corporately we are looking at setting a timeout standard and having the
| report builders create temp tables to report from for the longer running
| reports, but more specifiically I am wondering what are all the possible
| timeout setting that could be forcing the connection closed? Report
| manager? IIS? and has anyone else dealt with this issue and if so how
did
| you address it?
||||Peter,
Some more information on the specific error and what we have tried. We have
bumped up the timeout settings for the report manager, the IIS settings on
the developers local maching and disabled keep alives. Are their any more
areas where we could be hitting a timeout parameter. While I wait for your
response I will discuss this further with our server team and SQL dba's for
their suggestions.
here is the actual error log.
******************************************************
I increased the Individual timeout for the report to 1800 seconds and the
IIS settings on my local machine, but the report is still timing out.
with KeepAlive enabled or disabled...
----
*****Creating Report GainsChartReport_CM dan.rhoades@.cunamutual.com
Type=Excel Campaign_Code=C000000010 AC_Product_Code=-1 Contract=-1 *****
Program Started at: 6/1/2005 11:16:35 AM
-- Exception Log Entry --
ENVIRONMENT INFORMATION:
TimeStamp: 6/1/2005 11:32:23 AM
MachineName: WWVXP525563
AppDomainName: RenderReports.exe
ThreadIdentity:
WindowsIdentity: CMUTUAL\cc1854
EXCEPTION INFORMATION:
Exception Type: System.Net.WebException
Status: SecureChannelFailure
Message: The underlying connection was closed: Could
not establish secure channel for SSL/TLS.
TargetSite: System.Net.WebResponse
GetWebResponse(System.Net.WebRequest)
Source: System.Web.Services
Stack Trace:
at
System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
request)
at
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest
request)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at RenderReports.ReportingServices.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds)
at RenderReports.Main.RenderEmailLinkReport(String[] strParms, Int32
intReportParameters)
INNER EXCEPTION INFORMATION:
Exception Type: System.IO.IOException
Message: Unable to read data from the transport
connection.
TargetSite: Int32 EndRead(System.IAsyncResult)
Source: System
Stack Trace:
at System.Net.TlsStream.EndRead(IAsyncResult asyncResult)
at System.Net.Connection.ReadCallback(IAsyncResult asyncResult)
INNER EXCEPTION INFORMATION:
Exception Type: System.IO.IOException
Message: Unable to read data from the transport
connection.
TargetSite: Int32 EndRead(System.IAsyncResult)
Source: System
Stack Trace:
at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
at System.Net.TlsStream.AsyncReceiveComplete(IAsyncResult result)
INNER EXCEPTION INFORMATION:
Exception Type: System.Net.Sockets.SocketException
ErrorCode: 10054
NativeErrorCode: 10054
Message: An existing connection was forcibly closed by
the remote host
TargetSite: Int32 EndReceive(System.IAsyncResult)
Source: System
Stack Trace:
at System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult)
at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
ADDITIONAL INFORMATION:
Error Rendering Report: GainsChartReport_CM
-- Exception Entry End --
**
**
** StartReport = 6/1/2005 11:16:36 AM StopReport = 6/1/2005 11:32:23 AM
** Report GainsChartReport_CM failed after 15 minutes 47 seconds
Program Ended at: 6/1/2005 11:32:25 AM
*----*
*******************************************************
"Peter Yang [MSFT]" wrote:
> Hello,
> I think this issue is caused by IIS timeout settings:
> 1. Click "Start", and then click "Control Panel".
> 2. Double-click "Administrative Tools", and then double-click "Internet
> Information Services Manager".
> 3. Expand "Web Sites", right-click "Default Web Site" , and then click
> "Properties".
> 4. Click the "Web Site" tab.
> 5. In the "Connections" section, in the "Connection timeout" box, increase
> the seconds to a value that is sufficient for the length of the import.
> Also, please disable Keep-Alives.
> 6. Click "OK".
> 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.
>
>
> --
> | Thread-Topic: Long running reports
> | thread-index: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==> | X-WBNR-Posting-Host: 64.73.98.126
> | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
> | Subject: Long running reports
> | Date: Tue, 31 May 2005 15:58:11 -0700
> | Lines: 18
> | Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45040
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | We have several business areas that want to run a scheduled batch job to
> | render reports in a pdf file to them. We seem to be hitting an issue with
> | reports that take longer than 15 minutes to render.
> |
> | We get the error message, " The underlying connection was closed: Could
> not
> | establish secure channel for SSL/TLS" and "An existing connection was
> | forcibly closed by the remote host"
> |
> | I have been able to render the reports from the report manager after I
> set
> | the default timeout setting to nothing and let the report churn for in
> some
> | cases 45 minutes. We have larger volumes of financial data.
> |
> | Corporately we are looking at setting a timeout standard and having the
> | report builders create temp tables to report from for the longer running
> | reports, but more specifiically I am wondering what are all the possible
> | timeout setting that could be forcing the connection closed? Report
> | manager? IIS? and has anyone else dealt with this issue and if so how
> did
> | you address it?
> |
>|||Hello,
You may also want to check if you encounter the following known issue
884537 FIX: You may receive a "System.Net.WebException" error message when
you
http://support.microsoft.com/?id=884537
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.
| Thread-Topic: Long running reports
| thread-index: AcVmykgAseOX2lghQwamF3cLJGlxpw==| X-WBNR-Posting-Host: 64.73.98.126
| From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
| References: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
<xDIz1QoZFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| Subject: RE: Long running reports
| Date: Wed, 1 Jun 2005 09:52:22 -0700
| Lines: 186
| Message-ID: <DB60FC6A-4119-4C9A-948C-BBE8500DA360@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45109
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Peter,
|
| Some more information on the specific error and what we have tried. We
have
| bumped up the timeout settings for the report manager, the IIS settings
on
| the developers local maching and disabled keep alives. Are their any
more
| areas where we could be hitting a timeout parameter. While I wait for
your
| response I will discuss this further with our server team and SQL dba's
for
| their suggestions.
|
| here is the actual error log.
| ******************************************************
| I increased the Individual timeout for the report to 1800 seconds and the
| IIS settings on my local machine, but the report is still timing out.
|
| with KeepAlive enabled or disabled...
|
|
----
--
| *****Creating Report GainsChartReport_CM dan.rhoades@.cunamutual.com
| Type=Excel Campaign_Code=C000000010 AC_Product_Code=-1 Contract=-1 *****
| Program Started at: 6/1/2005 11:16:35 AM
|
|
| -- Exception Log Entry --
| ENVIRONMENT INFORMATION:
| TimeStamp: 6/1/2005 11:32:23 AM
| MachineName: WWVXP525563
| AppDomainName: RenderReports.exe
| ThreadIdentity:
| WindowsIdentity: CMUTUAL\cc1854
|
| EXCEPTION INFORMATION:
| Exception Type: System.Net.WebException
| Status: SecureChannelFailure
| Message: The underlying connection was closed:
Could
| not establish secure channel for SSL/TLS.
| TargetSite: System.Net.WebResponse
| GetWebResponse(System.Net.WebRequest)
| Source: System.Web.Services
| Stack Trace:
| at
| System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
| request)
| at
|
System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebReques
t
| request)
| at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
| methodName, Object[] parameters)
| at RenderReports.ReportingServices.ReportingService.Render(String
Report,
| String Format, String HistoryID, String DeviceInfo, ParameterValue[]
| Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
| String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
| Warning[]& Warnings, String[]& StreamIds)
| at RenderReports.Main.RenderEmailLinkReport(String[] strParms, Int32
| intReportParameters)
|
| INNER EXCEPTION INFORMATION:
| Exception Type: System.IO.IOException
| Message: Unable to read data from the transport
| connection.
| TargetSite: Int32 EndRead(System.IAsyncResult)
| Source: System
| Stack Trace:
| at System.Net.TlsStream.EndRead(IAsyncResult asyncResult)
| at System.Net.Connection.ReadCallback(IAsyncResult asyncResult)
|
| INNER EXCEPTION INFORMATION:
| Exception Type: System.IO.IOException
| Message: Unable to read data from the transport
| connection.
| TargetSite: Int32 EndRead(System.IAsyncResult)
| Source: System
| Stack Trace:
| at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
| at System.Net.TlsStream.AsyncReceiveComplete(IAsyncResult result)
|
| INNER EXCEPTION INFORMATION:
| Exception Type: System.Net.Sockets.SocketException
| ErrorCode: 10054
| NativeErrorCode: 10054
| Message: An existing connection was forcibly closed
by
| the remote host
| TargetSite: Int32 EndReceive(System.IAsyncResult)
| Source: System
| Stack Trace:
| at System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult)
| at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
|
| ADDITIONAL INFORMATION:
| Error Rendering Report: GainsChartReport_CM
|
| -- Exception Entry End --
| **
| **
| ** StartReport = 6/1/2005 11:16:36 AM StopReport = 6/1/2005 11:32:23 AM
| ** Report GainsChartReport_CM failed after 15 minutes 47 seconds
| Program Ended at: 6/1/2005 11:32:25 AM
|
*----
*
| *******************************************************
|
| "Peter Yang [MSFT]" wrote:
|
| > Hello,
| >
| > I think this issue is caused by IIS timeout settings:
| >
| > 1. Click "Start", and then click "Control Panel".
| >
| > 2. Double-click "Administrative Tools", and then double-click "Internet
| > Information Services Manager".
| >
| > 3. Expand "Web Sites", right-click "Default Web Site" , and then click
| > "Properties".
| >
| > 4. Click the "Web Site" tab.
| >
| > 5. In the "Connections" section, in the "Connection timeout" box,
increase
| > the seconds to a value that is sufficient for the length of the import.
| > Also, please disable Keep-Alives.
| >
| > 6. Click "OK".
| >
| > 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.
| >
| >
| >
| >
| > --
| > | Thread-Topic: Long running reports
| > | thread-index: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==| > | X-WBNR-Posting-Host: 64.73.98.126
| > | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
| > | Subject: Long running reports
| > | Date: Tue, 31 May 2005 15:58:11 -0700
| > | Lines: 18
| > | Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.sqlserver.reportingsvcs:45040
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | We have several business areas that want to run a scheduled batch job
to
| > | render reports in a pdf file to them. We seem to be hitting an issue
with
| > | reports that take longer than 15 minutes to render.
| > |
| > | We get the error message, " The underlying connection was closed:
Could
| > not
| > | establish secure channel for SSL/TLS" and "An existing connection was
| > | forcibly closed by the remote host"
| > |
| > | I have been able to render the reports from the report manager after
I
| > set
| > | the default timeout setting to nothing and let the report churn for
in
| > some
| > | cases 45 minutes. We have larger volumes of financial data.
| > |
| > | Corporately we are looking at setting a timeout standard and having
the
| > | report builders create temp tables to report from for the longer
running
| > | reports, but more specifiically I am wondering what are all the
possible
| > | timeout setting that could be forcing the connection closed? Report
| > | manager? IIS? and has anyone else dealt with this issue and if so
how
| > did
| > | you address it?
| > |
| >
| >
||||Thanks Peter,
I will follow up with our VS. net product manager to find out what service
packs we have deployed.
"Peter Yang [MSFT]" wrote:
> Hello,
> You may also want to check if you encounter the following known issue
> 884537 FIX: You may receive a "System.Net.WebException" error message when
> you
> http://support.microsoft.com/?id=884537
> 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.
>
>
> --
> | Thread-Topic: Long running reports
> | thread-index: AcVmykgAseOX2lghQwamF3cLJGlxpw==> | X-WBNR-Posting-Host: 64.73.98.126
> | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
> | References: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
> <xDIz1QoZFHA.3052@.TK2MSFTNGXA01.phx.gbl>
> | Subject: RE: Long running reports
> | Date: Wed, 1 Jun 2005 09:52:22 -0700
> | Lines: 186
> | Message-ID: <DB60FC6A-4119-4C9A-948C-BBE8500DA360@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:45109
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Peter,
> |
> | Some more information on the specific error and what we have tried. We
> have
> | bumped up the timeout settings for the report manager, the IIS settings
> on
> | the developers local maching and disabled keep alives. Are their any
> more
> | areas where we could be hitting a timeout parameter. While I wait for
> your
> | response I will discuss this further with our server team and SQL dba's
> for
> | their suggestions.
> |
> | here is the actual error log.
> | ******************************************************
> | I increased the Individual timeout for the report to 1800 seconds and the
> | IIS settings on my local machine, but the report is still timing out.
> |
> | with KeepAlive enabled or disabled...
> |
> |
> ----
> --
> | *****Creating Report GainsChartReport_CM dan.rhoades@.cunamutual.com
> | Type=Excel Campaign_Code=C000000010 AC_Product_Code=-1 Contract=-1 *****
> | Program Started at: 6/1/2005 11:16:35 AM
> |
> |
> | -- Exception Log Entry --
> | ENVIRONMENT INFORMATION:
> | TimeStamp: 6/1/2005 11:32:23 AM
> | MachineName: WWVXP525563
> | AppDomainName: RenderReports.exe
> | ThreadIdentity:
> | WindowsIdentity: CMUTUAL\cc1854
> |
> | EXCEPTION INFORMATION:
> | Exception Type: System.Net.WebException
> | Status: SecureChannelFailure
> | Message: The underlying connection was closed:
> Could
> | not establish secure channel for SSL/TLS.
> | TargetSite: System.Net.WebResponse
> | GetWebResponse(System.Net.WebRequest)
> | Source: System.Web.Services
> | Stack Trace:
> | at
> | System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest
> | request)
> | at
> |
> System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebReques
> t
> | request)
> | at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> | methodName, Object[] parameters)
> | at RenderReports.ReportingServices.ReportingService.Render(String
> Report,
> | String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> | Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> | String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> | Warning[]& Warnings, String[]& StreamIds)
> | at RenderReports.Main.RenderEmailLinkReport(String[] strParms, Int32
> | intReportParameters)
> |
> | INNER EXCEPTION INFORMATION:
> | Exception Type: System.IO.IOException
> | Message: Unable to read data from the transport
> | connection.
> | TargetSite: Int32 EndRead(System.IAsyncResult)
> | Source: System
> | Stack Trace:
> | at System.Net.TlsStream.EndRead(IAsyncResult asyncResult)
> | at System.Net.Connection.ReadCallback(IAsyncResult asyncResult)
> |
> | INNER EXCEPTION INFORMATION:
> | Exception Type: System.IO.IOException
> | Message: Unable to read data from the transport
> | connection.
> | TargetSite: Int32 EndRead(System.IAsyncResult)
> | Source: System
> | Stack Trace:
> | at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
> | at System.Net.TlsStream.AsyncReceiveComplete(IAsyncResult result)
> |
> | INNER EXCEPTION INFORMATION:
> | Exception Type: System.Net.Sockets.SocketException
> | ErrorCode: 10054
> | NativeErrorCode: 10054
> | Message: An existing connection was forcibly closed
> by
> | the remote host
> | TargetSite: Int32 EndReceive(System.IAsyncResult)
> | Source: System
> | Stack Trace:
> | at System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult)
> | at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
> |
> | ADDITIONAL INFORMATION:
> | Error Rendering Report: GainsChartReport_CM
> |
> | -- Exception Entry End --
> | **
> | **
> | ** StartReport = 6/1/2005 11:16:36 AM StopReport = 6/1/2005 11:32:23 AM
> | ** Report GainsChartReport_CM failed after 15 minutes 47 seconds
> | Program Ended at: 6/1/2005 11:32:25 AM
> |
> *----
> *
> | *******************************************************
> |
> | "Peter Yang [MSFT]" wrote:
> |
> | > Hello,
> | >
> | > I think this issue is caused by IIS timeout settings:
> | >
> | > 1. Click "Start", and then click "Control Panel".
> | >
> | > 2. Double-click "Administrative Tools", and then double-click "Internet
> | > Information Services Manager".
> | >
> | > 3. Expand "Web Sites", right-click "Default Web Site" , and then click
> | > "Properties".
> | >
> | > 4. Click the "Web Site" tab.
> | >
> | > 5. In the "Connections" section, in the "Connection timeout" box,
> increase
> | > the seconds to a value that is sufficient for the length of the import.
> | > Also, please disable Keep-Alives.
> | >
> | > 6. Click "OK".
> | >
> | > 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.
> | >
> | >
> | >
> | >
> | > --
> | > | Thread-Topic: Long running reports
> | > | thread-index: AcVmNDfsZf6nv6RoTXysyOFdimp4OA==> | > | X-WBNR-Posting-Host: 64.73.98.126
> | > | From: "=?Utf-8?B?TWFyaw==?=" <markwh@.newsgroup.nospam>
> | > | Subject: Long running reports
> | > | Date: Tue, 31 May 2005 15:58:11 -0700
> | > | Lines: 18
> | > | Message-ID: <80219D15-436F-4B8E-AD0D-0C8C604C6B9F@.microsoft.com>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain;
> | > | charset="Utf-8"
> | > | Content-Transfer-Encoding: 7bit
> | > | X-Newsreader: Microsoft CDO for Windows 2000
> | > | Content-Class: urn:content-classes:message
> | > | Importance: normal
> | > | Priority: normal
> | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | > | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | > | Xref: TK2MSFTNGXA01.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:45040
> | > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> | > |
> | > | We have several business areas that want to run a scheduled batch job
> to
> | > | render reports in a pdf file to them. We seem to be hitting an issue
> with
> | > | reports that take longer than 15 minutes to render.
> | > |
> | > | We get the error message, " The underlying connection was closed:
> Could
> | > not
> | > | establish secure channel for SSL/TLS" and "An existing connection was
> | > | forcibly closed by the remote host"
> | > |
> | > | I have been able to render the reports from the report manager after
> I
> | > set
> | > | the default timeout setting to nothing and let the report churn for
> in
> | > some
> | > | cases 45 minutes. We have larger volumes of financial data.
> | > |
> | > | Corporately we are looking at setting a timeout standard and having
> the
> | > | report builders create temp tables to report from for the longer
> running
> | > | reports, but more specifiically I am wondering what are all the
> possible
> | > | timeout setting that could be forcing the connection closed? Report
> | > | manager? IIS? and has anyone else dealt with this issue and if so
> how
> | > did
> | > | you address it?
> | > |
> | >
> | >
> |
>sql

Long Running Reports

I have some reports that need to run for about 10 minutes. I changed the
parameter on the report to "Do not timeout report execution" but I still get
a connection timout error. What else do I need to change?
I get the following error in IE:
10060 - Connection timeout
Internet Security and Acceleration ServerThis error is being returned by your security and acceleration server --
sitting between your browser and the report server. That's where the
timeout needs to be adjusted.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:OJktXvm1EHA.2540@.TK2MSFTNGP09.phx.gbl...
>I have some reports that need to run for about 10 minutes. I changed the
>parameter on the report to "Do not timeout report execution" but I still
>get a connection timout error. What else do I need to change?
> I get the following error in IE:
> 10060 - Connection timeout
> Internet Security and Acceleration Server
>|||That Worked. Thanks :)
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:edph0x11EHA.3596@.TK2MSFTNGP12.phx.gbl...
> This error is being returned by your security and acceleration server --
> sitting between your browser and the report server. That's where the
> timeout needs to be adjusted.
> --
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
> news:OJktXvm1EHA.2540@.TK2MSFTNGP09.phx.gbl...
>>I have some reports that need to run for about 10 minutes. I changed the
>>parameter on the report to "Do not timeout report execution" but I still
>>get a connection timout error. What else do I need to change?
>> I get the following error in IE:
>> 10060 - Connection timeout
>> Internet Security and Acceleration Server
>

Logon failure executing reports in SRS2005

Environment: Application server with WS2003, IIS 6.0 and Reporting Services
2005; Database server with WS2003 and SQL Server 2005.
Each time I want to execure a report I get the following error message:
Logon failed. -->
Logon failure: the user has not been granted the requested logon type at
this computer. (Exception from HRESULT: 0x80070569)
Reporting Services Configuration tool does not show any errors.
Web Service and Windows Service identity both use NT AUTHPORITY/NETWORK
SERVICE.
Database Connection uses sa.
It does not make any difference from where I execute the report, application
server, client, Report Manager, Report Builder, always the same login
fauilure.What user is the Application Pool for the report virtual directories running
under?
I did have lots of problems with a RS server where someone had used a domain
user as the identity for the application pool. This domain user did not have
the access rigth to "Log on as a service", which was needed. I changed the
identity to run as network service, and all the errors went away. Might help
for you as well.
Kaisa M. Lindahl Lervik
"ChrisWF" <ChrisWF@.discussions.microsoft.com> wrote in message
news:0E9D8B8F-2A31-4731-B7B0-9F7D6348D3A1@.microsoft.com...
> Environment: Application server with WS2003, IIS 6.0 and Reporting
> Services
> 2005; Database server with WS2003 and SQL Server 2005.
> Each time I want to execure a report I get the following error message:
> Logon failed. -->
> Logon failure: the user has not been granted the requested logon type at
> this computer. (Exception from HRESULT: 0x80070569)
> Reporting Services Configuration tool does not show any errors.
> Web Service and Windows Service identity both use NT AUTHPORITY/NETWORK
> SERVICE.
> Database Connection uses sa.
> It does not make any difference from where I execute the report,
> application
> server, client, Report Manager, Report Builder, always the same login
> fauilure.|||They run under the Network Service account.
But your response triggered me to check once more the execution account (a
domain account) I use to perform unattended operations. When I added this
account to the administrators group it worked. Probably not the right
solution but at least I could move on with the testing.
Thanks,
Chris
"Kaisa M. Lindahl Lervik" wrote:
> What user is the Application Pool for the report virtual directories running
> under?
> I did have lots of problems with a RS server where someone had used a domain
> user as the identity for the application pool. This domain user did not have
> the access rigth to "Log on as a service", which was needed. I changed the
> identity to run as network service, and all the errors went away. Might help
> for you as well.
> Kaisa M. Lindahl Lervik
> "ChrisWF" <ChrisWF@.discussions.microsoft.com> wrote in message
> news:0E9D8B8F-2A31-4731-B7B0-9F7D6348D3A1@.microsoft.com...
> > Environment: Application server with WS2003, IIS 6.0 and Reporting
> > Services
> > 2005; Database server with WS2003 and SQL Server 2005.
> >
> > Each time I want to execure a report I get the following error message:
> >
> > Logon failed. -->
> > Logon failure: the user has not been granted the requested logon type at
> > this computer. (Exception from HRESULT: 0x80070569)
> >
> > Reporting Services Configuration tool does not show any errors.
> > Web Service and Windows Service identity both use NT AUTHPORITY/NETWORK
> > SERVICE.
> > Database Connection uses sa.
> >
> > It does not make any difference from where I execute the report,
> > application
> > server, client, Report Manager, Report Builder, always the same login
> > fauilure.
>
>

Logon failure

To get my reports to work from the 2005 Report Manager I had to put the
Execution Account into the Local Administrators Group, otherwise I got a
Logon Failoure message when attempting to view the report. Is this how it's
sipposed to be?Don't use anonymous access with windows authentication......
Kinda defeats the purpose.
"Jim Abel" <JimAbel@.discussions.microsoft.com> wrote in message
news:8453498E-99F8-43AA-8ADD-9005C6F2FF35@.microsoft.com...
> To get my reports to work from the 2005 Report Manager I had to put the
> Execution Account into the Local Administrators Group, otherwise I got a
> Logon Failoure message when attempting to view the report. Is this how
> it's
> sipposed to be?|||What do you mean about Anonymous access? In the Report Configuration page I
had a limited donain account set for the services and the execution account.
When a report was selected to be viewed a logon failure error resulted saying
that "The user has not been granted the requested logon type at this machine
"
I was unable to figure out how to change the requested logon type, so I
added the account to the Local Administrators group and I no longer got the
Logon failure error. Now I thought that Microsoft was attempting to secure
the way that things worked so that an account as in this case would not need
to have such elevated permissions. I am looking for information that can
explain what is required for an account to be able to execute reports when
requested and validation that they have to be in the Administrative group.
The anonymous caused me confusion because I don't see where it comes into
play.
Thanks
"Chris Taylor" wrote:
> Don't use anonymous access with windows authentication......
> Kinda defeats the purpose.
> "Jim Abel" <JimAbel@.discussions.microsoft.com> wrote in message
> news:8453498E-99F8-43AA-8ADD-9005C6F2FF35@.microsoft.com...
> > To get my reports to work from the 2005 Report Manager I had to put the
> > Execution Account into the Local Administrators Group, otherwise I got a
> > Logon Failoure message when attempting to view the report. Is this how
> > it's
> > sipposed to be?
>
>

Logon Failed error in Crystal Reports

HI,

I have two tables T1 and T2 in Crystal Reports . I want to display 2 fields from T1 and 1 field from T2. I am using a dataset to populate the fields in the report. But I am getting Logon Failed error. The report displays fine when only one tables is used .
Please help me .
Thanks in advance.

AswiniDid you relate those two tables by the Keycolumn?
Do you have permission to access the tables?

Login To SQL Server Db

HI
I am using CR 8 with vb6 and sql server 2000
I am designing my reports in RDC integrated into VB IDE. I set the Login info in the dialog box which appear to add database, e.g Server = (Local),User ID=sa etc, and this is being done at design time.

My question is that as my app is going to be multiuser, so will it cause any problem on clients machine?

Should I give the login information to RDC at run time and How?

Also can I use the same connection for RDC which is being used by app to connect with the DB on SQL Server?

Waiting for help...I have the same problem. I would like to enter the logon information to the database at runtime. As of now, I`ve no clue as to how to go about.|||Any one to Help...|||ok. I found a solution. Not exactly me but Robdog. I was just pointed to his code :

http://www.vbforums.com/showpost.php?p=1775989&postcount=2|||This is no way near to what i require.
Still waiting......

Login to Reports Manager?

Hi,
I am trying to login to Report Manager (MSSQL 2005) on my server
https://www.[mydomain].com/Reports with administrator user & Pass but login
failed with error: "The request failed with HTTP status 401: Unauthorized."
Any help will be much appreciated.
Regards,
AsafHi Asaf,
Thank you for posting.
Regarding on the 401 login failed issue you mentioned in SSRS report
manager application, based on my research, there does existing some issue
related to IIS and windows server name setting. The following msdn
document has mentioned two conditions that has the similiar error
behavior:
#How to: Configure Reporting Services to Use a Non-Default Web Site
(Reporting Services Configuration)
http://msdn2.microsoft.com/en-US/library/ms155921(SQL.90).aspx
You can have a look to see whether this helps resolve the problem.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Steven,
I have reinstalled SQL Reporting Services and now it working fine.
Thanks for your support.
Regards,
Asaf
"Steven Cheng[MSFT]" wrote:
> Hi Asaf,
> Thank you for posting.
> Regarding on the 401 login failed issue you mentioned in SSRS report
> manager application, based on my research, there does existing some issue
> related to IIS and windows server name setting. The following msdn
> document has mentioned two conditions that has the similiar error
> behavior:
> #How to: Configure Reporting Services to Use a Non-Default Web Site
> (Reporting Services Configuration)
> http://msdn2.microsoft.com/en-US/library/ms155921(SQL.90).aspx
> You can have a look to see whether this helps resolve the problem.
> Regards,
> Steven Cheng
> Microsoft Online Community Support
>
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>|||That's fine Asaf,
Glad that you've got it working now.
Good luck!
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Login problems when rendering reports

This is a multi-part message in MIME format.
--=_NextPart_000_008D_01C4C8B6.1764EDB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am continually getting the following error when attempting to render = my reports from http://hostname/ReportServer...
An error has occurred during report processing. (rsProcessingAborted) = Get Online Help a.. Cannot create a connection to data source 'DataCollection'. = (rsErrorOpeningConnection) Get Online Help a.. Login failed for user '(null)'. Reason: Not associated with a = trusted SQL Server connection.
I have tried EVERY possible security setting for the DataSource = (integrated, NO Credentials, SQL authentican, etc.), and it still = doesn't work.
Here is how it's set up:
1. Reporting Services metadata location on Server A:
2. Datasource (from which I am pulling data to render reports) is on = Server B:
3. Created a user called ReportUser on BOTH the Reporting Services = server as well as the Datasource. I made sure the user has read access = in the dbs on both servers (including adding to the the RSExecRole).
4. I have designed my reports using ReportUser as the DataSource = connection.
Books online is not helping me troubleshoot this error.
Any ideas?
Thanks,
Dan
--=_NextPart_000_008D_01C4C8B6.1764EDB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I am continually getting the following = error when attempting to render my reports from
http://hostname/ReportServer...= .

An error has occurred during report = processing. (rsProcessingAborted) Get Online = Help
Cannot create a connection to data = source 'DataCollection'. (rsErrorOpeningConnection) Get = Online Help
Login failed for user '(null)'. = Reason: Not associated with a trusted SQL Server connection. =

I have tried EVERY possible security = setting for the DataSource (integrated, NO Credentials, SQL authentican, etc.), and = it still doesn't work.
Here is how it's set up:

1. Reporting Services metadata location = on Server A:
2. Datasource (from which I am pulling = data to render reports) is on Server B:
3. Created a user called ReportUser on BOTH the Reporting Services server as = well as the Datasource. I made sure the user has read access in the dbs on = both servers (including adding to the the RSExecRole).
4. I have designed my reports using = ReportUser as the DataSource connection.

Books online is not helping me = troubleshoot this error.

Any ideas?

Thanks,
Dan

--=_NextPart_000_008D_01C4C8B6.1764EDB0--This is a multi-part message in MIME format.
--=_NextPart_000_00AD_01C4C8BB.E4981C30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Okay: I finally got it to work by configuring my datasource to use ="Shared DataSource".
And then: Configuring my datasource (in ReportDesigner) to use a SQL =Authenticated login...
The security model in ReportServices is a bit tough to navigate in my =opinion.
"Dan Carollo (hotmail)" <dcarollo@.hotmail.com> wrote in message =news:eMhumkPyEHA.2764@.TK2MSFTNGP10.phx.gbl...
I am continually getting the following error when attempting to render =my reports from http://hostname/ReportServer...
An error has occurred during report processing. (rsProcessingAborted) =Get Online Help a.. Cannot create a connection to data source 'DataCollection'. =(rsErrorOpeningConnection) Get Online Help a.. Login failed for user '(null)'. Reason: Not associated with a =trusted SQL Server connection.
I have tried EVERY possible security setting for the DataSource =(integrated, NO Credentials, SQL authentican, etc.), and it still =doesn't work.
Here is how it's set up:
1. Reporting Services metadata location on Server A:
2. Datasource (from which I am pulling data to render reports) is on =Server B:
3. Created a user called ReportUser on BOTH the Reporting Services =server as well as the Datasource. I made sure the user has read access =in the dbs on both servers (including adding to the the RSExecRole).
4. I have designed my reports using ReportUser as the DataSource =connection.
Books online is not helping me troubleshoot this error.
Any ideas?
Thanks,
Dan
--=_NextPart_000_00AD_01C4C8BB.E4981C30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Okay: I finally got it to work by =configuring my datasource to use "Shared DataSource".
And then: Configuring my =datasource (in ReportDesigner) to use a SQL Authenticated login...
The security model in ReportServices is =a bit tough to navigate in my opinion.
"Dan Carollo (hotmail)" =wrote in message news:eMhumkPyEHA.2764=@.TK2MSFTNGP10.phx.gbl...
I am continually getting the =following error when attempting to render my reports from
http://hostname/ReportServer">http://hostname/ReportServer...=.

An error has occurred during report =processing. (rsProcessingAborted) Get =Online Help
Cannot create a connection to data =source 'DataCollection'. (rsErrorOpeningConnection) Get =Online Help
Login failed for user '(null)'. =Reason: Not associated with a trusted SQL Server connection. =
I have tried EVERY possible security =setting for the DataSource (integrated, NO Credentials, SQL authentican, etc.), =and it still doesn't work.
Here is how it's set up:

1. Reporting Services metadata =location on Server A:
2. Datasource (from which I am =pulling data to render reports) is on Server B:
3. Created a user called ReportUser on BOTH the Reporting Services server as =well as the Datasource. I made sure the user has read access in the dbs =on both servers (including adding to the the RSExecRole).
4. I have designed my reports using =ReportUser as the DataSource connection.

Books online is not helping me =troubleshoot this error.

Any ideas?

Thanks,
Dan

---

--=_NextPart_000_00AD_01C4C8BB.E4981C30--|||This is a multi-part message in MIME format.
--=_NextPart_000_002C_01C4CB2B.5BA97140
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Well: This is odd...
I came back into the office on Monday morning -- attempted to render =the same reports and I'm back to the same error again:
Cannot create a connection to data source 'DataCollection'. =(rsErrorOpeningConnection) Get Online Help a.. Login failed for user '(null)'. Reason: Not associated with a =trusted SQL Server connection.
"Dan Carollo (hotmail)" <dcarollo@.hotmail.com> wrote in message =news:#Ba5z7PyEHA.3844@.TK2MSFTNGP12.phx.gbl...
Okay: I finally got it to work by configuring my datasource to use ="Shared DataSource".
And then: Configuring my datasource (in ReportDesigner) to use a SQL =Authenticated login...
The security model in ReportServices is a bit tough to navigate in my =opinion.
"Dan Carollo (hotmail)" <dcarollo@.hotmail.com> wrote in message =news:eMhumkPyEHA.2764@.TK2MSFTNGP10.phx.gbl...
I am continually getting the following error when attempting to =render my reports from http://hostname/ReportServer...
An error has occurred during report processing. =(rsProcessingAborted) Get Online Help a.. Cannot create a connection to data source 'DataCollection'. =(rsErrorOpeningConnection) Get Online Help a.. Login failed for user '(null)'. Reason: Not associated with =a trusted SQL Server connection.
I have tried EVERY possible security setting for the DataSource =(integrated, NO Credentials, SQL authentican, etc.), and it still =doesn't work.
Here is how it's set up:
1. Reporting Services metadata location on Server A:
2. Datasource (from which I am pulling data to render reports) is on =Server B:
3. Created a user called ReportUser on BOTH the Reporting Services =server as well as the Datasource. I made sure the user has read access =in the dbs on both servers (including adding to the the RSExecRole).
4. I have designed my reports using ReportUser as the DataSource =connection.
Books online is not helping me troubleshoot this error.
Any ideas?
Thanks,
Dan
--=_NextPart_000_002C_01C4CB2B.5BA97140
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Well: This is =odd...
I came back into the office on Monday =morning -- attempted to render the same reports and I'm back to the same error again:
Cannot =create a connection to data source 'DataCollection'. (rsErrorOpeningConnection) =Get Online =Help
Login failed for user '(null)'. =Reason: Not associated with a trusted SQL Server connection.
"Dan Carollo (hotmail)" =wrote in message news:#Ba5z7PyEHA.3844=@.TK2MSFTNGP12.phx.gbl...
Okay: I finally got it to work =by configuring my datasource to use "Shared DataSource".
And then: Configuring my =datasource (in ReportDesigner) to use a SQL Authenticated login...

The security model in ReportServices =is a bit tough to navigate in my opinion.


"Dan Carollo (hotmail)" =wrote in message news:eMhumkPyEHA.2764=@.TK2MSFTNGP10.phx.gbl...
I am continually getting the =following error when attempting to render my reports from
http://hostname/ReportServer">http://hostname/ReportServer...=.

An error has occurred during =report processing. (rsProcessingAborted) Get =Online Help
Cannot create a connection to =data source 'DataCollection'. (rsErrorOpeningConnection) Get =Online Help
Login failed for user ='(null)'. Reason: Not associated with a trusted SQL Server connection.

I have tried EVERY possible =security setting for the DataSource (integrated, NO Credentials, SQL authentican, =etc.), and it still doesn't work.
Here is how it's set =up:

1. Reporting Services metadata =location on Server A:
2. Datasource (from which I am =pulling data to render reports) is on Server B:
3. Created a user called ReportUser on BOTH the Reporting Services server as =well as the Datasource. I made sure the user has read access in the =dbs on both servers (including adding to the the RSExecRole).
4. I have designed my reports using =ReportUser as the DataSource connection.

Books online is not helping me =troubleshoot this error.

Any ideas?

Thanks,
Dan

---

--=_NextPart_000_002C_01C4CB2B.5BA97140--

login problem with new project

I have several reports in a project that I deploy to a debug/development
environment and to production. I'm writing some different kinds of reports
so I created a new project. I've created different folders for these new
reports to go to. I updated the project configuration to point debug and
prod to the same servers but to different folders. The authentication is the
same. I use a SQL Server ID and PW stored within the report. I am admin on
both dev and prod servers.
When I try to deploy the new project reports to either environment, I get
the Reporting Services Login prompt, which I don't remember getting before.
I entered my domain user ID and PW but that did not work. I can still deploy
my old project reports with no issues. I must just be missing some sort of
project set-up step. Any ideas?
StephanieI solved it. I was using ...Reports instead of ...ReportServer in the
configuration.
Stephanie
"Stephanie" wrote:
> I have several reports in a project that I deploy to a debug/development
> environment and to production. I'm writing some different kinds of reports
> so I created a new project. I've created different folders for these new
> reports to go to. I updated the project configuration to point debug and
> prod to the same servers but to different folders. The authentication is the
> same. I use a SQL Server ID and PW stored within the report. I am admin on
> both dev and prod servers.
> When I try to deploy the new project reports to either environment, I get
> the Reporting Services Login prompt, which I don't remember getting before.
> I entered my domain user ID and PW but that did not work. I can still deploy
> my old project reports with no issues. I must just be missing some sort of
> project set-up step. Any ideas?
> Stephanie