Fix HTTP digest authentication

SecurityService needs to use the configured realm instead of always "SQLLayer".

Additionally, change the default realm to SQLLayer in-case anyone already has users created.