How to use EFS to encrypt SQL DB file

From: Jacky Wong (jackywong@solutionexpert.com.hk)
Date: 05/09/02


From: "Jacky Wong" <jackywong@solutionexpert.com.hk>
Date: Wed, 8 May 2002 20:29:04 -0700


Dear all,
Thank you very much for your attention. I am facing a
problem about encrypt SQL DB file with EFS. Here is the
situation:
1. I login the Win 2000 Server with the administrator
account
2. stopped the SQL Server's service
3. I encrypt the dbf file with EFS
4. Start the SQL Server's service
5. I start the Enterprise manager
6. I notice that the database is suspended

Am I doing anything wrong? Please help.
Best regards,
Jacky