Steve - you can connect with OSQL and change the password with "sp_password"
> Whats the easiest way of securing the SA account when installing MSDE? By
> default it has a blank SA password and no way of changing it without SQL EA
> Can we stop it enabling the TCP port, can we assign an SA account password
> on install or can we change it.
> Ideally this should be without having to install SQL EA Tools.
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqrtf.zip - L7
- SQL Public)