0

I am trying to drop and recreate sa account to reset the password.

IF  EXISTS (SELECT * FROM sys.server_principals WHERE name = N'sa')
DROP LOGIN [sa]
GO

I am getting an error

Cannot use the special principal 'sa'.

also when I try to reset sa password in SSMS, I am getting an error Cannot alter the login 'sa' because it does not exist or you don't have permission. Error: 15151

Phil Hollenback
  • 14,947
  • 4
  • 35
  • 52
user46529
  • 137
  • 1
  • 6

1 Answers1

2
sp_password NULL,'new_password','sa'
go
aleroot
  • 3,180
  • 6
  • 29
  • 37