WCF Adapter and SSO

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › WCF Adapter and SSO

Viewing 1 reply thread
  • Author
    Posts
    • October 8, 2008 at 3:56 PM #20930
      community-content

        Hi Everyone,

        I have a problem that I think is fairly basic but I can’t find a solution to it.

        My project involves transfering a large quantity of data between a SQL Server database to an Oracle 10g Database. I’m using the WCF Adapter to connect to the Oracle database.

        The application currently works fine, but me and the group I’m working with are getting tired of having to reenter the Oracle passwords every time we promote the application and would like to use SSO.

        I’ve created the affiliate application, mappings etc now I’m trying to test the application with SSO. My problem is everytime I specify a send port to use Single Sign On and specify the affiliate application I get the message back saying

        Details:”System.Runtime.InteropServices.COMException (0x80004005): Unable to redeem ticket, no ticket exists in the message.

        I’m guessing I have to issue an SSO ticket before I send the message to Oracle, but I don’t know how to do this, can anyone help me out?

        Thanks in advance

        Stuart

      • October 8, 2008 at 5:21 PM #20931
        community-content

          Are you flowing the original user credentials through BizTalk and into Oracle?  That is the problem that SSO is designed to solve.  You just mentioned that you have to re-enter the password every time you promote the application, and there is a simpler solution than SSO for that problem.  To keep from re-entering the password every time you promote the app, just open the binding file in a text editor and do a find and replace of “Password=**********” with “Password=<real password>”.

          • October 8, 2008 at 9:16 PM #20934
            community-content

              Thanks for your reply Russel. That method will definitely speed up promotion.

              That said for a couple of reasons, not limited to my own curiosity, I would still like to know how to use SSO properly. First in the (very likely) event that I have to link to several Oracle databases in a single application the method you mentioned above would be fairly inconvenient as I would have to replace each password one by one. Also I may be a bit paranoid but is it a good idea to have production passwords easily visible in plain text?

               

              Any suggestions?

               

              Thanks

               

              Stuart

        • Author
          Posts
        Viewing 1 reply thread
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.