2

I'm trying to use a FireBird database engine.

OS: Windows 8.1 x64(SmartScreen enabled, UAC enabled, Custom AntiVirus installed(with firewall))

FireBird: Version 2.5, Installed as SuperServer, as application without guardian.

I'm trying to manage this engine using many applications, such as FlameRobin or FireBird Maestro.

At the first:
After installation db said, that the "firebird.msg" not found in windows directory, when I tried retrieve server version.

Ok. I'm copied it to system directory from program files.

At the second(fatal):
I cant connect to my databases!

Firebird Maestro said, when I'm trying connect to created database:
enter image description here

Or FlameRobin(choosed context menu "Retrieve server version" for "localhost"):
enter image description here

I'm nothing changed. Never installed firebird database. Default user(SYSDBA) and password(masterkey) is used, tried in any сase sensitivity.

Today, I'm tried install FireBird on Windows Server 2003, and do some in FlameRobin, and all is works!

Whay the DB not works under Windows 8.1?

Improve this question

1 Answer 1

Reset to default
5

If you start Firebird as an application, then Firebird must either be located in a normal folder (not a system folder under UAC protection like Program Files), or you need to run it as Administrator.

The reason is that Firebird needs write access to several files in its own program folder, which doesn't work without privilege elevation.

Better yet: run it as a service. The service by default has sufficient rights to start Firebird.

Improve this answer
6
  • Mark, is this true for all firebird versions (even 3.0)?
    – Wolf
    Jan 30, 2017 at 11:36
  • 1
    @Wolf Yes, this also applies to Firebird 3.0, the most notable file this applies to is the security database
    – Mark Rotteveel
    Jan 30, 2017 at 12:39
  • ...and this file, I expect, will keep there?
    – Wolf
    Jan 30, 2017 at 12:45
  • 1
    @Wolf The default location of the security database is in the Firebird installation location, it can be configured elsewhere though in FB3. However that might not fix all problems, because Firebird also needs access to some of its lock files, etc in C:\ProgramData\Firebird, and I have heard about some problems when running non-privileged Firebird processes (but I believe that had to do with creating the initial folder). That said: Firebird is a server process: except for maybe development purposes I can't see good reasons to want to run it as an application instead of a Windows service.
    – Mark Rotteveel
    Jan 30, 2017 at 12:49
  • Thanks for the detailed explanation. Yes, I also see that it is supposed to run as a service, but, well, the option to do otherwise is still open...
    – Wolf
    Jan 30, 2017 at 12:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.