Archive for September, 2008

changing sa login in MSDE

I’ve found this little legacy app on our network that runs on MSDE.  Of course, there’s no documentation on it, so to restor the app on a new server requires me to reset the sa login. Here’s how: from the command prompt, execute: osql -E -Q “sp_password NULL, ‘newpassword’, ‘sa’” #### replace newpasswd with a [...]




You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.