Help ADDS Synchronize users to SQL
July 16, 2009 1:13 PM   Subscribe

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


« Older GardenFilter. What insect will...   |  Safe to eat filter: I've had ... Newer »
This thread is closed to new comments.