Subject RE: [firebird-support] reset sysdba password without loose existing users
Author
Post date 2017-03-24T13:11:56Z
What you'll need to do is to download the firebird embedded edition and unzip it into a folder.  If you are going to try to change the password from the command prompt you'll need to copy the isql.exe file from your original installation into the folder where you unzipped the embedded version.  If you are going to use a tool like flamerobin copy the fbemded.dll to its folder.  I'm not sure but you may need to rename it to fbclient.dll for flamerobin to use it.  If you are using a tool like IBExpert or DBWorkbench then were it ask for the client dll point it to the firebird embeded client.  You'll then be able to connect to the security database and issue the commands to change the password.


---In firebird-support@yahoogroups.com, <Emendez001@...> wrote :

Hi,

 

What the person meant was that if a database is opened using a firebird server process, that process looks for a valid password for the sysdba user. This is the situation you are in now.  

 

But, If you take that Database and open it in embedded mode, meaning that it isn’t using the server process. The Embedded mode only looks for the user to exist. It doesn’t care about the password. Once you connect, you can then issue the appropriate command to change the password.

 

Thanks,

Ed Mendez

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, March 23, 2017 1:05 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] reset sysdba password without loose existing users

 

 

Hi,

Thanks for your reply,

I don't understand what you mean....sorry

As i said, i don't have sysdba password....and i don't want to loose all
existing users account

Regards

-----Message d'origine-----
De : firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Envoyé : jeudi 23 mars 2017 17:29
À : firebird-support@yahoogroups.com
Objet : Re: [firebird-support] reset sysdba password without loose existing
users

23.03.2017 17:27, startx252000@... [firebird-support] wrote:

> Anybody can help me to reset SYSDBA without loose all existing users in
Firebird

Attach in embedded mode with SYSDBA name and you can change the password
with ALTER
USER command.

--
WBR, SD.

------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu
there.

Also search the knowledgebases at
http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links