Jun 23rd, 2016 at 11:44 AM

How to change sa password in SQL Server Express?

If you want to change your 'sa' password with SQL Server Management Studio, here are the steps: 1 Login using Windows Authentication and ".SQLExpress" as Server Name 2 Change server authentication mode - Right click on root, choose Properties, from Security tab select "SQL Server and Windows Authentication mode", click OK 3 Set sa password - Navigate to Security > Logins > sa, right click on it, choose Properties, from General tab set the Password (don't close the window) 4Grant permission - Go to Status tab, make sure the Grant and Enabled radiobuttons are chosen, click OK 5 Restart SQLEXPRESS service from your local services (Window+R > services.msc)