2.14 Ensure the 'sa' Login Account has been renamed

Information

The sa account is a widely known and often widely used SQL Server login with sysadmin privileges. The sa login is the original login created during installation and always has principal_id=1 and sid=0x01

It is more difficult to launch password-guessing and brute-force attacks against the sa login if the name is not known.

Solution

Replace the

<different_user>

value within the below syntax and execute to rename the sa login.

ALTER LOGIN sa WITH NAME = <different_user>;

Impact:

It is not a good security practice to code applications or scripts to use the sa login. However, if this has been done, renaming the sa login will prevent scripts and applications from authenticating to the database server and executing required tasks or functions.

See Also

https://workbench.cisecurity.org/benchmarks/14058