SQL express Security
-
I'm using SQL Server Express, and I've seen the option to provide a SA password, instead of using the default windows authentication. But doesn't this only deal with the server portion. What I'm concerned about is password protecting, maybe encrypting, the MDF file itself, in the event that the file is stolen off the server. If there is any easy was to do this, any help and points in the right direction would be greatly appreciated.
A soft glow comes from the pit in the darkness. The clicking noise become faster - and louder. A wind begins to stir up from the pit, as the creature flexes it's wings, preparing for flight. You stare into the pit, and hear a voice say in your mind, "If you survive the encounter, declare it to the world." The Code Demon Rises.
-
I'm using SQL Server Express, and I've seen the option to provide a SA password, instead of using the default windows authentication. But doesn't this only deal with the server portion. What I'm concerned about is password protecting, maybe encrypting, the MDF file itself, in the event that the file is stolen off the server. If there is any easy was to do this, any help and points in the right direction would be greatly appreciated.
A soft glow comes from the pit in the darkness. The clicking noise become faster - and louder. A wind begins to stir up from the pit, as the creature flexes it's wings, preparing for flight. You stare into the pit, and hear a voice say in your mind, "If you survive the encounter, declare it to the world." The Code Demon Rises.
IIRC, change the sa password to something other than the default, then there isn't any good stealing the .mdf file...