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

Applet Not initialized properly’ Error in Finacle – Solution

Image
Some time , even after installing all java updates and configurations we face issue of  "Applet Not initialized properly’ Error in Finacle"           the best solution for the same is 1..  Use java 7 updt 17 (It always works fine) - if any other version is installed , kindly uninstall the same 2.  now  navigate to following path C:\Users\Administrator\AppData\LocalLow Delete the folder named SUN. Now clear cache and history of internet explorer and re launch internet explorer.  Give a tick in check box and click Later Give a tick and click RUN Here also give a tick and click on RUN Sometimes if you response was delayed it will show Error loading applet. But no problem. Just give user id and password and login. Now when you select FINCORE, another pop up will come as shown below Here also, give a tick in the check box and click RUN.                               ...
Read more

How To Show All Files And Folder Hidden By Virus - Command Prompt

Image
How To Show All Files And Folder Hidden By Virus -   Command Prompt  (Windows 8, 7 and XP )                                          Sometimes we face problems due to  much viruses that when we  insert an external device like pen-drive, Flash drive or memory card or any other external storage device and all the data of the devices are automatically hidden  and a shortcut to those files are created.         On that case the files are not deleted they are hidden by some-kind of viruses (Shortcut virus). Generally we  format the drive then we loss  all the data. Solution Process To View All The Hidden Files And Folder using Command Prompt Open  Command Prompt (CMD)  as an Administrator. Navigate to the drive whose files are hidden and you want to recover. Then Type  attrib -s -h -r /s /d *.* ...
Read more

Post Office Saving Schemes Monthly Income Scheme Account

Image
                       Post Office Saving Schemes                           Monthly Income Scheme Account                                          Overview Account may be opened by individual.Account can be opened by cash / Cheque and in case of Cheque the date of realization of C​heque in Govt. account shall be date of opening of account. Nomination facility is available at the time of opening and also after opening of account. Account can be transferred from one post office to another. Any number of accounts can be opened in any post office subject to maximum investment limit by adding balance in all accounts. Account can be opened in the name of minor and a minor of 10 years and above age can open and operate the account.​​​ Joint account can be opened ...
Read more