Best practise for sa when deploying MSDE

[BadgerByte]

Hi all,

I've managed to deploy MSDE by attaching a database etc.. all working beautifully now.

As it stands however my application is using the sa account with a standard password (which is quite clearly visible in my installer config), which I realise is not a good idea!!

I want to change the sa password to something machine specific so it can be recovered if need be though I could just make it random if it comes down to it.

How can I set up a new account in my installer class and change the sa password?

Does anyone who is currently deploying MSDE have any tips regarding what to do with the sa account in general?

Any advice would be greatly appreciated,

Thank you.

 

[rseyo]

I am not sure if this is the one your talking about?!

Try this in the command prompt.(if you've set it up with your "path"envirmnt variable)

C: osql -s name_of_server -E
1> sp_password Null, 'YourPassword', 'sa'
2> go
Password Changed.
1>exit

 

[rseyo]

how do you make your skull blink?

 

[ManicCW]

I store password in registry (use encription if you want to protect it). There are many examples of encription on net.

 

[BadgerByte]

Thanks for the suggestions guys greatly appreciated!!
rsyeyo - It's an animated GIF.