Help ADDS Synchronize users to SQL

July 16, 2009 1:13 PM

How to make Active Directory and SQL server synchronize User accounts/passwords.

Windows: 2008 ADDS
SQL: 2005

Our bread and butter software requires users to be setup in its database for permissions. It’s a total pain in the ass managing 1200 users in both ADDS and SQL. Many times passwords get out of synch. We are looking for software/method to synchronize ADDS to SQL.
Any ideas?

Thanks!

posted by bleucube to computers & internet (6 answers total)

Isn't this what the integrated authentication in SQL Server is for? You can use AD user accounts in SQL Server directly and not have to worry about synching passwords. Or am I missing something in your question about why that won't work?
posted by FishBike at 1:15 PM on July 16, 2009

Software requires SQL Server Authentication.
posted by bleucube at 1:30 PM on July 16, 2009

I'm sure there are other ways to do this but it sounds like you need Microsoft Identity Integration Server.

Very first hit on Google, by the way.
posted by JaredSeth at 1:36 PM on July 16, 2009

Here's the relevant section of the technet docs.
posted by JaredSeth at 1:38 PM on July 16, 2009

JaredSeth - Thanks! I've reviewed MISS 2003, prior too posting. Just want to see if there were other software/methods solutions.
posted by bleucube at 1:44 PM on July 16, 2009

sounds like you need to file this as a software enhancement/feature request. i know that's not an immediate solution to the pressing problem, just sayin'....
posted by askmehow at 9:40 PM on July 16, 2009