How can I query a trusted domain (from MS SQL)?

[Ammar]

I've defined a linked ADSI server and I seem to be able to query the
local domain ( localdomain.com ) with:

DBCC TRACEON(7300)
GO
SELECT * FROM OPENQUERY(ADSI, 'SELECT displayName FROM
''LDAP://DC=localdomain, DC=com'' ')

But I also have a trusted domain ( trusteddomain.c om ) which I would
also like to query from the same SQL-enviroment but this does not work
:( :

DBCC TRACEON(7300)
GO
SELECT * FROM OPENQUERY(ADSI, 'SELECT displayName FROM
''LDAP://DC=trusteddomai n,DC=com'' ')

Error returned:
"OLE DB error trace [Non-interface error: OLE DB provider
ADSDSOObject returned DBPROP_STRUCTUR EDSTORAGE without
DBPROPVAL_OO_BL OB being supported].
OLE DB error trace [OLE/DB Provider 'ADSDSOObject'
IRowset::GetNex tRows returned 0x8007202b]."

What am I doing wrong? From within windows-explorer I have no problem
obtaining the userlist from trusted domain when I want to assign
file-permissions.
Any idea?

[Arild Bakken]

Write a VB script with the following:

Set objRoot = GetObject(LDAP://dc=trusteddomai n,DC=com)
WScript.Echo objRoot.Name

and run it on the SQL server. IF this does not work, then a linked ADSI
server won't work either. I've never used trusted domains in W2K, but check
DNS settings. The client needs to find a domaincontrolle r for the given
domain. Also, you could try adding the domaincontrolle r of the trusted
domain to your query:

LDAP://nameofdcintrust eddomain/dc=trusteddomai n,dc=com
Arild

"Ammar" <am********@vip .hr> wrote in message
news:64******** *************** **@posting.goog le.com...

I've defined a linked ADSI server and I seem to be able to query the
local domain ( localdomain.com ) with:

DBCC TRACEON(7300)
GO
SELECT * FROM OPENQUERY(ADSI, 'SELECT displayName FROM
''LDAP://DC=localdomain, DC=com'' ')

But I also have a trusted domain ( trusteddomain.c om ) which I would
also like to query from the same SQL-enviroment but this does not work
:( :

DBCC TRACEON(7300)
GO
SELECT * FROM OPENQUERY(ADSI, 'SELECT displayName FROM
''LDAP://DC=trusteddomai n,DC=com'' ')

Error returned:
"OLE DB error trace [Non-interface error: OLE DB provider
ADSDSOObject returned DBPROP_STRUCTUR EDSTORAGE without
DBPROPVAL_OO_BL OB being supported].
OLE DB error trace [OLE/DB Provider 'ADSDSOObject'
IRowset::GetNex tRows returned 0x8007202b]."

What am I doing wrong? From within windows-explorer I have no problem
obtaining the userlist from trusted domain when I want to assign
file-permissions.
Any idea?

[Arild Bakken]

If should of course be:

Set objRoot.GetObje ct("LDAP://dc=trusteddomai n,DC=com")

(Outlook Express is a bit too _smart_ )
Arild

"Arild Bakken" <ar*****@hotmai l.com> wrote in message
news:O2******** *******@tk2msft ngp13.phx.gbl.. .

Write a VB script with the following:

Set objRoot = GetObject(LDAP://dc=trusteddomai n,DC=com)
WScript.Echo objRoot.Name

and run it on the SQL server. IF this does not work, then a linked ADSI
server won't work either. I've never used trusted domains in W2K, but check DNS settings. The client needs to find a domaincontrolle r for the given
domain. Also, you could try adding the domaincontrolle r of the trusted
domain to your query:

LDAP://nameofdcintrust eddomain/dc=trusteddomai n,dc=com
Arild

"Ammar" <am********@vip .hr> wrote in message
news:64******** *************** **@posting.goog le.com...

I've defined a linked ADSI server and I seem to be able to query the
local domain ( localdomain.com ) with:

DBCC TRACEON(7300)
GO
SELECT * FROM OPENQUERY(ADSI, 'SELECT displayName FROM
''LDAP://DC=localdomain, DC=com'' ')

But I also have a trusted domain ( trusteddomain.c om ) which I would
also like to query from the same SQL-enviroment but this does not work
:( :

DBCC TRACEON(7300)
GO
SELECT * FROM OPENQUERY(ADSI, 'SELECT displayName FROM
''LDAP://DC=trusteddomai n,DC=com'' ')

Error returned:
"OLE DB error trace [Non-interface error: OLE DB provider
ADSDSOObject returned DBPROP_STRUCTUR EDSTORAGE without
DBPROPVAL_OO_BL OB being supported].
OLE DB error trace [OLE/DB Provider 'ADSDSOObject'
IRowset::GetNex tRows returned 0x8007202b]."

What am I doing wrong? From within windows-explorer I have no problem
obtaining the userlist from trusted domain when I want to assign
file-permissions.
Any idea?