Access Windows Authentication

[Bella]

We use the corporate edition of EA and the user authentication for the SQL server has been switched of by one of the Administrators (i suspect) accidently.  As a result no one can access the EADB .  We don’t have a supper user setup in EA (although on the server but this is useless ) that can access the DBwithout windows authentication.  Can anyone provide me with the SQL script to update the flag on the DB?

[Geert Bellekens]

Bella,

I'm not getting the problem. What did the Admin turn off exactly? And why can't he just turn it on again?
And which flag are you looking for to enable/disable?
Anyway, anything related to users in EA is stored in the tables
t_secuser, t_secpermission, t_sec...

t_secpolicies might be interesting as you can turn UserSecurity off there.

Geert

[Bella]

Thanx Geert

Problem where the DB admin don't have access to the front end and they don't understand the EA Base DB structure i.e. the tables you mentioned.  However I where able to access the front end and switch on the Accept Windows Authentication check box again by getting access to the SQL DB first & thereafter accessing the front end with a password. All is well now.  Any idea where one can find a data dictionary of the EA SQL Base?

[Geert Bellekens]

There is no such thing, but I suspect that

Code: [Select]

update t_secpolicies set value = 'Disabled'
where Property = 'UserSecurity' will turn user security off completely.
This allows you to login to EA without user login.

Geert