Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pesq
Starting Member
1 Post |
 Posted - 2007-09-05 : 05:14:09
|
| if one connects to SQL server (2005) with integrated security, does sql server connect to ADS in order to verify the credentials or does windows handle the authentification mechanism ?thanks |
|
|
rcurrey
Starting Member
30 Posts |
Posted - 2007-09-05 : 08:38:15
|
| When you originally authenticate to AD, your session is issued a Ticket Granting Ticket (TGT) by Kerberos. When you then authenticate to SQL, the TGT is passed to SQL Server, which uses the identity attached to it to check its security settings. Based on the permissions in SQL you are then allowed to log in and access resources.Hope this helps.Thanks,Rich |
 |
|
|
|
|
|
Integrated security