I have MS SQL 2012 installed on a W2K8 (64bit) server. I have a 'view' that queries Active Directory Users. I've attached the LinkServer setup and the OpenQuery view.
The view works fine when it is issued from the same server that the database is on. When I try to run it from another server I get an error. Here is the SQL statement I'm using:
select * from dbo.uvw_ActiveDirectoryUse
Here is the error I get:
Msg 7320, Level 16, State 2, Line 2
Cannot execute the query "SELECT samaccountname,
FROM 'LDAP://OU=WCC Users,DC=wcc,DC=net'
WHERE objectCategory = 'Person' AND
objectClass = 'user'" against OLE DB provider "ADSDSOObject" for linked server "ADSI".
I have tried this using SSMS to connect remotely and from an application on a server that has only the SQL 2012 Native Client installed. I need to be able to run this query from an application server that has just the SQL 2012 Native Client installed, if possible.
BTW, I have domain admin privileges.
What am I missing?
Thanks in advance