Passing result sets: successfully

Showing posts with label successfully. Show all posts

Wednesday, March 28, 2012

PDF rendering bug in SP2

We just upgraded to SP2 and some reports now fail to render in PDF format. They render successfully as HTML within IE, but exporting to PDF gives the following error:

An error occurred during rendering of the report. (rrRenderingError)

An error occurred during rendering of the report.

Non-negative number required. Parameter name: value

The log gives the following traceback:

at Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String& extension, String& mimeType, String& encoding, String[]& streams, Warning[]& warnings)
at Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& extension)
at Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension)
at Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
aspnet_wp!library!6!17/04/2007-10:27:17:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
aspnet_wp!library!5!17/04/2007-10:28:09:: i INFO: Call to RenderNext( '/EFaultReports/FaultReport' )
aspnet_wp!cache!5!17/04/2007-10:28:09:: i INFO: Session live: /EFaultReports/FaultReport
aspnet_wp!library!5!17/04/2007-10:28:23:: i INFO: Call to RenderNext( '/EFaultReports/FaultReport' )
aspnet_wp!reportrendering!5!17/04/2007-10:28:23:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report., ;
Info: Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException: An error occurred during rendering of the report. > Microsoft.ReportingServices.ReportRendering.ReportRenderingException: An error occurred during rendering of the report. > System.ArgumentOutOfRangeException: Non-negative number required.
Parameter name: value
at System.IO.MemoryStream.set_Position(Int64 value)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.MonochromeJpeg(MemoryStream memStream)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.ProcessImage(CanvasImagePDF image, Double left, Double top, Double width, Double height, Boolean scaleImage)
at Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasPDF.DrawImage(OutlineObjects outlines, CanvasImage image, Double left, Double top, Double width, Double height)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Image.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.TableCell.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.RenderToPage(Measurement parentClipBorder)
at Microsoft.ReportingServices.Rendering.ImageRenderer.Table.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, Int32 streamPageNumber)
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(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
End of inner exception stack trace
aspnet_wp!library!5!17/04/2007-10:28:23:: Unhandled exception was caught: Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. (rrRenderingError) > Microsoft.Reporting.WebForms.ReportServerException: An error occurred during rendering of the report. > Microsoft.Reporting.WebForms.ReportServerException: Non-negative number required.
Parameter name: value
End of inner exception stack trace
End of inner exception stack trace

We have got same problem and I have found that it happens with reports containing *.pjpeg images. Not all *.pjpeg gives this problem.

Please reply if anyone knows the fix. it is urgent

Thanks

Satjinder

sql

PDF rendering bug in SP2

We just upgraded to SP2 and some reports now fail to render in PDF format. They render successfully as HTML within IE, but exporting to PDF gives the following error:

An error occurred during rendering of the report. (rrRenderingError)

An error occurred during rendering of the report.

Non-negative number required. Parameter name: value

The log gives the following traceback:

We have got same problem and I have found that it happens with reports containing *.pjpeg images. Not all *.pjpeg gives this problem.

Please reply if anyone knows the fix. it is urgent

Thanks

Satjinder

Wednesday, March 21, 2012

Pausing-Restarting SQL Server Service

Hi,
When I use NET PAUSE in cmd mode, the service pauses successfully but when I
issue NET START again, the service stays in pause state unless I use service
manager to start it.
Any help would be greatly appreciated,
LeilaYou need to use NET CONTINUE
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When I use NET PAUSE in cmd mode, the service pauses successfully but when
> I
> issue NET START again, the service stays in pause state unless I use
> service
> manager to start it.
> Any help would be greatly appreciated,
> Leila
>|||Thanks indeed!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#Jdojl8AGHA.360@.TK2MSFTNGP09.phx.gbl...
> You need to use NET CONTINUE
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
when[vbcol=seagreen]
>|||
>Hi,
>When I use NET PAUSE in cmd mode, the service pauses successfully but when
I
>issue NET START again, the service stays in pause state unless I use servic
e
>manager to start it.
>Any help would be greatly appreciated,
>Leila
>
>
You need to use NET CONTINUE. NET START won't do anything - it's already
started.
Cheers -
Simon

Pausing-Restarting SQL Server Service

Hi,
When I use NET PAUSE in cmd mode, the service pauses successfully but when I
issue NET START again, the service stays in pause state unless I use service
manager to start it.
Any help would be greatly appreciated,
LeilaYou need to use NET CONTINUE
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When I use NET PAUSE in cmd mode, the service pauses successfully but when
> I
> issue NET START again, the service stays in pause state unless I use
> service
> manager to start it.
> Any help would be greatly appreciated,
> Leila
>|||Thanks indeed!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#Jdojl8AGHA.360@.TK2MSFTNGP09.phx.gbl...
> You need to use NET CONTINUE
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > When I use NET PAUSE in cmd mode, the service pauses successfully but
when
> > I
> > issue NET START again, the service stays in pause state unless I use
> > service
> > manager to start it.
> > Any help would be greatly appreciated,
> > Leila
> >
> >
>|||>Hi,
>When I use NET PAUSE in cmd mode, the service pauses successfully but when I
>issue NET START again, the service stays in pause state unless I use service
>manager to start it.
>Any help would be greatly appreciated,
>Leila
>
>
You need to use NET CONTINUE. NET START won't do anything - it's already
started.
Cheers -
Simon

Pausing-Restarting SQL Server Service

Hi,
When I use NET PAUSE in cmd mode, the service pauses successfully but when I
issue NET START again, the service stays in pause state unless I use service
manager to start it.
Any help would be greatly appreciated,
Leila
You need to use NET CONTINUE
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When I use NET PAUSE in cmd mode, the service pauses successfully but when
> I
> issue NET START again, the service stays in pause state unless I use
> service
> manager to start it.
> Any help would be greatly appreciated,
> Leila
>
|||Thanks indeed!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#Jdojl8AGHA.360@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> You need to use NET CONTINUE
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
when
>
|||
>Hi,
>When I use NET PAUSE in cmd mode, the service pauses successfully but when I
>issue NET START again, the service stays in pause state unless I use service
>manager to start it.
>Any help would be greatly appreciated,
>Leila
>
>
You need to use NET CONTINUE. NET START won't do anything - it's already
started.
Cheers -
Simon
sql

Pausing-Restarting SQL Server Service

Hi,
When I use NET PAUSE in cmd mode, the service pauses successfully but when I
issue NET START again, the service stays in pause state unless I use service
manager to start it.
Any help would be greatly appreciated,
LeilaYou need to use NET CONTINUE
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
> Hi,
> When I use NET PAUSE in cmd mode, the service pauses successfully but when
> I
> issue NET START again, the service stays in pause state unless I use
> service
> manager to start it.
> Any help would be greatly appreciated,
> Leila
>|||Thanks indeed!
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:#Jdojl8AGHA.360@.TK2MSFTNGP09.phx.gbl...
> You need to use NET CONTINUE
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23eb9TK6AGHA.984@.TK2MSFTNGP12.phx.gbl...
when
>|||
>Hi,
>When I use NET PAUSE in cmd mode, the service pauses successfully but when
I
>issue NET START again, the service stays in pause state unless I use servic
e
>manager to start it.
>Any help would be greatly appreciated,
>Leila
>
>
You need to use NET CONTINUE. NET START won't do anything - it's already
started.
Cheers -
Simon

Tuesday, March 20, 2012

Path to Server Report?

Hi,
I have created a report with the report designer and deployed it
successfully to my http://localhost/Reports. I can browse and see my report
in Internet Explorer with the URL:
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSalesByFiscalYears
Now if I try to open this report in my reportviewer control in a win
application (VS.NET 2005 RC1) I get "Request failed bla bla... Status 404:
Not Found". My settings (which I set in design time) for the reportviewer is:
ReportPath=/reportproject/frptSalesByFiscalYears
ReportServerURL=http://localhost/Reports
I use SQL Server 2005 september release.
Is there anything I am missing here?
Thanks
ThomasHi Thomas,
I'm thinking you have a permissions problem. When you set up the reporting
server, you probably set up the manager to run under a local system account,
and when you are accessing it from code, you are running under your domain
account.
Go into the report manager home page and go to into properties and make sure
you (your domain account) are added as a user that can access and run
reports.
Also make sure you, as a domain user, not in report manager, have rights to
the directory where the report is stored.
I hope that helps!
Chris
"Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
news:EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com...
> Hi,
> I have created a report with the report designer and deployed it
> successfully to my http://localhost/Reports. I can browse and see my
> report
> in Internet Explorer with the URL:
> http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSalesByFiscalYears
> Now if I try to open this report in my reportviewer control in a win
> application (VS.NET 2005 RC1) I get "Request failed bla bla... Status
> 404:
> Not Found". My settings (which I set in design time) for the reportviewer
> is:
> ReportPath=/reportproject/frptSalesByFiscalYears
> ReportServerURL=http://localhost/Reports
> I use SQL Server 2005 september release.
> Is there anything I am missing here?
> Thanks
> Thomas|||Hi Chris,
I added my domain user in the report manager.
> Also make sure you, as a domain user, not in report manager, have rights to
> the directory where the report is stored.
> I hope that helps!
"Where the report is stored"? You mean my visual studio project directory?
My domain user is local admin so I guess I must have full rights for the
directory.
I still get the same error - 404 Not Found.
Any more ideas?
Kind regards
Thomas
"Chris Hastings" wrote:
> Hi Thomas,
> I'm thinking you have a permissions problem. When you set up the reporting
> server, you probably set up the manager to run under a local system account,
> and when you are accessing it from code, you are running under your domain
> account.
> Go into the report manager home page and go to into properties and make sure
> you (your domain account) are added as a user that can access and run
> reports.
> Also make sure you, as a domain user, not in report manager, have rights to
> the directory where the report is stored.
> I hope that helps!
> Chris
> "Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
> news:EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com...
> > Hi,
> >
> > I have created a report with the report designer and deployed it
> > successfully to my http://localhost/Reports. I can browse and see my
> > report
> > in Internet Explorer with the URL:
> > http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSalesByFiscalYears
> >
> > Now if I try to open this report in my reportviewer control in a win
> > application (VS.NET 2005 RC1) I get "Request failed bla bla... Status
> > 404:
> > Not Found". My settings (which I set in design time) for the reportviewer
> > is:
> > ReportPath=/reportproject/frptSalesByFiscalYears
> > ReportServerURL=http://localhost/Reports
> >
> > I use SQL Server 2005 september release.
> >
> > Is there anything I am missing here?
> > Thanks
> > Thomas
>
>|||Hi Thomas,
I apologize, I should have paid more attention, you would get a 401 error if
you didn't have rights.
I have not used the report control in vs2005 so I can't be of much help.
A few things I would try, if you haven't already...
You could try to change the URL to
http://localhost/reports/pages/reports.aspx
Remove the / from the beginning of the report path.
Not sure what effect either of those will have
other than that, I've got nothing...
Chris
"Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
news:6D768C99-9AAF-41CA-8B2E-061C4673C4CE@.microsoft.com...
> Hi Chris,
> I added my domain user in the report manager.
>> Also make sure you, as a domain user, not in report manager, have rights
>> to
>> the directory where the report is stored.
>> I hope that helps!
> "Where the report is stored"? You mean my visual studio project directory?
> My domain user is local admin so I guess I must have full rights for the
> directory.
> I still get the same error - 404 Not Found.
> Any more ideas?
> Kind regards
> Thomas
> "Chris Hastings" wrote:
>> Hi Thomas,
>> I'm thinking you have a permissions problem. When you set up the
>> reporting
>> server, you probably set up the manager to run under a local system
>> account,
>> and when you are accessing it from code, you are running under your
>> domain
>> account.
>> Go into the report manager home page and go to into properties and make
>> sure
>> you (your domain account) are added as a user that can access and run
>> reports.
>> Also make sure you, as a domain user, not in report manager, have rights
>> to
>> the directory where the report is stored.
>> I hope that helps!
>> Chris
>> "Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
>> news:EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com...
>> > Hi,
>> >
>> > I have created a report with the report designer and deployed it
>> > successfully to my http://localhost/Reports. I can browse and see my
>> > report
>> > in Internet Explorer with the URL:
>> > http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSalesByFiscalYears
>> >
>> > Now if I try to open this report in my reportviewer control in a win
>> > application (VS.NET 2005 RC1) I get "Request failed bla bla... Status
>> > 404:
>> > Not Found". My settings (which I set in design time) for the
>> > reportviewer
>> > is:
>> > ReportPath=/reportproject/frptSalesByFiscalYears
>> > ReportServerURL=http://localhost/Reports
>> >
>> > I use SQL Server 2005 september release.
>> >
>> > Is there anything I am missing here?
>> > Thanks
>> > Thomas
>>|||Hello Thomas,
Based on my experience, this issue usually occurs when reportpath or
reportserverurl is not set correctly.
reportserverurl shall be configured to
ReportServerURL=http://localhost/Reportserver
You configured to report manager URL which is not correct.
Hope this is helpful.
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.
--
| NNTP-Posting-Date: Wed, 02 Nov 2005 14:33:16 -0600
| From: "Chris Hastings" <chrshstngs@.comcast.net>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| References: <EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com>
<Qe6dnQvBwb1MlPTeRVn-uA@.comcast.com>
<6D768C99-9AAF-41CA-8B2E-061C4673C4CE@.microsoft.com>
| Subject: Re: Path to Server Report?
| Date: Wed, 2 Nov 2005 14:33:23 -0600
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <J6udnUJ5E5QRv_TeRVn-rw@.comcast.com>
| Lines: 83
| NNTP-Posting-Host: 24.245.14.181
| X-Trace:
sv3-ep9KVa+bnR1eNiBRahlXfqV+hbAYwe2Jiqg18L54I7k/OgepIYapxZIyj4Ce04mb5tF+CbVt
5o9zkru!fvMc03S2mqFhzWUae09DI18YFTUwBmEmfxySRFwMDAwKEf+n8nWLbxftvxSkhxineDt6
WRKz2LYH!My8=| X-Complaints-To: abuse@.comcast.net
| X-DMCA-Complaints-To: dmca@.comcast.net
| X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
| X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
| X-Postfilter: 1.3.32
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!local01.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POST
ED!not-for-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:55604
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi Thomas,
| I apologize, I should have paid more attention, you would get a 401 error
if
| you didn't have rights.
| I have not used the report control in vs2005 so I can't be of much help.
| A few things I would try, if you haven't already...
| You could try to change the URL to
| http://localhost/reports/pages/reports.aspx
| Remove the / from the beginning of the report path.
| Not sure what effect either of those will have
| other than that, I've got nothing...
| Chris
|
| "Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in message
| news:6D768C99-9AAF-41CA-8B2E-061C4673C4CE@.microsoft.com...
| > Hi Chris,
| >
| > I added my domain user in the report manager.
| >
| >> Also make sure you, as a domain user, not in report manager, have
rights
| >> to
| >> the directory where the report is stored.
| >> I hope that helps!
| >
| > "Where the report is stored"? You mean my visual studio project
directory?
| > My domain user is local admin so I guess I must have full rights for the
| > directory.
| >
| > I still get the same error - 404 Not Found.
| >
| > Any more ideas?
| >
| > Kind regards
| > Thomas
| >
| > "Chris Hastings" wrote:
| >
| >> Hi Thomas,
| >> I'm thinking you have a permissions problem. When you set up the
| >> reporting
| >> server, you probably set up the manager to run under a local system
| >> account,
| >> and when you are accessing it from code, you are running under your
| >> domain
| >> account.
| >> Go into the report manager home page and go to into properties and
make
| >> sure
| >> you (your domain account) are added as a user that can access and run
| >> reports.
| >> Also make sure you, as a domain user, not in report manager, have
rights
| >> to
| >> the directory where the report is stored.
| >> I hope that helps!
| >> Chris
| >>
| >> "Thomas Andersson" <1qa2ws3ed4rf5tg6yh@.newsgroup.nospam> wrote in
message
| >> news:EBFBA9D1-42F3-4A2C-8169-4A3A76CA8E2E@.microsoft.com...
| >> > Hi,
| >> >
| >> > I have created a report with the report designer and deployed it
| >> > successfully to my http://localhost/Reports. I can browse and see my
| >> > report
| >> > in Internet Explorer with the URL:
| >> >
http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fReportProject%2frptSa
lesByFiscalYears
| >> >
| >> > Now if I try to open this report in my reportviewer control in a win
| >> > application (VS.NET 2005 RC1) I get "Request failed bla bla...
Status
| >> > 404:
| >> > Not Found". My settings (which I set in design time) for the
| >> > reportviewer
| >> > is:
| >> > ReportPath=/reportproject/frptSalesByFiscalYears
| >> > ReportServerURL=http://localhost/Reports
| >> >
| >> > I use SQL Server 2005 september release.
| >> >
| >> > Is there anything I am missing here?
| >> > Thanks
| >> > Thomas
| >>
| >>
| >>
|
|
|

Monday, March 12, 2012

password synchronization - newbie question

We are using SQL Server authentication in a new W2k system that is replacing
a legacy UNIX system. I have a script that successfully recreates the user
accounts, but of course I have to default the password. Our security folks w
ill never agree to such a s
cheme, especially since I have read on this newsgroup that there is no way t
o force the users to change their passwords the first time they log on. Is t
here any way to port the users' UNIX passwords to SQL Server 2000? I can cap
ture the encrypted UNIX pas
swords, and was hoping there was a way to use them to populate the "password
" field of the master.sysxlogins table. Is the encryption used for UNIX in
any way compatible or "translate-able" to the encryption used by SQL Server?
This would probably be much easier if we were using Windows authentication,
but for our particular implementation, we have some other compelling reasons
not to.No the encryption algorithm is not going to be the same as any Unix based
system.
I would think that if you're writing a custom application you could force
the users to execute sp_password
at the same interval as the Unix system. But, if the users are simply
using Query Analyser and the other SQL tools,
there's no way to force this.
Yukon, the next release may address password policy enforcement that would
resolve issues like this.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thank you, Kevin. I'll talk to our developers about adding a call to sp_pass
word.

Monday, February 20, 2012

Passing SQL Parameter

I set up successfully the ability to execute a stored procedure on a second SQL Server from a first SQL Server. I understand that I can pass parameters from procedure to procedure... however, I do not know how to pass a sql statement result set as a parameter to another procedure for that second procedure to use. Can anyone give me an example of doing this?

So maybe an example to show proc1 performing the query 'select name, city from tblcustomer', storing the results of that procedure in a parameter say @.resultset and proc2 creating a table of the results stored in @.resultset.

Thats a pretty basic example and will help me get started on this massive parameter passing that I have to do.Originally posted by justastef
I set up successfully the ability to execute a stored procedure on a second SQL Server from a first SQL Server. I understand that I can pass parameters from procedure to procedure... however, I do not know how to pass a sql statement result set as a parameter to another procedure for that second procedure to use. Can anyone give me an example of doing this?

So maybe an example to show proc1 performing the query 'select name, city from tblcustomer', storing the results of that procedure in a parameter say @.resultset and proc2 creating a table of the results stored in @.resultset.

Thats a pretty basic example and will help me get started on this massive parameter passing that I have to do.

One way could be using system stored procedure Sp_Executesql and executing your query and have a resultset returned to you in a Table data type and then you can use that to pass it as a parameter to the second stored procedure.

HTH,

Wednesday, March 28, 2012

PDF rendering bug in SP2

PDF rendering bug in SP2

Wednesday, March 21, 2012

Pausing-Restarting SQL Server Service

Pausing-Restarting SQL Server Service

Pausing-Restarting SQL Server Service

Pausing-Restarting SQL Server Service

Tuesday, March 20, 2012

Path to Server Report?

Monday, March 12, 2012

password synchronization - newbie question

Monday, February 20, 2012

Passing SQL Parameter

Passing result sets

Blog Archive

About Me