I am running MS SQL Server Developer Ed. on Windows XP SP3 in workgroup(non-domained).
Having read in :
"NTLM Authentication: Challenge- Response mechanism.
In the NTLM protocol, the client sends the user name to the server; the server generates and sends a challenge to the client; the client encrypts that challenge using the user’s password; and the client sends a response to the server.If
it is a local user account, server validate user's response by looking into the Security Account Manager; if domain user account, server forward the response to domain controller for validating and retrive group policy of the user account, then construct
an access token and establish a session for the use."
I could not understand:
What happens in the case of "Use Simple File Sharing (Recommended)"
(Windows Explorer --> Tools --> Folder Options --> View --> Use Simple File Sharing-->)?
IS server validate Windows user accounts with passwords in "Windows Authentication" mode?
In other words, is there need to create user accounts for accessing server?
I have never used simple file sharing before...
Is this mode available on server editions of Windowses?
Understanding Kerberos and NTLM authentication in SQL Server Connections
View Complete Post