To continue reading for free, register below or login
To read more you must become a member of SearchSQLServer.com
');
// -->

The SA login is a special account for SQL Server because it is the System Administrator (thusly named SA). It is technically a login and not a user – these two concepts are separate in SQL Server terminology. You should set a very strong password to the SA login. You can do this by expanding out the "Logins" object beneath "Security" which is itself beneath the SQL Server object. Right click on the "SA" account on the right window pane and change the password accordingly.
Since this account has full access to all databases, you cannot set a per-database password. If this level of security is required, I suggest NOT using the "SA" account at all. Rather, create an administrative account for each database and assign each a strong password.
|