Tuesday, March 27, 2012

Encryption of SQl Express database

Hi!

Could you help me how could I encrypt an SQL Express database with a password?

The lines I currently use:

ssconn.ConnectionString = "Data Source=.\SQLEXPRESS;Integrated Security=True;"

CreateDatabase = "CREATE DATABASE i ON (NAME = i, FILENAME = '" & ssceconfilename & "')"
Dim myCommand As New SqlCommand(CreateDatabase, ssconn)
myCommand.ExecuteNonQuery()

I managed to do the encryption with SQL CE 2.0, but how to do it with express?

Thank you!

Check here:

http://www.databasejournal.com/features/mssql/article.php/3483931

Buck Woody

No comments:

Post a Comment