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.
Dig Deeper on SQL Server Security
Related Q&A from Steven Andres
Find how to create a SQL Server 2000 login account and then set user account rights to specific databases with "db_owner." Continue Reading
Get the code to connect SQL Server version 7.0 to Visual Basic 6.0. Continue Reading
I have created a SQL Server 2005 database and I plan to protect it with a username and password. I'm unclear as to how to do this. How can I make a ... Continue Reading