asked on

How can I create a Firebird User name and password? I can't connect after install...

I've installed the Firebird-2.1.3.18185 in my Windows 2003 Sever (I've tried superserver, and classic) and I can't connect to any database or firebird application, even using sysdba and masterkey...
For instance:
gsec -user SYSDBA -password masterkey
Result:
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.unable to open database

I've already tried "set isc_user=sysdba" and "set isc_password=masterkey"..

Can anyone help me?
thanks

Nick Upson

sysdba/masterkey are created when the server is installed, you seem to be trying to create it again.

please show your entire connection string,

perebati

ASKER

No, I've just installed, and I was going to change the password of the SYSDBA user... I'm not using any application yet..
But I can't even start GSEC...
gsec -user SYSDBA -password masterkey
should work once I didn't edit any configuration since the installation...

Nick Upson

this is lifted from one of my scripts

gsec -display -user $DBUSER -password $DBPASS
please try it with appropiate substitution

perebati

ASKER

You mean try with sysdba\masterkey right?

gsec -display -user sysdba -password masterkey

I got:

Your user name and password are not defined. Ask your database administrator to
set up a Firebird login.
unable to open database

Nick Upson

yes that's what I meant, looks like a windows permission issue

perebati

ASKER

What kind of windows permission? I don't have much experience with windows... Firewall is disabled..
Does anyone have any other ideas?
Thanks

Nick Upson

permissions like does the user have permission to access the database, another thought did you install as an application or service, did you reboot afterwards?

perebati

ASKER

hi, thanks the help
Well, since I haven't created any users, and I'm in the server machine I believe that sysdba should have enough permissions...
I installed as a service..

Nick Upson

sysdba is the user within the database not the windows username that is trying to access the database
can you check that it is running

perebati

ASKER

I'm using the administrator user.. He has all privileges right?

ASKER CERTIFIED SOLUTION

perebati

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial