<div>
<div class="content wysiwyg-content">
I'm using MS SQL 2008 Version 10.0.1600.22 RTM Enterprise Edition (64-bit). I can mirror a database with a witness server without an issue. But, when I try and mirror a database that has TDE encryption on I receive the following error. I can mirror it fine before the encryption but not after the encryption. There is nothing about the error in the SQL logs for event logs.<br />
<br />
An error occurred while starting mirror.<br />
&nbsp; Alter failed for Database 'test2'. (Microsoft.SqlServer.Smo)<br />
&nbsp; &nbsp; &nbsp;Alter failed for DatabaseEncryptionKey 'Microsoft.SqlServer.Manag<wbr />ement.Smo.<wbr />ObjectkeyB<wbr />ase',<br />
&nbsp; (Microsoft.SqlServer.Smo)<br />
&nbsp; &nbsp; &nbsp;An exception occurred while executing a Transact-SQL Statement or batch. (Microsoft.Sqlserver.Conne<wbr />ctionInfo)<wbr /><br />
&nbsp; &nbsp; &nbsp;Database 'test2' cannot be opened. It is in the middle of a restore. (Microsoft SQL Server, Error: 927)<br />
<br />

</div>
</div>


I'm using MS SQL 2008 Version 10.0.1600.22 RTM Enterprise Edition (64-bit). I can mirror a database with a witness server without an issue. But, when I try and mirror a database that has TDE encryption on I receive the following error. I can mirror it fine before the encryption but not after the encryption. There is nothing about the error in the SQL logs for event logs.

An error occurred while starting mirror.
  Alter failed for Database 'test2'. (Microsoft.SqlServer.Smo)
     Alter failed for DatabaseEncryptionKey 'Microsoft.SqlServer.Management.Smo.ObjectkeyBase',
  (Microsoft.SqlServer.Smo)
     An exception occurred while executing a Transact-SQL Statement or batch. (Microsoft.Sqlserver.ConnectionInfo)
     Database 'test2' cannot be opened. It is in the middle of a restore. (Microsoft SQL Server, Error: 927)



Encrypted Database Mirror Error

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.