Change sa password using SQL Server Management Studio
(copied from:http://stackoverflow.com/questions/3781365/how-to-change-sa-password-in-sql-server-2008-express )
If you want to change your 'sa' password with SQL Server Management Studio, here are the steps:
- Login using Windows Authentication and ".\SQLExpress" as Server Name
- Change server authentication mode - Right click on root, choose Properties, from Security tab select "SQL Server and Windows Authentication mode", click OK
- 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)
- Grant permission - Go to Status tab, make sure the Grant and Enabled radiobuttons are chosen, click OK
- Restart SQLEXPRESS service from your local services (Window+R > services.msc)
No comments:
Post a Comment