Turned Off Windows Security and now model is unaccessible

[gbolton]

I accidentally turned off windows authentication and now no one can access the model.  I believe I need to login as admin but the login as another user option is not activated because I am not in the model.  Any suggestion on how I can turn Windows Authentication back on or bypass it?  I get the user authentication screen but I don't know what password EA thinks is setup for me.  The repository is setup by procloud but even connecting directly to the database (SQL Server) repository gives me the same authentication challenge.  How can I get into the model to turn Windows Authentication back on?

[Geert Bellekens]

Use an SQL client to open your model and execute the following SQL

Code: [Select]

update t_secpolicies set [Value] = 'Disabled' where Property = 'UserSecurity'
This disables security alltogether.

Geert

[gbolton]

Do you have a sql statement that will just let me turn on Windows Authentication globally?

[qwerty]

IIRC you just replace "Dis" with "En" and you have it restored. But then you're probably at square 1 too, right?

q.

[Geert Bellekens]

Do you have a sql statement that will just let me turn on Windows Authentication globally?

Don't do anything more with SQL then absolutely necesarry.

If you disable security, you can open the model yourself, and set the options using the GUI.

Geert

[gbolton]

I ran the SQL and renabled security including windows authentication.  Users are able to get into the model either through a cloud connection or connect to server in EA or through WebEA.