Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Rename the SQL Server sa account

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: ,,,