Subject RE: [firebird-support] 2.01 no default SYSDBA
Author Leyne, Sean
Kyle,

> I am still pursuing this problem on a WIndows 2003 server.
>
> I removed all evidence of a previous FB 1.5 install
> I had previously uninstalled, but now I have deleted the remaining
> Firebird_1_5 folder.
>
> I also uninstalled 2.01, and deleted its folder.
>
> Next I reinstalled 2.01, and everything looked normal. When I run my
> standard create database script via a bat file:
>
> CREATE DATABASE 'd:\db\fb\Data\MyDb\MyDb.fdb' USER 'SYSDBA' PASSWORD
> 'masterke';

Under 2.x the default SYSDBA password is now "masterkey" not "masterke"


> I get an error that the account does not exist:
>
> D:\dbRoot\Projects\SqlScripts\Fb\Bat>
> "c:\Program Files\firebird\firebird_2_0\bin\isql.exe" -user 'SYSDBA'
> -password 'masterkey' -input ..\Create\DbCreate.sql -echo -output
> ..\OutFile\RecreateDatabase.out.txt
> Use CONNECT or CREATE DATABASE to specify a database
> Statement failed, SQLCODE = -902
> Your user name and password are not defined. Ask your database
> administrator to set up a Firebird login.
> After line 0 in file ..\Create\DbCreate.sql

Although you have used the correct SYSDBA password here, the incorrect
password in your script (above) is the source of the failure.


Sean