Rename the SQL Server sa account

  • Article

Another good thing that’s done at the SQL Server community evenings is a 5 minute slot where anyone can have a go at showing something interesting.

Tony Rogerson got me to open the batting to encourage others to have a go.  I am not sure who it was who came up next but it was a simple thing on renaming the infamous sa account…

ALTER LOGIN sa WITH NAME = SECRETSA.

Tony was too keen on leaving his laptop like that in case anything broke so just run the same command again..

ALTER LOGIN SECRETSA WITH NAME = SA.

It’s a useful security tip, especially if you are seeing lots of failed sa logins.

Technorati Tags: saN,sql server,logins,security