Subject | RE: [firebird-support] Unable to connect to database using SYSDBA & masterkey as password |
---|---|
Author | Alan McDonald |
Post date | 2010-05-13T12:31:59Z |
>You sure?
> Hi,
>
> you're fighting with a trick that's used for disabling SYSDBA
> connection. Simple solution is to replace security database with the
> one
> that is shipped with Firebird and then connect to the database using
> SYSDBA user.
>
> HTH
>
> Milan
the role is on the DB, no amount of changing the security DB will permit
SYSDBA to connect to it.
You need to be able to remove that role in the database before you move it
to your other server.
Alan
>
> Dne 13.05.2010 14:04, Harish napsal(a):
> >
> > I have copied a database to my system from a different server. I dont
> > know the user name & password of that database. I tried to connect to
> > the copied database on my system with user SYSDBA & password as
> > masterkey. It gives following error message.
> >
> > "Your Login SYSDBA is same as one of the SQL role name. Ask your
> > database administrator to setup a valid FireBird Login".
> >
> > Can anybody help me to connect to this database. How can I proceed.
> >