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 |
|
Starlet_GT
Yak Posting Veteran
81 Posts |
 Posted - 2007-10-01 : 06:27:54
|
| In sql server 2005 i want to connect to active directory of exchange server ... there is one option in which we can search outlook but its not fruitful ... please guide ... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-01 : 22:15:55
|
| Exchange server doesn't have separate ADS, you can create linked server to ADS in sql server. |
 |
|
|
Starlet_GT
Yak Posting Veteran
81 Posts |
Posted - 2007-10-02 : 01:15:48
|
| I have linked AD with my sqlserver2005 ... now i need to run query to extract data ... but I am not a system administrator ... how do i know these parameters ... i have copied this query from internet so i am not aware what these lines says ... how can i get actual values to run query ... once i linked active directory then do i need to put these arguments in my query?"''LDAP://ADSISrv/ OU=Sales,DC=sales,DC=northwind,DC=com"SELECT *FROM OPENQUERY( AD, 'SELECT * FROM ''LDAP://ADSISrv/ OU=Sales,DC=sales,DC=northwind,DC=com'' WHERE objectCategory = ''Person'' AND objectClass = ''contact''') |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-02 : 22:56:23
|
| You have to work with your win admin. |
|
|
|
|
|
|
Connection to Exchange Active Directory