>>I realized last night (after I posted the above message) that can't really use the Hash
>>approach for SQL Server authentication password. Hash approach works when Hash
>>number can be compared with a user entry. But as far as getting password from XML
>>for SQL authentication and including it into the connection string, there is nothing to
>>compare it to, so I will have to encrypt the password.
>
>
>Correct. If worse comes to worst, you could always use PGP as an external tool. It is free, readily available, and will handle any level of encryption. Plus, it has the added benefit of automatically producing a text-readable format that can be stored in a table.
What is PGP?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
