Subject Re: [firebird-support] Firebird 1.5.6 and Windows Server 2008
Author Helen Borrie
At 03:29 AM 19/05/2010, jorge sb wrote:
>Hi. I've installed Firebird 1.5.6 on Windows Server 2008 32bits but I can't
>connect with databases on this server.
>Nothing, I can't connect. The error I receive is: cannot attach to services
>I try to do: gsec -user SYSDBA -password masterkey
>And I get: unaviable database
>I think the problem is in Firebird 1.5.6, because with Firebird 2.1 it works
>good. The problem is I need to use firebird 1.5.6, I don't want to use 2.1.
>Some suggesion?

The old IPServer protocol (a.k.a "Windows local") of Fb 1.5.x and below) doesn't work on Server2008. There is an IMPORTANT note about this on P.2 of the release notes! Use a remote protocol to connect to databases (including security.fdb via gsec from the command shell).

For gsec, the command string requires the -database switch in order for the engine to find the security database:

TCP/IP (preferred):
gsec -database YourserverName:c:\Program Files\Firebird\Firebird_1_5\security.fdb -user sysdba -password masterkey

Named Pipes (deprecated by Microsoft):
gsec -database YourserverName\\c:\Program Files\Firebird\Firebird_1_5\security.fdb -user sysdba -password masterkey

For Fb 1.5.x, because of the space in the filepath, you may or may not need to enclose the entire database string in DOUBLE quotes, e.g.,
gsec -database "YourserverName:c:\Program Files\Firebird\Firebird_1_5\security.fdb" -user sysdba -password masterkey

Also make sure you get rid of the FIREBIRD variable if it is set.