Re: Help, Transferring XML data under SSL

From: Michael Rys [MSFT] (mrys_at_online.microsoft.com)
Date: 09/25/04

  • Next message: Prasad: "XMLA Accessing via http fails" 
    Date: Fri, 24 Sep 2004 17:48:21 -0700

    See below.

    Best regards
    Michael

    "jimb" <spam@spamity.spam> wrote in message
    news:Xns9569529944AA0spamspamityspam@68.12.19.6...
    >I need some advice on how to securely transfer data between two servers.
    > Here is the situation. We have two sql servers that hold student data.
    > I have full access to my sql server, but only write access to the main
    > sql server on campus. I hope to use XML and SSL to transfer student
    > data to the main server.
    >
    > As for generating the XML, I'll have an asp.net page set up in a secure
    > directory that will generate the data in xml format. The data people
    > will access this page and get the xml file with all the data.
    >
    > What's the best way to turn a sql server table into XML format?

    Use FOR XML on your SELECT statement. If you cannot write statements
    directly against the database, use the SQLXML component.

    > What about the SSL part? Do all we need to do is access it with
    > https:// just like you would a typical secure page?

    Yes. But your webserver needs to be configured to accept SSL connections
    (enable the SSL port etc.).

    > As for accessing the page, how will the data people authenticate to my
    > server? What's the best way? I'm sure they'll want to script it so
    > that this can be done automatically.
    >
    > --
    > .
    > http://sf-f.org, weblog and search engine for fans and writers of
    > speculative fiction.
    > .

  • Next message: Prasad: "XMLA Accessing via http fails"

    Relevant Pages
    Loading