Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikefromokc
Starting Member
4 Posts |
 Posted - 2008-10-14 : 11:11:55
|
| I have been searching the forums for an answer but I cannot find it. What I would like to do is have a SQL table of Active Directory information. We currently have a few tables that have some AD information but I would like to refine the process with one job/connection to query AD and update the table. One of the processes uses a .vbs to export and update the AD table, but it does not import all of the data that I need and it must be ran on a regular basis. After reading the forums it looks like I will need to create a link between the SQL 2005 Server and our Domain Controller. (Is this correct?) Once I complete this what is the best way to import the data from AD in SQL?Thanks in Advance,Mike |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2008-10-15 : 10:32:25
|
| Sounds like you ADO.NET and LDAP connection to import data to SQL. |
 |
|
|
|
|
|
Direct Connection from SQL 2005 to Active Director