![]() ![]() You need to provide a domain account which can query AD.ĮXEC _addlinkedserver = N'ADSI', Directory Service Interfaces', _addlinkedsrvlogin _serveroption compatible', _serveroption access', _serveroption _serveroption _serveroption _serveroption out', _serveroption _serveroption timeout', _serveroption name', _serveroption schema validation', _serveroption timeout', _serveroption remote collation', _serveroption proc transaction promotion', highlighted above, you need to change and variables to a login and password that has access to your Active Directory in the second statement. We need to use Active Directory Service Interfaces (ADSI) linked server. Here are the steps to learn how to query active directory data. I have told them that SQL can read that data via linked server. They wanted list of email addresses and phone numbers for all users in the company to be fetched by Active Directory. Once of the classic example was seen during my last visit to a client. There are situations when you need to integrate SQL Server with other product. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |