How to reset SQL admin (sa) password? Print

  • 3

This article show you how to reset SQL server sa password (provided you are administrator)

1) Login to Windows server.
2) Open Microsoft SQL Server Management Studio
3) Login with "Windows Authentication" mode
4) Press "New Query" and paste following:

ALTER LOGIN [LoginName] WITH PASSWORD=N'NewStrongPassword'
GO

change [LoginName] to sa
change NewStrongPassword to your new password

5) Press "Execute".
6) Done.

Was this answer helpful?

« Back