How to force usage on NTLM

From: Ron (ron.bennatan_at_gmail.com)
Date: 03/25/05

Next message: Peter Yang [MSFT]: "Re: Web and SQL Security"
Previous message: ron.bennatan_at_gmail.com: "How to (completely) turn off protocol encryption in SQL Server? (the checkbox in server network utility is unchecked)"
Next in thread: Kevin McDonnell [MSFT]: "RE: How to force usage on NTLM"
Reply: Kevin McDonnell [MSFT]: "RE: How to force usage on NTLM"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: 24 Mar 2005 15:06:33 -0800

Hi,

By default Windows authentication will use Kerberos to do the
authentication. Is there a way to force a SQL Server instance to use
NTLM rather than Kerberos - as a server setting?

Thanks,
-Ron

Next message: Peter Yang [MSFT]: "Re: Web and SQL Security"
Previous message: ron.bennatan_at_gmail.com: "How to (completely) turn off protocol encryption in SQL Server? (the checkbox in server network utility is unchecked)"
Next in thread: Kevin McDonnell [MSFT]: "RE: How to force usage on NTLM"
Reply: Kevin McDonnell [MSFT]: "RE: How to force usage on NTLM"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: External Access to IIS via Kerberos Authentication
... Integrated Windows Authentication encompasses two authentication ... Kerberos also requires that the client machine be a member of the forest. ... If users are connecting from non-member machines, only NTLM is used. ...
(microsoft.public.inetserver.iis.security)
Re: Data Refresh Failed - Office 2007- Excel services
... You need Kerberos or SSO. ... having exactly the same problem and am trying to use Windows authentication. ... Is it really the case that you have to use SSO to get this to work? ... few months back with an ASP.net app i was writing to communicate with a SQL ...
(microsoft.public.sharepoint.portalserver)