Home  • Database • Microsoft SQL Server

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: SSMS4 1 Login using Windows Authentication and ".SQLExpress" as Server Name SSMS4 2 Change server authentication mode - Right click on root, choose Properties, from Security tab select "SQL Server and Windows Authentication mode", click OK SSMS1 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) SSMS2 4Grant permission - Go to Status tab, make sure the Grant and Enabled radiobuttons are chosen, click OK SSMS3 5 Restart SQLEXPRESS service from your local services (Window+R > services.msc)

Comments 2


http://stackoverflow.com/questions/3781365/how-to-change-sa-password-in-sql-server-2008-express
https://msdn.microsoft.com/en-us/library/ms188670(v=SQL.90).aspx

Share

Copyright © 2024. Powered by Intellect Software Ltd