Please post the error message you receive. Might be a rights issue. Are you on the right domain?

It would help to see the code you are using to create the link server. I use the following:

EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',

'ADSDSOObject', 'adsdatasource'

GO

You can then create a view to the AD data like:

CREATE VIEW [vADUsers] AS

SELECT samAccountName AS TM_Number

,displayName AS Workstation_User

,Department

FROM OPENQUERY(ADSI, '

SELECT samAccountName, displayName, Department

FROM ''LDAP://DC=<DOMAIN NAME>,DC=<DOMAIN NAME>,DC=COM''

WHERE objectClass=''user'' AND objectClass<>''computer''

')

You may only need one DC entry for the name and the last DC might be NET or COM - depends on your domain name.

To test you can run a query against the linked server, like:

SELECT samAccountName As WinNT_ID

,displayName AS Display_Name

FROM OPENQUERY(ADSI, '

SELECT samAccountName

,displayName

FROM ''LDAP://DC=<DOMAIN NAME,DC=<DOMAIN NAME,DC=net''

WHERE objectClass=''user'' AND objectClass<>''computer''

') AS tblADSI

WHERE samAccountName LIKE 'XYZ%'

Order by samAccountName

Hope this helps