MSSQL -- Active Directory details

Posted on 2013-01-25
Medium Priority
Last Modified: 2013-02-07
How can I do something like the below in MSSQL to get Active Directory details ?

from AD
and substr(AD_GROUP_NAME,1,2) = 'PS'
Question by:finance_teacher
LVL 82

Assisted Solution

arnold earned 1000 total points
ID: 38821647
LVL 52

Accepted Solution

Mark Wills earned 1000 total points
ID: 38821711
There are a number of ways to do it...

Please see the MS KB Article : http://support.microsoft.com/kb/299410

Now, you can easily get into a bit of trouble with permissions and having access. So, make sure your SQl Server Service account (ie the account used to start the service) does have the appropriate permissions and not just "local"

Have a look at the last page of : http://www.sqlservercentral.com/Forums/Topic259587-8-3.aspx

Also, I used to use LDAP Browser to help with queries and find out schema etc - since upgraded to the paid for administrator : http://www.ldapbrowser.com/download.htm You might find it useful to resolve connections etc.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

High user turnover can cause old/redundant user data to consume valuable space. UserResourceCleanup was developed to address this by automatically deleting user folders when the user account is deleted.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question