Tuesday, June 8, 2010

SQL Server 2008 Reporting Services RS.EXE Supporting Forms Authentication

I've decided to expand the scope of my blog to more than just Identity Management. Recently, I've been submerged in the BI space, and since I'm not sure when I'll resurface, I'd like to contribute some of the cool stuff I've been doing back to the community.

I'm currently working on a scale-out deployment of SSRS that uses Forms authentication. Everything is working well with the security extension, and now we're focusing on moving everything into Stage. Good time for the scripting utility, rs.exe, right? Well, if you didn't already know, rs.exe isn't supported with Forms authentication. Wow, what a bummer.

What's more, I can't use the RSScripter, which is a very cool and useful app for generating scripts for rs.exe.

So, what do I do? I could write my own utility. We already have a web service client to integrate SSRS with an in-house app. I would just need to add a bunch of management features to it... and add commands to extract and load... and make it generic enough to reuse... and then maintain it. Nah, that sounds like a lot of work. Let's just use .NET Reflector on the original rs.exe app!

I've reassembled rs.exe with the ability to preserve the RS authentication cookie, which is required with Forms authentication. Hopefully someone out there finds this useful!

http://rs1.codeplex.com/

BTW, the RSScripter also doesn't support Forms authentication, because rs.exe doesn't, and RSScripter is dependent on rs.exe. Leave me a comment if you need a version of RSScripter that works with Forms auth.

Good luck!

Posted by at

38 comments:

  1. xgametopJune 13, 2010 at 1:23 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  2. AnonymousJune 25, 2010 at 2:36 AM

    I would really like that RSScripter that does Forms auth. I have been trying to move a RS server and maintain all permissions etc. for over a week now and it is just not happening. Thanks

    ReplyDelete
  3. Joe ZamoraJune 25, 2010 at 10:40 AM

    This comment has been removed by the author.

    ReplyDelete
  4. AnonymousJune 27, 2010 at 11:40 PM

    This comment has been removed by a blog administrator.

    ReplyDelete
  5. AnonymousJuly 8, 2010 at 12:12 AM

    Thank you so much for your help Joe.

    That problem has been irritating me for almost 2 weeks now and
    finally its fixed.
    It was so nice to finally see all the .rdl files and permissions
    extracted correctly.

    Thanks so much again.

    ReplyDelete
  6. AnonymousSeptember 7, 2010 at 8:21 PM

    Hi. I would be very interested in RSSCRIPTER which supports forms authentication.

    ReplyDelete
  7. AnonymousSeptember 8, 2010 at 4:04 PM

    Thanks Joe. Your modified RSSCRIPTER works well. I was able to download all the files from my Custom authentication server! YEAH!!!

    ReplyDelete
    Replies
    1. AnonymousJuly 26, 2012 at 3:48 PM

      Please tell me from where the RSScripter (that works with forms authentication) can be downloaded from

      Delete
  8. AnonymousOctober 22, 2010 at 5:57 AM

    I need this RSS scripter.
    And i want to ask one question that can we change publish reports.rss file for working with form authentication?

    ReplyDelete
  9. AnonymousNovember 18, 2010 at 4:28 AM

    Hi Joe, can you provide a sample of the RS inputfile (Script.rss) in below example to script the data
    sources, reports, subscriptions from report server to deploy to another report server:

    rs –i Script.rss -s http://servername/reportserver

    ReplyDelete
  10. Joe ZamoraNovember 18, 2010 at 7:13 AM

    This comment has been removed by the author.

    ReplyDelete
  11. Joe ZamoraNovember 18, 2010 at 7:14 AM

    Here's how you would use RS1:

    rs1 -i Script.rss -s http://servername/Reportserver -u <username> -p <password>

    If you want to script all of the data sources, reports, etc., I would use the RSScripter1. Leave me a comment on the codeplex site, and I'll send it to you.

    ReplyDelete
    Replies
    1. JoanAugust 31, 2016 at 12:05 AM

      Hi Joe, how can I deploy my data source with user credential in Report server? can i have the sample scripts?

      Delete
    2. Joe ZamoraAugust 31, 2016 at 9:43 AM

      Hi Joan, please use the "Contact Me" form on this blog and I'll send you RSScripter1. Cheers!

      Delete
  12. Matt D.November 18, 2010 at 7:29 AM

    Hey Joe,

    Thanks for giving me this it works perfectly in our custom authentication environment.

    Saved me a lot of work.

    Thanks again,
    Matt

    ReplyDelete
  13. AnonymousJanuary 27, 2011 at 6:41 AM

    Could I get this RSS scripter.

    ReplyDelete
  14. AnonymousMarch 30, 2011 at 11:44 AM

    Thanks for sending me the rsscripter1. It has been very helpful.

    ReplyDelete
  15. Ed YorkJune 22, 2011 at 3:47 PM

    Thanks so much for your help in sending me the RSScripter1 tool that works with Forms Authentication. I loaded it up and it works great!

    You even went above and beyond to help me get around Exchange stripping out the EXE from the Zip.

    Great job!

    ReplyDelete
  16. AnonymousAugust 19, 2011 at 6:47 AM

    Joe, Thanks so much for helping modify the RssScripter utility. Saved a lot of work reinventing the wheel. I especially appreciate the promptness with which you responded to my queries. -Smitha Reddy

    ReplyDelete
  17. AnonymousAugust 19, 2011 at 3:08 PM

    The modified scripter worked like a charm for me too!
    Nice work Joe. Saved me heaps of time.

    Cheers

    Dace

    ReplyDelete
  18. AnonymousSeptember 7, 2011 at 2:07 AM

    This comment has been removed by a blog administrator.

    ReplyDelete
  19. AnonymousOctober 26, 2011 at 8:31 PM

    Hi is it possible to get rsscripter source code from somewhere?
    rsscripter does not support shared datasets in 2008R2.
    Cheers

    ReplyDelete
  20. OsseNovember 2, 2011 at 7:34 AM

    i really like your post .. i would like to bookmark your site for my future needs :)
    dissertations

    ReplyDelete
  21. AnonymousApril 27, 2012 at 4:29 AM

    Thank you for such a prompt response. You helped me a lot. Unfortunately, there is still a problem (with Shared Datasets), but I hope to solve it
    Best regards

    ReplyDelete
  22. AnonymousApril 27, 2012 at 4:30 AM

    From Camelya

    ReplyDelete
    Replies
    1. AnonymousJuly 26, 2012 at 3:46 PM

      Please someone upload the RSScripter here.

      Delete
    2. Joe ZamoraJuly 27, 2012 at 9:11 AM

      Please use the Contact link on Codeplex and I'll send it to you.

      http://www.codeplex.com/site/users/view/zamojo

      Delete
    3. AnonymousJuly 27, 2012 at 11:42 AM

      Hi Joe,

      I contacted you using the link above a while ago. i hope you got that request. Hope to hear from you soon. Thanks a lot and i really appreciate your reply.

      Thanks

      Delete
  23. AnonymousNovember 7, 2012 at 3:29 AM

    Hi Joe,

    Thanks again for your version of RSScripter. I can now script out the objects from my SSRS Website.

    Thanks,
    Paul

    ReplyDelete
  24. Paul TrestonNovember 7, 2012 at 3:30 AM

    This comment has been removed by the author.

    ReplyDelete
  25. web designing in ukDecember 1, 2012 at 2:32 AM

    I am actually happy I experiential this superb blog. I have to thank you too much info online! I really like we have bookmarked your internet blog for brand new things to check out email on the highway.

    ReplyDelete
  26. MargusMarch 4, 2013 at 7:28 AM

    Hi! Can you please send me your version of RSScripter. i have sent you a message in Codeplex.
    Regards,
    Margus

    ReplyDelete
  27. AnonymousMay 7, 2014 at 12:54 PM

    Thank you very much for being so helpful and sending the updated RSScripter! Very helpful.

    ReplyDelete
  28. Jhon DrakeMarch 31, 2015 at 5:54 AM

    Thanks for sharing helpful and useful information, it provides the information about audit sql server in sql server 2008 but I test this automate tool from http://www.lepide.com/lepideauditor/sql-server.html which enables the user to audit sql server and enables data filter options that assists to unfold the minutest of information to the last level. It allows to automate report generation .

    ReplyDelete
  29. MunsoorAugust 29, 2016 at 7:26 AM

    This is great. Would it be possible to share the code of how you did this?

    ReplyDelete
    Replies
    1. Joe ZamoraAugust 29, 2016 at 7:44 AM

      Please use the "Contact Me" form on this blog and I'll send you the code. Cheers!

      Delete
  30. seomonsterMarch 19, 2019 at 11:40 PM

    I can see that you are an expert at your field! I am launching a website soon, and your information will be very useful for me.. Thanks for all your help and wishing you all the success in your business. free hosting with cpanel

    ReplyDelete
  31. Visit AlbaniaJuly 23, 2020 at 1:57 PM

    Limit and memory. MySQL can deal with practically any measure of information from just a couple of lines to as much as 50 million lines or more.Change Site URL Using MySQL

    ReplyDelete

Subscribe to: Post Comments (Atom)