smtzac (10/22/2014)
I need to configure mirroring on a TDE database. I found out since it's TDE (encrypted db) can't use Wizard to configure mirroring.
You can still use the wizard if you ensure you install the certificate from the principal to the mirror. Have you restored the cert yet??
smtzac (10/22/2014)
Unfortunately I can't script out mirroring set up like Log shipping.I am using domain account (my login) to setup mirroring but I want to use different service account to run mirroring. just say ABCD\JohnSmith my account name but I want to use ABCD\MirrorSVC domain account to run mirroring. Can someone help me with the Script ?
Are you manually restoring the database or letting the wizard complete this for you?
Restore the cert and retry the wizard.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉