Subject | 2.01 no default SYSDBA |
---|---|
Author | Kyle Green |
Post date | 2007-05-23T20:26:16Z |
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';
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.
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';
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.