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 |
|
puja
Starting Member
18 Posts |
 Posted - 2004-04-21 : 14:43:51
|
| Does anyone know how to migrate the Active Directory to SQl 2000and query users from AD?i have never done it and would like someone help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-21 : 14:49:25
|
| Well you don't migrate AD to SQL Server 2000. So please explain further what you mean. Do you mean add users to SQL Server 2000 that are Windows users in the AD? If so, you add them with sp_grantlogin.To query users from AD, you'll need to call the ADS APIs.Tara |
 |
|
|
puja
Starting Member
18 Posts |
Posted - 2004-04-21 : 15:12:33
|
| I mean that how do get all the active users from AD using SQL Query?hope this helps. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-21 : 16:21:00
|
| Are the users part of a Windows group? If so, you can just add the group to SQL Server.Tara |
|
|
|
puja
Starting Member
18 Posts |
Posted - 2004-04-21 : 17:14:06
|
| Hello Tara, Thanks for all the help. I am trying to obain all the users from Active Directory 2000 using SQL 2000.How do i link the AD server? By reading the referenc article, i search that sp_addlinkedserver 'ADSI', 'Active Directory service Interface','ADSDSOObject','adsdatasource'to add link server.Since i have never use the AD with SQL 2000, i would like to use it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-21 : 17:56:48
|
| Could you post the link to the article?Tara |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
|
|
puja
Starting Member
18 Posts |
Posted - 2004-04-22 : 10:12:44
|
| HI, Actually, i found it from some other link. I am reading this article and some of its links does not have the information.After i link the server,how do I obtain all the users from AD? |
|
|
|
|
|
|
|
|
SQL 2000 with AD