First, we have to Login with Administrative rights and Home windows Authentication in MS-SQL server
Proper click on on the SQL SERVER Administrator server as proven in beneath picture
Proper click on on SQL server and click on on properties
In Properties window >> Click on on safety choose SQL Server and Home windows Authentication mode and click on OK
Click on on SQL server and Home windows Authentication Mode click on on the SQL server as proven in beneath picture
Goto Safety and there you’re going to see a username which is SA
By default, this consumer is disabled, therefore click on on properties
Choose SQL Server and Home windows Authentication mode and alter the password
Click on on standing, right here the login for SA consumer is disabled, so we have now to click on on allow.
Click on on refresh,
After refresh you will note the cross mark on the SA consumer has been eliminated.
Restart the SQL server
It’s going to give immediate choose sure, as soon as the restart is accomplished disconnect kind the SQL Server and reconnect SQL server Authentication
Sort the brand new modified password right here. Click on on Bear in mind
