Subject Re: Can I use Firebird database file under EFS directory?
Author Adam
--- In firebird-support@yahoogroups.com, "KIMURA, Meiji"
<kimura804@...> wrote:
>
> Hi All,
>
> MS Windows NTFS files system provide encryption function called
"EFS".
> I try to use this function for firebird database file (*.fdb).
> When I convert existing databse, I cannot open the database from isql,
> But when I create new database file on EFS directory or restore to
there
> it looks to work at glance.
>
> Can I use Firebird database file under EFS directory?
> Is there anyone to use this function or have further information ?

I have just done an experiment and discovered the same behaviour as
you have found. I think the problem is that the encryption details.
The Firebird service runs as a different user, and if you encrypt the
file than the service running as LOCALSYSTEM does not have the a key
to read or write to it.

Right click on the file, Advanced -> Encryption Details and Add the
'<computer name>$' user.

Adam