Sunday, March 27, 2011

How to: working with SA account in SQL Server 2008

1. To rename sa account from default "sa" to new name

alter login sa with name=securesa
go

2. Disable sa account

alter login sa disable
go

4. Enable sa account

alter login sa enable <---- same as alter login [sa] enable
go


5. Reset password for sa account

alter login sa with password=N'new_password_here'
go