Help ADDS Synchronize users to SQL
-
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!
-
Answer:
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?
bleucube at Ask.Metafilter.Com Visit the source
Other answers
Software requires SQL Server Authentication.
bleucube
I'm sure there are other ways to do this but it sounds like you need http://technet.microsoft.com/en-us/library/cc853399(WS.10).aspx. Very first hit on Google, by the way.
JaredSeth
http://technet.microsoft.com/en-us/library/cc720671(WS.10).aspx the relevant section of the technet docs.
JaredSeth
JaredSeth - Thanks! I've reviewed MISS 2003, prior too posting. Just want to see if there were other software/methods solutions.
bleucube
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'....
askmehow
Related Q & A:
- How can I optimize this dynamic SQL query in oracle with PL/SQL?Best solution by docs.oracle.com
- Photobucket users...help?Best solution by Yahoo! Answers
- Which are the best trusted sites for earning the money by clicking the adds without any investment?Best solution by Yahoo! Answers
- How do they arrange the adds in-between the footy?Best solution by Yahoo! Answers
- How do I get adds off home page?Best solution by youtube.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.