Re: Problems Logging into Emerald

Dale E. Reed Jr. ( (no email) )
Wed, 28 May 1997 19:54:11 -0700

Jeffrey Betts wrote:
>
> I restored my database about 2 weeks ago
> ever since then I can only get the user radius
> to log in. The two other users I have keep getting the
> error "bad password" I have recreated these users
> in user manager for domains etc same error. I have
> checked the passwords many times they are correct.

My guess is that you have either permissions or users
mis-configured. Re-run the instperm.sql script on your
database. That should ALWAYS be done after a restore,
to re-instate permissions.

> When I check or try to save the user in emeradmin
> I get this error.
>
> SQL Server error:170 line 1:
> incorrect syntax near '!'. state=1,severity=15

What is the username name?

> When I try to delete the user in emeradmin
> to see if I can recreate it I get this error
>
> SQL Server error:207 invalid column name
> "operator id:state=2, severity=16
>
> Any Help ?

This sounds like one of the older versions of
the Emerald admin that was modifying the Operators table
and not the actual SQL Server users. What version is it?

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com