Subject Re: [firebird-support] upgrade to 2.01 loses SYSDBA password
Author Helen Borrie
At 12:52 PM 20/05/2007, you wrote:
>I've upgraded Fb 1.5 to 2.01 on a non-critical Windows 2003 machine that
>had one previous database. (I uninstalled 1.5 first)
>I'm trying to run a script file with a simple create database command and
>I get an error.
>CREATE DATABASE "d:\db\MyDb.fdb"
> PASSWORD "masterkey";
>Your user name and password are not defined. etc
>What might have gone wrong, how can I fix?

This is a major upgrade and your old security.fdb won't work.
Meanwhile, your new server is reading security2.fdb, a placeholder
security database, for which the SYSDBA password is
'masterkey'. READ THE RELEASE NOTES !!!

I hope you have retained your existing security.fdb safely somewhere,
as the script needs to operate on it. There is a script that you can
run initially to upgrade your old security.fdb to the new
security2.fdb but you must follow the extremely detailed
instructions: merely renaming it won't work.