Effective Solutions to Change SA Password

Introduction In this article we will have a discussion on how to change SA password in SQL Server. The solutions mentioned in this article are applicable to change SQL Server SA password on all version of SQL Server. When the last time your SQL server SA password was changed? SA which is the abbreviation for System Administrator refers to the person who maintains and operates Microsoft SQL Server. When you installed SQL Server, the default user is sa and it is non-password protected. To protect your SQL Server, you should not have a blank SA password. Therefore you need to … Continue reading

2 Simple Methods to Change SQL Server 2008 Password for SA Account

For security reason, we need to change SA password in SQL Server. Today we are going to discuss how to change SA password in SQL 2008. Method 1: Changing SA password in SQL 2008 by using Management Studio Step1: Login into SQL Server 2008 with Windows Authentication mode. (This means you have to login in the local Windows computer of SQL Server 2008.) Step2: Now go to “Object Explorer>>Security>>Logins”. Next find sa and right click on it. Step3: Select “Properties”. And then in the newly pop-up window, enter a new password to the Password filed, and confirm password later. However, … Continue reading