Change Password of SA Login Using Management Studio

Login into SQL Server using Windows Authentication.
In Object Explorer, open Security folder, open Logins folder. Right Click on SA account and go to Properties.
Change SA password, and confirm it. Click OK.
Make sure to restart the SQL Server and all its services and test new password by log into system using SA login and new password.
Reference : DHARMENDRA KUMAR
UPDATE : There has been discussion about restarting the SQL Server and all its services. Please read all of them before making final decision for your scenario.

Comments

Post a Comment

Popular posts from this blog

HOW TO SUPPLY STAMPS TO BO FROM SO in SAP (CSI) ?

Image
SUPPLY STAMPS TO BO FROM SO in SAP (CSI) The procedure for supplying stamps from SO to BO for CSI Post offices   The entire process is divided into two parts              1.   Removing material from SO Location       2.   Placing material in to BO Location ===== Removing material from SO Location ===== Tcode : MIGO Select option “Remove from Storage” TF rem.fm str.toSLoc = “313” Doc header text : Perticular about sent stamps Material : RVS100 (For sending Revenue stamps, select other stamps as per necessity ) Plant : G131 Storaloc : SO CODE Destination : BO Code for whom stamp is to be sent Enter quntit Then press check and POST You will get document no (Send stamps with this document no to BO) ====== Placing stamps in BOs location =========== (This is to be done on the day when BO received actual stamps) Tcode : MIGO Action : Place in Storage Enter document no : Document no generated as above Press enter All the Stamp information will be displayed Select the stamps actually received
Read more

Fresh installation of CSI Applications and Database

After CSI Roll out, we often need to reinstall CSI Applications or create fresh database when existing server goes out of order like HDD Crash issues. By following the below steps, a fresh database and applcaitons can be installed easily in a new / formatted PC Copy Roll_out_2 folder into C:\POS_Installer Now Click on C:\POS_installer\Roll_out_2\POS\Others\Roll out\start.bat Click on get Started Button Enter Facility  ID of Office Click on Save button Download Download :             Source :            C:\Roll_out_2\POS\Software             Destination :    C:\POS_Installer           Click on Download button Application Source :            C:\Roll_out_2\POS\Application                Destination :    C:\POS_Installer              Click on Download button CASSO Source :            C:\Roll_out_2                Destination :    C:\POS_Installer Setup Configure Systems : Machine ID (Select Database,Backoffice,counter one by one) Select OS type Click on Add Butotn Copy Software
Read more