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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Read AD with SQL

Author  Topic 

Squicky
Starting Member

1 Post

Posted - 2010-08-27 : 15:33:00
Hello

How can read from Active Directory every computer (host name)?

It would be best if this were possible with a select command, so that you could later access the host name with a View (view).

Of course, all servers use Windows 2008, are in a domain and it uses Microsoft SQL 2008th

I have already found the Internet a lot, but still not a simple example that I understood and was able to reproduce.

Thanks for your help.

Sorry for the bad English

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-27 : 15:42:07
Try the solutions from this: http://www.google.com/search?hl=en&q=sql+ldap+active+directory+linked+server&aq=f&aqi=&aql=&oq=&gs_rfai=

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -