Error while linking server to Active Directory service

I need to retrieve information from LDAP in SQL Server 2000.
I have installed SQL Server 2000 on a machine with Windows XP Professional
(SP2).
When I execute this script inside Query Analyzer:
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
'ADSDSOObject', 'adsdatasource'
GO
and then I open tables or views of linked server this error appears:
"Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject'
a necessary interface..."
Can I solve this issue?
Where I can find a good documentation about SQL Server 2000 and LDAP?
Many thanksI read that I can ignore this problem (it's normal!),
but I have another error.
I run SQL Server service with my domain account, I add my SQL Server istance
to Active directory inside Enterprise Manager, I create the linked server how
documented with access by my domain account.
Finally, I execute this query in Query Analyzer:
SELECT * FROM OpenQuery( ADSI, 'SELECT *
FROM "LDAP://" ')
having this error:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
returned 0x80040e14]
Any suggests to solve this issue?
> I need to retrieve information from LDAP in SQL Server 2000.
> I have installed SQL Server 2000 on a machine with Windows XP Professional
> (SP2).
> When I execute this script inside Query Analyzer:
> EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> 'ADSDSOObject', 'adsdatasource'
> GO
> and then I open tables or views of linked server this error appears:
> "Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject'
> a necessary interface..."
> Can I solve this issue?
> Where I can find a good documentation about SQL Server 2000 and LDAP?
> Many thanks
>|||The right error message is:
Message 7321, Level 16, State 2, Row 1
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' ICommandPrepare::Prepare
returned 0x80040e14].
Sorry!
> I read that I can ignore this problem (it's normal!),
> but I have another error.
> I run SQL Server service with my domain account, I add my SQL Server istance
> to Active directory inside Enterprise Manager, I create the linked server how
> documented with access by my domain account.
> Finally, I execute this query in Query Analyzer:
> SELECT * FROM OpenQuery( ADSI, 'SELECT *
> FROM "LDAP://" ')
> having this error:
> Message 7321, Level 16, State 2, Row 1
> OLE DB error trace [OLE/DB Provider 'MSOLAP' ICommandPrepare::Prepare
> returned 0x80040e14]
> Any suggests to solve this issue?
>
> > I need to retrieve information from LDAP in SQL Server 2000.
> > I have installed SQL Server 2000 on a machine with Windows XP Professional
> > (SP2).
> > When I execute this script inside Query Analyzer:
> > EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
> > 'ADSDSOObject', 'adsdatasource'
> > GO
> > and then I open tables or views of linked server this error appears:
> > "Error 7301: It is impossible to obtain from OLE DB provider 'ADSDSOObject'
> > a necessary interface..."
> >
> > Can I solve this issue?
> > Where I can find a good documentation about SQL Server 2000 and LDAP?
> >
> > Many thanks
> >

Error while Installing SQL Server evaluation version - sqlunirl.dll not found

Hi

When I attempt to install MS SQL Server evaluation copy (downloaded
from Microsoft site) on Windows 2K Professional getting following
error.

Setup initialization error.
The system cannot find the path specified.

Source file or directory missing or cannot be read:
'C:\SQLEVAL\x86\setup..\System\sqlunirl.dll'

Please help.

Regards,
AGajay_gupta@.consultant.com (ag) wrote in message news:<8125681d.0312112140.4b69e1bd@.posting.google.com>...
> Hi
> When I attempt to install MS SQL Server evaluation copy (downloaded
> from Microsoft site) on Windows 2K Professional getting following
> error.
> Setup initialization error.
> The system cannot find the path specified.
> Source file or directory missing or cannot be read:
> 'C:\SQLEVAL\x86\setup..\System\sqlunirl.dll'
> Please help.
> Regards,
> AG

I will download the missing dll and give it another try

Michael Tubuo Ngong