Subject | Windows security problems. |
---|---|
Author | Driver, David |
Post date | 2004-10-27T01:15:07Z |
I am new to FB and I like it very much. I have a problem on my XP Pro
computer's install. I am not currently a member of a domain if that makes an
difference.
I tested out the suitability of FB for my purposes without taking pains to
secure the login or change the sysdba password. I wrote a batch file that
looks like:
"C:\Program Files\Firebird\Firebird_1_5\bin\isql.exe" -m "c:\asv.fdb" -u
"sysdba" -pas "masterkey"
To quickly get into the database so I could mess around some. After I had
decided that firebird would be ok for my purposes I read the file:
C:\Program Files\Firebird\Firebird_1_5\doc\README.NTSecurity
And then I created the logon "firebird" as an unprivileged user and changed
the log on for the firebird service and the guardian. They both restarted
fine after changing the login. I then added full control for firebird user
to the file "c:\asv.fdb" and I also added full control to the directory
"C:\Program Files\Firebird\"
When I thought that I had done beyond what the read me file had specified, I
ran the batch file mentioned above and I received the error:
C:\Documents and Settings\David\Desktop>"C:\Program
Files\Firebird\Firebird_1_5\
bin\isql.exe" -m "c:\asv.fdb" -u "sysdba" -pas "masterkey"
Statement failed, SQLCODE = -904
unavailable database
Use CONNECT or CREATE DATABASE to specify a database
SQL>
At this time I reset the services to gun under the system account again and
tried the script with the same results. I have no clue what I have missed or
what I did wrong. Should I uninstall FB and reinstall it? I really did enjoy
the time I spent with FB and kinterbasdp/python. This is just sort of left
me scratching my head.
Any help is appreciated at this point.
computer's install. I am not currently a member of a domain if that makes an
difference.
I tested out the suitability of FB for my purposes without taking pains to
secure the login or change the sysdba password. I wrote a batch file that
looks like:
"C:\Program Files\Firebird\Firebird_1_5\bin\isql.exe" -m "c:\asv.fdb" -u
"sysdba" -pas "masterkey"
To quickly get into the database so I could mess around some. After I had
decided that firebird would be ok for my purposes I read the file:
C:\Program Files\Firebird\Firebird_1_5\doc\README.NTSecurity
And then I created the logon "firebird" as an unprivileged user and changed
the log on for the firebird service and the guardian. They both restarted
fine after changing the login. I then added full control for firebird user
to the file "c:\asv.fdb" and I also added full control to the directory
"C:\Program Files\Firebird\"
When I thought that I had done beyond what the read me file had specified, I
ran the batch file mentioned above and I received the error:
C:\Documents and Settings\David\Desktop>"C:\Program
Files\Firebird\Firebird_1_5\
bin\isql.exe" -m "c:\asv.fdb" -u "sysdba" -pas "masterkey"
Statement failed, SQLCODE = -904
unavailable database
Use CONNECT or CREATE DATABASE to specify a database
SQL>
At this time I reset the services to gun under the system account again and
tried the script with the same results. I have no clue what I have missed or
what I did wrong. Should I uninstall FB and reinstall it? I really did enjoy
the time I spent with FB and kinterbasdp/python. This is just sort of left
me scratching my head.
Any help is appreciated at this point.