Authentication of Kerberos to SQL Server

Asked By mildred hawk 20 points N/A Posted on - 01/22/2012

 I want to do authentication of Kerberos to SQL Server. For doing this I have to do delegation. So, I selected ‘The delegation Tab from AD and on the Trust this computed for delegation’. After that, I have selected ‘only use Kerberos’. Then selected ‘add user and apply’ but I got an error message of ‘Access Denied’. Since I am the administrator I don’t know why this error message comes up. Please help me to find the problem. Thanks in advance. Please see the screen shot.

Active Directory

The following Active Directory error occurred: Access denied.

• Status: Open
• Question Views: 1009
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By nathansyam_paul 0 points N/A #91971

Authentication of Kerberos to SQL Server

 

Hello,

First, you must be a member of the domain administrator group or the enterprise administrator group in the active directory or must previously have been delegated the authority to allow the pc to be trusted for delegation. And a Domain Administrator user account cannot do it.

You may go to the security tab and compare settings on other domain controller. It can find out more information.

And try this:- Use member of Enterprise Administrator group to set “allow a computer to be trusted for delegation”

If anything not worked finally try to run it “as an administrator”

Contact me if you can’t understand

About nathansyam_paul

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 01/24/2012
• Question Category: MS SQL Server