Subject Re: [firebird-support] reset sysdba password without loose existing users
Author Thomas Steinmaurer
> Hi all,
>
> I need more help to archive this task.
>
>
> I just copied the file flembed.dll and others in my directory(bin)
> now i can connect to my database, with gsec or isql
>
>
> but when i try to change de sysdba password in commande line, i got this
> message :
>
>
> SQL> alter user sysdba password 'mypassword'
> Statement failed, SQLSTATE = 0A000
> feature is not supported
>
>
> Maybe i missed somthing, thanks for your help

Are you sure that you are connecting via the embedded DLL and not a regular Firebird server process?

I have seen several environments where there have been Firebird Windows Services running in parallel and a faulty connect string pretty much resulted in using the wrong Firebird server. So, for your case, make sure that no other Firebird server is running, e.g. explicitly stopping them in the Windows services panel, in case you are on Windows.



--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.