To change the sa password, you can use the SQL Server Security Logins interface available from the SQL Server Enterprise Manager. If you are using the SQL Server runtime distributed with the iMarkup Workgroup Server (i.e. MSDE) you can change your password using the SQL Server osql command line utility or sqlexec etc ....

To change your password using osql.

1. Enter a DOS command window on the SQL Server host (xp_cmdshell).

2. Login using the osql command: osql -U"uid" -P"pwd"

where uid is the SQL Server User ID and pwd is the password. For example, the default SQL Server installation uses: osql -U"sa" -P"".

3. Enter the following commands at the osql prompt to change the password for the current SQL Server user you are logged in as:

1> EXEC sp_password 'pwd ', 'new_password '

2> go

3> exit

where pwd is the old password and new_password is the new password.

4. Test the new password by repeating step 1 and 2 and logging in with your new SQL Server password.

Have fun!!

But please note if you change the SA password the admin is sure to know he has been comprimised when he tries to login and have to reinstall MSSQL to get the password back.

SiNeX