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

Rename the SQL Server sa account

  • Comments 2
  • Likes

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: ,,,
Comments
Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment