The regional settings were different. It worked after I changed the settings.
Dale E. Reed Jr. wrote:
> Annabel Mwansa wrote:
> > I just recreated the Emerald Database on our server. We are using Emerald
> > 2.2.38. The steps I followed were as follows:
> > 1. Delete Database using Emerald Admin
> > 2. Create the Database using Emerald Admin
> > 3. Ran radiusnt.sql against the emerald database
> > 4. Ran rad25_up2.sql
> > 5. Ran consol.sql
> > Everything works very well when emerald is run from the server. I tried to
> > run it from the client computers but it keeps coming back with 'SQL Error
> > adding main account', 'Sql command failed' to name a few.
> > It won't allow transactions to be done on the client computers.
> Are you logging in as "SA" from the client computer or a normal
> user account? What is the date format in the control panel
> regional settings of each computer?
> Dale E. Reed Jr. (email@example.com)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com