How to reset MSSQL admin password

(1) Open command prompt with the administrator

(2) This command will list all the MSSQL in your server

 osql -L

(3) By this command you’ll connect to MSSQL server using administrator account

osql -S servername -E

(4)To change sa password you should execute the following query

sp_password NULL,'new_password','sa'

Reset administrator username and password in SmarterMail

To reset the primary administrator login and password in SmarterMail, follow the instructions below:

(1) Stop the SmarterMail Service

(2) Open Windows Explorer (My Computer)

(3) Go to C:\Program Files\SmarterTools\SmarterMail (or wherever you installed SmarterMail)

(4) Open the Service subdirectory

(5) Make a backup copy of the file MailConfig.xml

(6) Right-click on MailConfig.xml and choose Open With -> Notepad

(7) Find the section that looks like this:

<!-- ** System Admin *************************** -->
<!-- ** To reset admin password, delete these items ** -->
<!-- ** and then restart the SmarterMail Service.   ** -->
<!-- ***************************************** -->
<sysadminusername> ... </sysadminusername>
<sysadminpassword> ... </sysadminpassword>
<!-- ***************************************** --> </p>

(8) Delete those lines and save the file

(9) Start the SmarterMail Service

(10) You should now be able to log in to SmarterMail by using the following:

Email: admin
Password: admin