Subject | Re: [firebird-support] How can I connect to Firebird server from account without administrative privileges? |
---|---|
Author | Helen Borrie |
Post date | 2007-10-02T22:54:07Z |
At 01:10 AM 3/10/2007, you wrote:
client. If so, you need to include the -database switch and provide
the full network address of the security database, e.g., for Fb 2:
gsec -database ourserver:c:\Program
Files\Firebird\Firebird_2_0\security2.fdb -user sysdba -password masterkey
network path to the database. For isql there is no special switch.
'isql "ourserver:C:\Data\DB.FDB" -user SYSDBA -password masterkey'
There are other possible explanations for your problems but you
haven't provided any information about server version (that means the
numbers after the word "Firebird" on the kit you installed), model
(Superserver/Classic/Embedded) or the version of Windows you are running.
./heLen
>I'm trying to use gsec and isql from command line window (cmd);It appears that your command shell client is a remote desktop
> when I run "gsec -user SYSDBA -password masterkey" I get "Cannot
> attach to services manager; unable to open database"
client. If so, you need to include the -database switch and provide
the full network address of the security database, e.g., for Fb 2:
gsec -database ourserver:c:\Program
Files\Firebird\Firebird_2_0\security2.fdb -user sysdba -password masterkey
>when I run 'isql "C:\Data\DB.FDB" -user SYSDBA -password masterkey'Similar solution - a remote desktop client needs to supply the full
> I get
> Statement failed, SQLCODE = -904
>unavailable database
>Use CONNECT or CREATE DATABASE to specify a database
network path to the database. For isql there is no special switch.
'isql "ourserver:C:\Data\DB.FDB" -user SYSDBA -password masterkey'
> From administrator account there is no problem.Your administrator account runs in a local shell?
There are other possible explanations for your problems but you
haven't provided any information about server version (that means the
numbers after the word "Firebird" on the kit you installed), model
(Superserver/Classic/Embedded) or the version of Windows you are running.
./heLen