Problem in connecting to the SQL Server

i created a dataset in asp.net and i am trying to view the page in the internet explorer and i am getting the following error

Login failed for user 'EASTERN-DFDRY3R\ASPNET'.
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.Data.SqlClient.SqlException: Login failed for user 'EASTERN-DFDRY3R\ASPNET'.

Source Error:

Line 29: {
Line 30: // Put user code to initialize the page here
Line 31: sqlDataAdapter1.Fill(dataSet11);
Line 32: DataGrid1.DataBind();
Line 33: }

Source File: c:\inetpub\wwwroot\key banking system\webform2.aspx.cs Line: 31

Stack Trace:

[SqlException: Login failed for user 'EASTERN-DFDRY3R\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
Key_Banking_system.WebForm2.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\key banking system\webform2.aspx.cs:31
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

please help me with this....and 'EASTERN-DFDRY3R\ASPNET' is a valid user for the database?|||i dont know understand ur question.|||'EASTERN-DFDRY3R\ASPNET' is the the name of '<MACHINE>\ASPNET' account. Sumas is obviously trying to connect to the DataBase using 'Trusted_Connection=True' in his connection string. To do this, he must add the ASPNET account to the DB user list, and give this account the necessary rights.

Open Enterprise mngr and find your Database, right click and choose 'New Database User'. Locate the 'EASTERN-DFDRY3R\ASPNET' account and add the account. Choose permissions and check 'db_owner'. That should do the trick.|||I'm not sure recommending db_owner is good idea, of course I NEVER do that myself <whistle> ;)

Plus if the server is on a different machine, i.e. not EASTERN_DFDRY3R (natty name by the way), then that local user won't be available. So you'll have to change the IIS/ASPNET user.

Problem exporting to PDF

Hello everybody,
I can't render a report to PDF
and I get the following error :
"Internet Explorer cannot download Format=PDF from server
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or canot be found. Please try again later."
What it's weird is that other reports rendered to PDF, but this one!
Thanks for your help.
DomenicoWhat error do you see in the log file in your /ReportServer/LogFiles
directory? There should be a stack trace in there that you can will give us
more information.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riddick" <Riddick@.discussions.microsoft.com> wrote in message
news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> Hello everybody,
> I can't render a report to PDF
> and I get the following error :
> "Internet Explorer cannot download Format=PDF from server
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or canot be found. Please try again later."
> What it's weird is that other reports rendered to PDF, but this one!
> Thanks for your help.
> Domenico
>|||I thank you for your help.
Domenico
here below the stack trace of the error :
aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting Services
error
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.ArgumentOutOfRangeException: Index and length must refer
to a location within the string.
Parameter name: length
at System.String.Substring(Int32 startIndex, Int32 length)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left,
Double top, Double paddingTop, Double width, Double height, Boolean wordTrim,
String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String&
streamString)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
context, OutlineObjects outlines, Boolean wordTrim, String text, CanvasFont
font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effecectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
"Donovan Smith [MSFT]" wrote:
> What error do you see in the log file in your /ReportServer/LogFiles
> directory? There should be a stack trace in there that you can will give us
> more information.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> > Hello everybody,
> > I can't render a report to PDF
> > and I get the following error :
> >
> > "Internet Explorer cannot download Format=PDF from server
> > Internet Explorer was not able to open this Internet site. The requested
> > site is either unavailable or canot be found. Please try again later."
> >
> > What it's weird is that other reports rendered to PDF, but this one!
> >
> > Thanks for your help.
> > Domenico
> >
> >
>
>|||Please email me a copy of your .rdl and .rdl.data file. I'm curious why
you're hitting that.
Thank you.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riddick" <Riddick@.discussions.microsoft.com> wrote in message
news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
> I thank you for your help.
> Domenico
> here below the stack trace of the error :
> aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting Services
> error
> Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. -->
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. --> System.ArgumentOutOfRangeException: Index and length must
> refer
> to a location within the string.
> Parameter name: length
> at System.String.Substring(Int32 startIndex, Int32 length)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
> context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left,
> Double top, Double paddingTop, Double width, Double height, Boolean
> wordTrim,
> String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String&
> streamString)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
> context, OutlineObjects outlines, Boolean wordTrim, String text,
> CanvasFont
> font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
> width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> parentClipBorder)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
> Int32 endPage, Boolean render)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> evaluateHeaderFooterExpressions, CreateAndRegisterStream
> createAndRegisterStreamCallback)
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> report, NameValueCollection reportServerParameters, NameValueCollection
> deviceInfo, NameValueCollection clientCapabilities,
> EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> CreateAndRegisterStream createAndRegisterStream)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> reportContext, ClientRequest session, RenderingResult& result)
> at
> Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> at
> Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effecectiveParameters, String[]&
> secondaryStreamNames)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>
> "Donovan Smith [MSFT]" wrote:
>> What error do you see in the log file in your /ReportServer/LogFiles
>> directory? There should be a stack trace in there that you can will give
>> us
>> more information.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
>> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
>> > Hello everybody,
>> > I can't render a report to PDF
>> > and I get the following error :
>> >
>> > "Internet Explorer cannot download Format=PDF from server
>> > Internet Explorer was not able to open this Internet site. The
>> > requested
>> > site is either unavailable or canot be found. Please try again later."
>> >
>> > What it's weird is that other reports rendered to PDF, but this one!
>> >
>> > Thanks for your help.
>> > Domenico
>> >
>> >
>>|||I'm sorry but I had been waiting for your answer for some days. Then I
decided to design again the same report from scratch and this time were not
problem.
Thank you
"Donovan Smith [MSFT]" wrote:
> Please email me a copy of your .rdl and .rdl.data file. I'm curious why
> you're hitting that.
> Thank you.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
> >
> > I thank you for your help.
> > Domenico
> >
> > here below the stack trace of the error :
> >
> > aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting Services
> > error
> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. -->
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> > Exception of type
> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> > thrown. --> System.ArgumentOutOfRangeException: Index and length must
> > refer
> > to a location within the string.
> >
> > Parameter name: length
> >
> > at System.String.Substring(Int32 startIndex, Int32 length)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
> > context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double left,
> > Double top, Double paddingTop, Double width, Double height, Boolean
> > wordTrim,
> > String fontLanguage, Int32& charactersFitted, Int32& linesFilled, String&
> > streamString)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
> > context, OutlineObjects outlines, Boolean wordTrim, String text,
> > CanvasFont
> > font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
> > width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> > parentClipBorder)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> > theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
> > Int32 endPage, Boolean render)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> > report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> > evaluateHeaderFooterExpressions, CreateAndRegisterStream
> > createAndRegisterStreamCallback)
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> > report, NameValueCollection reportServerParameters, NameValueCollection
> > deviceInfo, NameValueCollection clientCapabilities,
> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> > CreateAndRegisterStream createAndRegisterStream)
> >
> > -- End of inner exception stack trace --
> >
> > at
> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> > report, NameValueCollection reportServerParameters, NameValueCollection
> > deviceInfo, NameValueCollection clientCapabilities,
> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> > CreateAndRegisterStream createAndRegisterStream)
> >
> > at
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> >
> > -- End of inner exception stack trace --
> >
> > at
> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> > createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
> >
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> > reportContext, ClientRequest session, RenderingResult& result)
> >
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effectiveParameters)
> >
> > at
> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> > reportContext, ClientRequest session, Warning[]& warnings,
> > ParameterInfoCollection& effecectiveParameters, String[]&
> > secondaryStreamNames)
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> > streamFactory)
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> > itemType)
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> >
> > at
> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >
> >
> >
> > "Donovan Smith [MSFT]" wrote:
> >
> >> What error do you see in the log file in your /ReportServer/LogFiles
> >> directory? There should be a stack trace in there that you can will give
> >> us
> >> more information.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> >> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> >> > Hello everybody,
> >> > I can't render a report to PDF
> >> > and I get the following error :
> >> >
> >> > "Internet Explorer cannot download Format=PDF from server
> >> > Internet Explorer was not able to open this Internet site. The
> >> > requested
> >> > site is either unavailable or canot be found. Please try again later."
> >> >
> >> > What it's weird is that other reports rendered to PDF, but this one!
> >> >
> >> > Thanks for your help.
> >> > Domenico
> >> >
> >> >
> >>
> >>
> >>
>
>|||Odd. :) Well, if you encounter it again, please send me those files so I
can take a look.
Thanks.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Riddick" <Riddick@.discussions.microsoft.com> wrote in message
news:C15ABB0A-7178-4ACD-BF85-5A47C1FC6EED@.microsoft.com...
> I'm sorry but I had been waiting for your answer for some days. Then I
> decided to design again the same report from scratch and this time were
> not
> problem.
> Thank you
>
> "Donovan Smith [MSFT]" wrote:
>> Please email me a copy of your .rdl and .rdl.data file. I'm curious why
>> you're hitting that.
>> Thank you.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
>> news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
>> >
>> > I thank you for your help.
>> > Domenico
>> >
>> > here below the stack trace of the error :
>> >
>> > aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting
>> > Services
>> > error
>> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. -->
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
>> > Exception of type
>> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
>> > was
>> > thrown. --> System.ArgumentOutOfRangeException: Index and length must
>> > refer
>> > to a location within the string.
>> >
>> > Parameter name: length
>> >
>> > at System.String.Substring(Int32 startIndex, Int32 length)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
>> > context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double
>> > left,
>> > Double top, Double paddingTop, Double width, Double height, Boolean
>> > wordTrim,
>> > String fontLanguage, Int32& charactersFitted, Int32& linesFilled,
>> > String&
>> > streamString)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
>> > context, OutlineObjects outlines, Boolean wordTrim, String text,
>> > CanvasFont
>> > font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
>> > width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
>> > parentClipBorder)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
>> > theComposition, Report theReport, Boolean needTotalPages, Int32
>> > startPage,
>> > Int32 endPage, Boolean render)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
>> > report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
>> > evaluateHeaderFooterExpressions, CreateAndRegisterStream
>> > createAndRegisterStreamCallback)
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> > report, NameValueCollection reportServerParameters, NameValueCollection
>> > deviceInfo, NameValueCollection clientCapabilities,
>> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> > CreateAndRegisterStream createAndRegisterStream)
>> >
>> > -- End of inner exception stack trace --
>> >
>> > at
>> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
>> > report, NameValueCollection reportServerParameters, NameValueCollection
>> > deviceInfo, NameValueCollection clientCapabilities,
>> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
>> > CreateAndRegisterStream createAndRegisterStream)
>> >
>> > at
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> >
>> > -- End of inner exception stack trace --
>> >
>> > at
>> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
>> > createChunkCallback, RenderingContext rc, GetResource
>> > getResourceCallback)
>> >
>> > at
>> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
>> > reportContext, ClientRequest session, RenderingResult& result)
>> >
>> > at
>> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
>> > reportContext, ClientRequest session, Warning[]& warnings,
>> > ParameterInfoCollection& effectiveParameters)
>> >
>> > at
>> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
>> > reportContext, ClientRequest session, Warning[]& warnings,
>> > ParameterInfoCollection& effecectiveParameters, String[]&
>> > secondaryStreamNames)
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
>> > streamFactory)
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
>> > itemType)
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
>> >
>> > at
>> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>> >
>> >
>> >
>> > "Donovan Smith [MSFT]" wrote:
>> >
>> >> What error do you see in the log file in your /ReportServer/LogFiles
>> >> directory? There should be a stack trace in there that you can will
>> >> give
>> >> us
>> >> more information.
>> >>
>> >> --
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
>> >> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
>> >> > Hello everybody,
>> >> > I can't render a report to PDF
>> >> > and I get the following error :
>> >> >
>> >> > "Internet Explorer cannot download Format=PDF from server
>> >> > Internet Explorer was not able to open this Internet site. The
>> >> > requested
>> >> > site is either unavailable or canot be found. Please try again
>> >> > later."
>> >> >
>> >> > What it's weird is that other reports rendered to PDF, but this one!
>> >> >
>> >> > Thanks for your help.
>> >> > Domenico
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||You bet ! :)
Thanks.
"Donovan Smith [MSFT]" wrote:
> Odd. :) Well, if you encounter it again, please send me those files so I
> can take a look.
> Thanks.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> news:C15ABB0A-7178-4ACD-BF85-5A47C1FC6EED@.microsoft.com...
> >
> > I'm sorry but I had been waiting for your answer for some days. Then I
> > decided to design again the same report from scratch and this time were
> > not
> > problem.
> >
> > Thank you
> >
> >
> > "Donovan Smith [MSFT]" wrote:
> >
> >> Please email me a copy of your .rdl and .rdl.data file. I'm curious why
> >> you're hitting that.
> >>
> >> Thank you.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> >> news:9D929115-2AD2-4570-ADDD-6CA362787AB6@.microsoft.com...
> >> >
> >> > I thank you for your help.
> >> > Domenico
> >> >
> >> > here below the stack trace of the error :
> >> >
> >> > aspnet_wp!webserver!11c!04/22/2005-08:27:11:: e ERROR: Reporting
> >> > Services
> >> > error
> >> > Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
> >> > Exception of type
> >> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> >> > was
> >> > thrown. -->
> >> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
> >> > Exception of type
> >> > Microsoft.ReportingServices.ReportRendering.ReportRenderingException
> >> > was
> >> > thrown. --> System.ArgumentOutOfRangeException: Index and length must
> >> > refer
> >> > to a location within the string.
> >> >
> >> > Parameter name: length
> >> >
> >> > at System.String.Substring(Int32 startIndex, Int32 length)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessString(TextBox
> >> > context, String text, CanvasFontPDF font, CanvasPenPDF pen, Double
> >> > left,
> >> > Double top, Double paddingTop, Double width, Double height, Boolean
> >> > wordTrim,
> >> > String fontLanguage, Int32& charactersFitted, Int32& linesFilled,
> >> > String&
> >> > streamString)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawString(TextBox
> >> > context, OutlineObjects outlines, Boolean wordTrim, String text,
> >> > CanvasFont
> >> > font, CanvasPen pen, Double left, Double top, Double paddingTop, Double
> >> > width, Double height, String fontLanguage, ReportUrl hyperLinkURL)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableCell.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.TableRow.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.Table.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.Rectangle.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement
> >> > parentClipBorder)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
> >> > theComposition, Report theReport, Boolean needTotalPages, Int32
> >> > startPage,
> >> > Int32 endPage, Boolean render)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport.RenderReport(Report
> >> > report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
> >> > evaluateHeaderFooterExpressions, CreateAndRegisterStream
> >> > createAndRegisterStreamCallback)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> >> > report, NameValueCollection reportServerParameters, NameValueCollection
> >> > deviceInfo, NameValueCollection clientCapabilities,
> >> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> >> > CreateAndRegisterStream createAndRegisterStream)
> >> >
> >> > -- End of inner exception stack trace --
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
> >> > report, NameValueCollection reportServerParameters, NameValueCollection
> >> > deviceInfo, NameValueCollection clientCapabilities,
> >> > EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
> >> > CreateAndRegisterStream createAndRegisterStream)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> >> > createChunkCallback, RenderingContext rc, GetResource
> >> > getResourceCallback)
> >> >
> >> > -- End of inner exception stack trace --
> >> >
> >> > at
> >> > Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk
> >> > createChunkCallback, RenderingContext rc, GetResource
> >> > getResourceCallback)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext
> >> > reportContext, ClientRequest session, RenderingResult& result)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext
> >> > reportContext, ClientRequest session, Warning[]& warnings,
> >> > ParameterInfoCollection& effectiveParameters)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext
> >> > reportContext, ClientRequest session, Warning[]& warnings,
> >> > ParameterInfoCollection& effecectiveParameters, String[]&
> >> > secondaryStreamNames)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> >> > streamFactory)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> >> > itemType)
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> >> >
> >> > at
> >> > Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> >> >
> >> >
> >> >
> >> > "Donovan Smith [MSFT]" wrote:
> >> >
> >> >> What error do you see in the log file in your /ReportServer/LogFiles
> >> >> directory? There should be a stack trace in there that you can will
> >> >> give
> >> >> us
> >> >> more information.
> >> >>
> >> >> --
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Riddick" <Riddick@.discussions.microsoft.com> wrote in message
> >> >> news:34B670EF-FB0D-4B31-9422-32DEDD7EB5B3@.microsoft.com...
> >> >> > Hello everybody,
> >> >> > I can't render a report to PDF
> >> >> > and I get the following error :
> >> >> >
> >> >> > "Internet Explorer cannot download Format=PDF from server
> >> >> > Internet Explorer was not able to open this Internet site. The
> >> >> > requested
> >> >> > site is either unavailable or canot be found. Please try again
> >> >> > later."
> >> >> >
> >> >> > What it's weird is that other reports rendered to PDF, but this one!
> >> >> >
> >> >> > Thanks for your help.
> >> >> > Domenico
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Problem connecting to SQL Server over the internet

I have opened ports 1433 and 1434 on a SQL Server on our network to allow
our customers to receive a monthly subscription "key" for the software they
lease from us. Within an encrypted Stored Procedure I am using the
OPENDATASOURCE method with a connect string containing our IP address. It is
working on 90% of the sites. However some of the sites are receiving an
error:
Server: Msg 17, Level 16, State 1, Procedure PLSPSYS_ALTER_KEYSP_REMOTE,
Line 37
SQL Server does not exist or access denied.
On most of the servers where the procedure is WORKING, a peek at the
firewall configuration using Shields-Up service from Gibson Research shows
that ports 1433 and 1434 are in Stealth mode. But, as I said, the connection
is still operating just fine. All sites, including the ones that don't work,
have the TCP/IP protocol enabled in the Client Network Utility on Port 1433.
So I am at a loss to figure out why the Internet connection is not working
at some sites. Any ideas?
Also, is there another way that I can distribute the "key" without user
intervention using "back-end" programs or procedures? Is there a way to
connect and retieve data via port 80 which is usually left open for outbound
requests? Thanks in advance...
I would make network traces at the problem site and either review the
firewall logs or
make simulataneous traces on the server. This sounds like a tcp issue not
a SQL issue.
Verify that the 3 way tcp handshake is completing. The login packet isn't
sent until this completes.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Thank you both for your replies. I will make sure that the TCP issues are
resolved at the client sites before looking any further.
"John Kotuby" <jkotuby@.snet.net> wrote in message
news:undiWF%23TEHA.2028@.TK2MSFTNGP11.phx.gbl...
> I have opened ports 1433 and 1434 on a SQL Server on our network to allow
> our customers to receive a monthly subscription "key" for the software
they
> lease from us. Within an encrypted Stored Procedure I am using the
> OPENDATASOURCE method with a connect string containing our IP address. It
is
> working on 90% of the sites. However some of the sites are receiving an
> error:
> Server: Msg 17, Level 16, State 1, Procedure PLSPSYS_ALTER_KEYSP_REMOTE,
> Line 37
> SQL Server does not exist or access denied.
> On most of the servers where the procedure is WORKING, a peek at the
> firewall configuration using Shields-Up service from Gibson Research shows
> that ports 1433 and 1434 are in Stealth mode. But, as I said, the
connection
> is still operating just fine. All sites, including the ones that don't
work,
> have the TCP/IP protocol enabled in the Client Network Utility on Port
1433.
> So I am at a loss to figure out why the Internet connection is not working
> at some sites. Any ideas?
> Also, is there another way that I can distribute the "key" without user
> intervention using "back-end" programs or procedures? Is there a way to
> connect and retieve data via port 80 which is usually left open for
outbound
> requests? Thanks in advance...
>

Problem connecting to SQL Server over the internet

I have opened ports 1433 and 1434 on a SQL Server on our network to allow
our customers to receive a monthly subscription "key" for the software they
lease from us. Within an encrypted Stored Procedure I am using the
OPENDATASOURCE method with a connect string containing our IP address. It is
working on 90% of the sites. However some of the sites are receiving an
error:
Server: Msg 17, Level 16, State 1, Procedure PLSPSYS_ALTER_KEYSP_REMOTE,
Line 37
SQL Server does not exist or access denied.
On most of the servers where the procedure is WORKING, a peek at the
firewall configuration using Shields-Up service from Gibson Research shows
that ports 1433 and 1434 are in Stealth mode. But, as I said, the connection
is still operating just fine. All sites, including the ones that don't work,
have the TCP/IP protocol enabled in the Client Network Utility on Port 1433.
So I am at a loss to figure out why the Internet connection is not working
at some sites. Any ideas?
Also, is there another way that I can distribute the "key" without user
intervention using "back-end" programs or procedures? Is there a way to
connect and retieve data via port 80 which is usually left open for outbound
requests? Thanks in advance...I would make network traces at the problem site and either review the
firewall logs or
make simulataneous traces on the server. This sounds like a tcp issue not
a SQL issue.
Verify that the 3 way tcp handshake is completing. The login packet isn't
sent until this completes.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you both for your replies. I will make sure that the TCP issues are
resolved at the client sites before looking any further.
"John Kotuby" <jkotuby@.snet.net> wrote in message
news:undiWF%23TEHA.2028@.TK2MSFTNGP11.phx.gbl...
> I have opened ports 1433 and 1434 on a SQL Server on our network to allow
> our customers to receive a monthly subscription "key" for the software
they
> lease from us. Within an encrypted Stored Procedure I am using the
> OPENDATASOURCE method with a connect string containing our IP address. It
is
> working on 90% of the sites. However some of the sites are receiving an
> error:
> Server: Msg 17, Level 16, State 1, Procedure PLSPSYS_ALTER_KEYSP_REMOTE,
> Line 37
> SQL Server does not exist or access denied.
> On most of the servers where the procedure is WORKING, a peek at the
> firewall configuration using Shields-Up service from Gibson Research shows
> that ports 1433 and 1434 are in Stealth mode. But, as I said, the
connection
> is still operating just fine. All sites, including the ones that don't
work,
> have the TCP/IP protocol enabled in the Client Network Utility on Port
1433.
> So I am at a loss to figure out why the Internet connection is not working
> at some sites. Any ideas?
> Also, is there another way that I can distribute the "key" without user
> intervention using "back-end" programs or procedures? Is there a way to
> connect and retieve data via port 80 which is usually left open for
outbound
> requests? Thanks in advance...
>