Ryan Adams Blog

SQL, Active Directory, Scripting

Browsing Posts in Active Directory

A fellow community member sent me an email saying he was having trouble authenticating with Kerberos.  Here is the error he was receiving: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of […]

I presented for the PASS DBA Virtual Chapter several weeks ago and talked about different ways that Active Directory can affect your SQL Server.  We only had an hour so I had to scale the content back and because of that I had a ton of questions.  I answered what we had time for on […]

It was recently brought to my attention that a post with the script I talk about below could not be found on my blog.  Either I thought I blogged about it and never did or it got lost when I had to change hosting providers late last year.  My apologies for those who have been […]

I am beyond excited to announce that I have been accepted to speak at the annual SQL PASS Summit 2013 in Charlotte, NC.  This will be my first time to speak at this event and I can’t wait!  The session I will be presenting is titled “How Active Directory Affects SQL Server”. I have been […]

A few years ago I had a need to find all accounts in Active Directory that had the “Password Never Expires” option set.  I wrote an HTA with VBScript to make it easy to find these accounts for anyone with little AD experience.  I posted the script in the Microsoft Scripting Guys’ community script repository […]

How Ryan Adams became a DBA and his involvement in the SQL community

Turbo charge your active directory by enabling change notifications

HTA utility to discover, manage, and report AD user last logon times.

Why setting the DNS Suffix Search order via GPO can be dangerous in the enterprise