Subject RE: [firebird-support] 2.01 no default SYSDBA
Author Alan McDonald
> Hello,
>
> 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';

have you tried not putting single quotes around the username and password?
Alan

>
>
> 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
>
>
> Is this a bogus error message? Is there some other problem?
>
> I am running the bat file and script over VPN and Remote Desktop.
>
> This is obvioulsy a showstopper. It was a normal straightforward install
> as far as I can tell.