Can I set a password to a particular SQL Server database on SA login?
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.
This Content Component encountered an error
Get the code to connect SQL Server version 7.0 to Visual Basic 6.0.continue reading
Learn why SQL Server 2000 connection is lost on the client side when database administrator changes 'SA' password on the SQL Server domain.continue reading
When encrypting SQL tables that have joins in SQL Server 2000, learn about possible problems that may arise with different data values in those ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.