Supposing that I want to store the SQL Server name in the app config file?

I suppose that storing the password there if encrypted wouldn't be bad or
would it?

If I could do that then I would probably need to include a utility program
for changing the database password right?
I mean the database password would get changed in the SQL Server but to tell
my app about it, I could encrypt and write the value to the app config and
have a util prog. To allow the user to change it.

Is this ok or is there a better way?

Shane

If you need help on encryption, look at the System.Securty.Cryptography
namespace.

You won't be using password hashes if you need to extract the password, but
I have written a hash generator (HashGen) if you are interested.

--
HTH,
-- Tom Spink, Über Geek

Please respond to the newsgroup,
so all can benefit

"Maybe it's a game called 'Punish the User'"


"SStory" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Supposing that I want to store the SQL Server name in the app config file?
>
> I suppose that storing the password there if encrypted wouldn't be bad or
> would it?
>
> If I could do that then I would probably need to include a utility program
> for changing the database password right?
> I mean the database password would get changed in the SQL Server but to
tell
> my app about it, I could encrypt and write the value to the app config and
> have a util prog. To allow the user to change it.
>
> Is this ok or is there a better way?
>
> Shane
>
>

Shane,

You might want to check out the Configuration Management Application Block
from the MS Patterns and Practices group. It has lots of cool features for
storing config data (including encryption).

http://msdn.microsoft.com/library/de.../html/cmab.asp

--
Rob Windsor
G6 Consulting
Toronto, Canada



"SStory" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Supposing that I want to store the SQL Server name in the app config file?
>
> I suppose that storing the password there if encrypted wouldn't be bad or
> would it?
>
> If I could do that then I would probably need to include a utility program
> for changing the database password right?
> I mean the database password would get changed in the SQL Server but to
tell
> my app about it, I could encrypt and write the value to the app config and
> have a util prog. To allow the user to change it.
>
> Is this ok or is there a better way?
>
> Shane
>
>