Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. EXEC master.dbo.sp_addlinkedserver
  2. @server = N'ADSI'
  3. , @srvproduct=N'Active Directory Services'
  4. , @provider=N'ADsDSOObject'
  5. , @datasrc=N'server_name.your_domain.com'
  6.  
  7. EXEC master.dbo.sp_addlinkedsrvlogin
  8. @rmtsrvname=N'ADSI'
  9. , @useself=N'False'
  10. , @locallogin=NULL
  11. , @rmtuser=N'your_domaindomain_user'
  12. , @rmtpassword='********'
  13.  
  14. SELECT * FROM OPENQUERY (
  15. ADSI,
  16. 'SELECT *
  17. FROM ''LDAP://DC=your_domain,DC=com'''
  18. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement