Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 597
  • Last Modified:

How do I change SQL 2005 from using NTLM to start using Kerberos?

How do I change SQL 2005 from using NTLM to start using Kerberos?

This instance is running on Server '03 R2 Enterprise.  I have another instance running on this box that is using Kerberos that was setup at the original install of the instance.  I just don't know how to change it on an established instance.  Also, what problems could this change cause?

Thanks,

Ford
0
FPrefect1
Asked:
FPrefect1
1 Solution
 
simprickCommented:
Hello, It is really a question of the application that is calling the database and the authentication that happens there, if Kerberos is avalable sQL will try to use it as default, it it can't it will fall back on NTLM.  Here is an article on how to configure Kerberos for an IIS Application.

http://support.microsoft.com/kb/319723
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now