Thanks, I'll see if I can hone in on the issue.

I'm having this issue as well.

Whenever I'm checking the user mapping of the login properties it takes a good minute before it displays. It's correct mind you, but extremely...

There is a fix - Cumulative Update package 3 for SQL Server 2008 R2 -

http://support.microsoft.com/kb/2261464

I applied this and it resolved the issue... If you wade through the...

Help !!! I'm getting the same type of issue where I can't edit Job Steps.

I just installed

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

Apr 2 2010...

I'm a complete novice on encryption and confused by the statement:

Also, there was a lot of discussion regarding the password that protects the key and concern over "backing up" the...

Sorry I took so long to get back... other things popped up.

Your advice put me on the right track. I restored the DMK, built the certificate, and restored the...

So, It’s the old good news bad news:

The good news is that I was unable to restore the test DB backup on the new instance.

The bad news is that when...

I did attempt to restore the backup of the encrypted database to a different server – which produced the following result:

Cannot find server certificate with thumbprint '0x8BF8CD0AC53329DE9283087552646C5499E2C0AB'.

RESTORE FILELIST is terminating...

Hopefully someone can point me in the right direction.

I Backed up the SMK

Created a DMK on the master DB

Created a Certificate on the master DB

Created an encryption key in my...