On 7-7-2014 15:43, LtColRDSChauhan wrote: > Hi, > > 1. I attempted to migrate from Firebird 3.0 Alpha 1 to Alpha 2. After > a backup / restore I'm not able to connect to the database using .NET > Provider. I've the following updated in the Firebird Config file : > > UserManager = Legacy_UserManager > > AuthClient = Srp, Win_Sspi, Legacy_Auth > > > 2. FlameRobin connects fine. > > 3. Please help.
When you install Firebird 3 - unless you already enabled legacy authentication in the installer - you will only have a user account in the new SRP authentication model. As you edited the firebird.conf later, you currently do not have a legacy authentication user. To fix this, you need to 1) Edit firebird.conf again and 1a)set the UserManager to Legacy_UserManager: UserManager = Legacy_UserManager 1b) Set WireCrypt to Enabled (instead of Required), or even Disabled so that the server doesn't require encryption WireCrypt = Enabled 2) Restart Firebird (not 100% sure if necessary) 3) Next you need to create another SYSDBA account (using gsec) so it also exists as a legacy user. I am not 100% sure if you only need to do "gsec -user sysdba -password masterkey", or that you explicitly need to do "add sysdba -pw masterke" from the gsec prompt. The reason Flamerobin works is that it uses the Firebird 3 fbclient.dll, so it automatically supports the new authentication model and encryption. Mark -- Mark Rotteveel ------------------------------------------------------------------------------ Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider