Thanks Tom & Roy,

I am in (UTC-05:00) Eastern Time (US & Canada) time zone.

The SQL Audit log is written to a text file by SQL Server.

What do I need...

Thanks Roy.

We are in Eastern Time zone.

I think the time zone is not a problem.

The problem is that the SQL Audit event log time is different from the Server current...

Hello, Roy,

The TDE works fine on SQL Server 2008 R2 for me.

Now I am trying to use SQL Audit in SQL Server 2008.

Everything is working but the Audit log date...

Did as what you said but the percent_complete is still shown 0.

I also think it might be a permission issue but no idea what it is.

Thanks a lot,

Eric

Under a domain user account. This user has Administrator's rights on the Windows server and is assigned sysadmin role on SQL server.

Thanks,

Eric

Hi Roy,

The percent_complete = 0 and never changed. It was working on a different server (VM) without SP1 before. The server was destroyed after the testing.

Now I am working on...

Hello Roy,

I successfully implemented TDE on SQL Server 2008 without SP1 before.

Now I am testing the TDE on SQL Server 2008 with SP1 (version 10.0.2531.0) but it is not working...