Import or add Active Directory users into SQL2000 ?

Is there any way to import or add Active Directory users into a SQL2000
Database ?
Hi
You can query active directory through ADSI, but I think you would be better
off creating a windows group and add the users to that group as part of your
user creation process.
John
"tptools" wrote:

> Is there any way to import or add Active Directory users into a SQL2000
> Database ?

Import or add Active Directory users into SQL2000 ?

Is there any way possible to import or add Active Directory users into a
SQL2000 database ?
maybe Something like this would help u
EXEC sp_addlinkedserver
'ADSI',
'Active Directory Services 2.5',
'ADSDSOObject',
'adsdatasource'
GO
go
sp_addlinkedSrvlogin 'ADSI',false, 'sa','USERNAME','PASSWORD'
go
select * from openquery(ADSI,'select GUID from
''LDAP://192.168.33.11:1003/o=e-enterprise/ou=members'' ')
"tptools" <tptools@.discussions.microsoft.com> wrote in message
news:4524D5FA-0115-4707-8674-9463C36E672C@.microsoft.com...
> Is there any way possible to import or add Active Directory users into a
> SQL2000 database ?

Import or add Active Directory users into SQL2000 ?

Is there any way possible to import or add Active Directory users into a
SQL2000 database ?maybe Something like this would help u
EXEC sp_addlinkedserver
'ADSI',
'Active Directory Services 2.5',
'ADSDSOObject',
'adsdatasource'
GO
go
sp_addlinkedSrvlogin 'ADSI',false, 'sa','USERNAME','PASSWORD'
go
select * from openquery(ADSI,'select GUID from
''LDAP://192.168.33.11:1003/o=e-enterprise/ou=members'' ')
"tptools" <tptools@.discussions.microsoft.com> wrote in message
news:4524D5FA-0115-4707-8674-9463C36E672C@.microsoft.com...
> Is there any way possible to import or add Active Directory users into a
> SQL2000 database ?

Import or add Active Directory users into SQL2000 ?

Is there any way to import or add Active Directory users into a SQL2000
Database ?Hi
You can query active directory through ADSI, but I think you would be better
off creating a windows group and add the users to that group as part of your
user creation process.
John
"tptools" wrote:

> Is there any way to import or add Active Directory users into a SQL2000
> Database ?sql

Import or add Active Directory users into SQL2000 ?

Is there any way possible to import or add Active Directory users into a
SQL2000 database ?maybe Something like this would help u
EXEC sp_addlinkedserver
'ADSI',
'Active Directory Services 2.5',
'ADSDSOObject',
'adsdatasource'
GO
go
sp_addlinkedSrvlogin 'ADSI',false, 'sa','USERNAME','PASSWORD'
go
select * from openquery(ADSI,'select GUID from
''LDAP://192.168.33.11:1003/o=e-enterprise/ou=members'' ')
"tptools" <tptools@.discussions.microsoft.com> wrote in message
news:4524D5FA-0115-4707-8674-9463C36E672C@.microsoft.com...
> Is there any way possible to import or add Active Directory users into a
> SQL2000 database ?

Import or add Active Directory users into SQL2000 ?

Is there any way to import or add Active Directory users into a SQL2000
Database ?Hi
You can query active directory through ADSI, but I think you would be better
off creating a windows group and add the users to that group as part of your
user creation process.
John
"tptools" wrote:
> Is there any way to import or add Active Directory users into a SQL2000
> Database ?

Import data from Active Directory

Is there a way to import data from Active Directory using Data
Transformation Service (or maybe using other way) to SQL Server? I want to
import their username, first/last name, title, phone, etc.. and schedule
the import every night.
Any suggestions?http://www.windowsitpro.com/Article...4328/14328.html
--
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Zean Smith" wrote:

> Is there a way to import data from Active Directory using Data
> Transformation Service (or maybe using other way) to SQL Server? I want t
o
> import their username, first/last name, title, phone, etc.. and schedule
> the import every night.
> Any suggestions?
>
>

Import data from Active Directory

Is there a way to import data from Active Directory using Data
Transformation Service (or maybe using other way) to SQL Server? I want to
import their username, first/last name, title, phone, etc.. and schedule
the import every night.
Any suggestions?http://www.windowsitpro.com/Article/ArticleID/14328/14328.html
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Zean Smith" wrote:
> Is there a way to import data from Active Directory using Data
> Transformation Service (or maybe using other way) to SQL Server? I want to
> import their username, first/last name, title, phone, etc.. and schedule
> the import every night.
> Any suggestions?
>
>

Import data from Active Directory

Is there a way to import data from Active Directory using Data
Transformation Service (or maybe using other way) to SQL Server? I want to
import their username, first/last name, title, phone, etc.. and schedule
the import every night.
Any suggestions?
http://www.windowsitpro.com/Article/...328/14328.html
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Zean Smith" wrote:

> Is there a way to import data from Active Directory using Data
> Transformation Service (or maybe using other way) to SQL Server? I want to
> import their username, first/last name, title, phone, etc.. and schedule
> the import every night.
> Any suggestions?
>
>