mORMot Open Source

larand54

Member

Registered: 2018-12-25

Posts: 120

OSAuthentication in windows on MSSqlServer

I read a post "https://blog.synopse.info/?post/2013/06 … horization"
Where I can read about "Authentication using Windows credentials" but I don't understand how it can be done.

It mentioned that any call to TSQLRestClientURI.SetUser() method with a void aUserName parameter will try to use current logged name and password to perform a secure Client-Server authentication..
What is a void parameter? is it just a blank string as: '' ?

Then there is a prerequisite that  the TSQLAuthUser table shall contain a corresponding entry, with its LogonName column equals to 'DomainNameUserName' value.
But how can this table be queried before the app logged in?

Last edited by larand54 (2025-12-17 20:45:57)

---

Delphi-11, WIN10 and Win11

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 15,346

Website

Re: OSAuthentication in windows on MSSqlServer

A void parameter is just '' indeed.

The table is queried on the server side, as usual for any authentication schemes, once the kerberos authentication is done and it returned the logged user name.
This entry in the DB is needed to have mormot-specific information about the user, mainly the associated group for actual activation.

larand54

Member

Registered: 2018-12-25

Posts: 120

Re: OSAuthentication in windows on MSSqlServer

Ok, I fixed things after I looked back into an old article by Stephan-Bester. He noted that you just need to set the Username to '' (void parameter) to make login possible without user and password.
So now I can relax without urgent need to move my old mormot1 projects to mormot2. Allthough it migtht happen later on.

---

Delphi-11, WIN10 and Win11