Friday, March 9, 2012

Linked server between SQL2000 and Active Directory??

Has anyone done this? If so, how do you set it up and query AD. Thanks.
KevinIs this what you want ?
BOL
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\acd
ata.chm::/ac_8_qd_12_94fn.htm
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Kevin Brooks" <jeepnreb@.yahoo.com> wrote in message
news:uHCeR$ucDHA.1044@.TK2MSFTNGP10.phx.gbl...
> Has anyone done this? If so, how do you set it up and query AD.
Thanks.
> Kevin
>|||I have already tried with BOL I am getting this error --
Server: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB
provider 'ADSDSOObject'.
OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare
returned 0x80040e14].
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:Od6DEFvcDHA.2432@.TK2MSFTNGP10.phx.gbl...
> Is this what you want ?
> BOL
>
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\acd
> ata.chm::/ac_8_qd_12_94fn.htm
> --
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Kevin Brooks" <jeepnreb@.yahoo.com> wrote in message
> news:uHCeR$ucDHA.1044@.TK2MSFTNGP10.phx.gbl...
> > Has anyone done this? If so, how do you set it up and query AD.
> Thanks.
> >
> > Kevin
> >
> >
>|||I got it, thanks
"Kevin Brooks" <jeepnreb@.yahoo.com> wrote in message
news:OpL3AKvcDHA.1488@.TK2MSFTNGP12.phx.gbl...
> I have already tried with BOL I am getting this error --
> Server: Msg 7321, Level 16, State 2, Line 1
> An error occurred while preparing a query for execution against OLE DB
> provider 'ADSDSOObject'.
> OLE DB error trace [OLE/DB Provider 'ADSDSOObject'
ICommandPrepare::Prepare
> returned 0x80040e14].
> "Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
> news:Od6DEFvcDHA.2432@.TK2MSFTNGP10.phx.gbl...
> > Is this what you want ?
> >
> > BOL
> >
> >
>
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\acd
> > ata.chm::/ac_8_qd_12_94fn.htm
> >
> > --
> >
> > --
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE,MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> >
> >
> > "Kevin Brooks" <jeepnreb@.yahoo.com> wrote in message
> > news:uHCeR$ucDHA.1044@.TK2MSFTNGP10.phx.gbl...
> > > Has anyone done this? If so, how do you set it up and query AD.
> > Thanks.
> > >
> > > Kevin
> > >
> > >
> >
> >
>

No comments:

Post a Comment