Hello! I've enabled SSO and locked us out of our Atlassian.. Can anyone help? :)

Question

Hi,

I misclicked and activated the SSO while setting it up, and now we can't sign in. 
Can anybody help?

Tom Lister_fo1j4e · Answer

This might also be worth a look.

https://confluence.atlassian.com/jirakb/bypass-saml-authentication-for-jira-data-center-869009810.html

Tom Lister_fo1j4e · Answer

You can try to set the sos off and use and Internal user if you have one

select * from propertyentry pe join propertystring ps on pe.id = ps.id
                  where Lower(pe.property_key) like '%sso%'

update propertystring
                  set propertyvalue = 'false'
                  where id = (select id from propertyentry where property_key = 'com.atlassian.plugins.authentication.sso.config.redirect-on-login')

Patrick Joerg · Answer

Hi, you should hve a jira_local_admin User which i always local and always present.

If you don't I dought there is a way. If you have access to the server maybe...