Thanks,

But I only recently changed the script to 'masterke' just on that one
script to try to make things work. I just changed it back to verify.

The error is exactly the same either way.

Any other ideas?

Thanks,

Kyle

----- Original Message -----
Subject: RE: [firebird-support] 2.01 no default SYSDBA
From: "Leyne, Sean" <Sean@...>
Date: Wed, May 23, 2007 13:39







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\Recreate
Database.
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