Editing Database
If you wish to work with the database using SQL Server
Management Studio there are two options:
- Using SQL statements
- Cient DLL
Using SQL statements
Open Query window, switch to the protected database and enter
unlocking command:
OPEN SYMMETRIC KEY DBDX DECRYPTION BY
PASSWORD='<password>'
After that query window will have access to the database,
however the rest of application will not. It happens because SQL
SMS uses several connections to retrieve and update database
information. You need to give access to whole process to be able to
work:
exec dbd_unlock_for_host
Try to browse the database now. Access must be granted.
Client DLL
You should follow instructions described here
|
