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