Showing posts with label basically. Show all posts
Showing posts with label basically. Show all posts

Tuesday, March 27, 2012

Forms authentication...

Hello,

I know that basically SQL Reporting Services uses windows authentication. Does anyone know a way to change this behavior so that I can use forms authentication.

Thanks for any help.check this article :Harden MS Reporting Services Using Custom Extensions
and this one too :Using Forms Authentication in Reporting Services|||Just as a side note, you can only use forms authentication if you have an enterprise sql server licence.

Monday, March 26, 2012

Forms Authentication : Object moved

Oops!
Sorry I don't know why I sent that without a question :-)
Basically, I've implimented the Forms Authentication sample, and now
the following code causes the error above.
ReportingService rs = new ReportingService();
rs.LogonUser("UserWithBlankPassword",String.Empty, null);
BatchHeader BH = new BatchHeader();
BH.BatchID = rs.CreateBatch();
rs.BatchHeaderValue = BH;
ScheduleDefinition SD = new ScheduleDefinition();
SD = ((ScheduleDefinition)S.ScheduleDefinition);
string scheduleid = rs.CreateSchedule(R.ReportId.ToString() + "_" +
EBCUserId.ToString(),SD);
rs.ExecuteBatch();
Anyone got any ideas?
Thanks,
Phil Winstanley
Microsoft ASP.NET MVPPhil,
It may be because the authentication ticket (sqlAuthCookie) is not passed to
the Report Server. The successful output of the LogonUser call is an
in-session cookie sent to the browser (just like ASP.NET Forms
Authentication). I think what is happening in your case is that you are
generating the cookie on the same page on which you are trying to pass it
back. Do a tcp trace to find out if the cookie is sent to the Report Server.
If not, you may need to move the subsequent SOAP calls to another page after
a redirect.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Phil Winstanley [Microsoft MVP ASP.NET]" <phil@.winstanley.name> wrote in
message news:cffcgk$ol3@.odak26.prod.google.com...
> Oops!
> Sorry I don't know why I sent that without a question :-)
> Basically, I've implimented the Forms Authentication sample, and now
> the following code causes the error above.
> ReportingService rs = new ReportingService();
> rs.LogonUser("UserWithBlankPassword",String.Empty, null);
> BatchHeader BH = new BatchHeader();
> BH.BatchID = rs.CreateBatch();
> rs.BatchHeaderValue = BH;
> ScheduleDefinition SD = new ScheduleDefinition();
> SD = ((ScheduleDefinition)S.ScheduleDefinition);
> string scheduleid = rs.CreateSchedule(R.ReportId.ToString() + "_" +
> EBCUserId.ToString(),SD);
> rs.ExecuteBatch();
> Anyone got any ideas?
> Thanks,
> Phil Winstanley
> Microsoft ASP.NET MVP
>

Formatting, pdf, and SP2

I have a strange issue that I need help resolving. Basically, the formatting
on a report that I am exporting to pdf changed when I updated my VS to the
SP2 of the Reporting Services. Here's what I am trying to do and what SP2 did:
I have a report that I created that makes address labels. I made it to where
it has three columns, and it fit 10 rows on one page. It worked great, until
I installed SP2. Now, it will only print three across the top of the page,
then move on to the next page.
So, my questions are: 1) should I reinstall pre-SP2 RS so that I can do this
report the way that I had it, or 2) does anyone know of an example that will
help me to do what I had done in the pre-SP2 installation?
Any help would be greatly appreciated!!!It sounds weird, and at least I don't know if this is either caused by the
SP2. But what you can do is redefine your report's margins