setup kerberos authentication for SQL Server 2000

Hi,

I need some help to setup Kerberos Authentication for SQL Server
2000. I believe by default Window authentication in SQL Server is
Kerberos. But I don't know enough and have not come across any
documentation that confirm this. I believe if both the server and
client are on the same domain, when the client workstation connect to
the server using windows security, this is consider kerberos. Is this
true? Have any done this? Or is there a query that I can run to
confirm what authentication I am using, like Kerberos?

My workstation and server are both Windows 2000 and I believe by
default the kerberos support on windows are enable. My SQL Server is
startup using local system account.

If you know of any documentation that show how to setup Kerberos
authentication on SQL Server 2000 or know that my knowlege is true,
please let me. I would greatly apprecaite it.



Thanks

Lousi.

.

Relevant Pages

  • Re: Change in ASP.Net authentication between Win2000 and Win2003
    ... > is turning on/off Kerberos is occuring. ... It control how IE deals with "Authentication: ... when you put IIS6 in a domain and have "Integrated Windows Authentication" ...
    (microsoft.public.windows.server.security)
  • Re: Change in ASP.Net authentication between Win2000 and Win2003
    ... > is turning on/off Kerberos is occuring. ... It control how IE deals with "Authentication: ... when you put IIS6 in a domain and have "Integrated Windows Authentication" ...
    (microsoft.public.inetserver.iis.security)
  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Integrated Authentication with SQL
    ... On the IIS level there is no trouble authenticating with kerberos. ... problem is in when I try to flow those credentials over to the SQL server. ... Successful Network Logon: ... Authentication Package: Kerberos ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)