T-SQL

Re: interogare useri din Active Directory

Alex — Thu, 16 Aug 2007 14:14:00 GMT

f buna aplicatie.....ma ajuta mult....

mersi mult

alex.

Re: interogare useri din Active Directory

crestinul — Wed, 15 Aug 2007 13:21:04 GMT

problerma e ca activ e dir nu e un flat database e o baza de date ldap si tb sa folosesti ldap queryes pt a o interoga nush daca poti face asta din vreun cleint de mssql,in afara de faptukl ca tb sa cunosti ldap sintax

Re: interogare useri din Active Directory

B_gd_n[ ]Sahlean — Wed, 15 Aug 2007 11:46:11 GMT

Incearca aici: SQL Server: how to link different data sources together

Poate te ajuta asta:

"Link Microsoft SQL Server to a directory

You can link SQL Server to a directory like Active Directory or Active Directory Application Mode. Create a linked server in the Enterprise Manager and give it a descriptive name like "Active Directory Link". Choose the option "Other data source" and select the data provider "OLE DB Provider for Microsoft Directory Services". As product name enter "Active Directory Services" and as data source enter "adsdatasource". When you expand the new linked server you will find two available items - Tables and Views. So SQL Server allows you to view any tables or views in this data source. But the data provider "OLE DB Provider for Microsoft Directory Services" does not provide either the tables or views. Therefore you will get the error "Error 7301: Could not obtain a required interface from OLEDB provider ADsDSOObject". You can safely ignore the error message. You will be able to query the data store through the SQL query language.

It is important that you run the services "MSSQLSERVER" under an account which has access to the directory. If you run the services under the local system account you will get the following error when you try to query the data store:

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' 
                    CommandPrepare::Prepare returned 0x80040e14].

So if the directory runs on your local machine and the local user "DirectoryUser" has access to it then you need to run the "MSSQLSERVER" service under this account. If the directory is running somewhere in your domain and the domain user "DomainUser" has access to it then you need to run the "MSSQLSERVER" service under this domain account."

Re: interogare useri din Active Directory

crestinul — Wed, 15 Aug 2007 11:38:49 GMT

Mosule am eu o scula mica facut in dot net pt asa ceva cauta-ma pe mess sau vezi pe itboard ca am postat sursa

Re: interogare useri din Active Directory

Alex — Wed, 15 Aug 2007 11:29:26 GMT

nu ma descurc....ma tot chinui de ceva vreme....nu inteleg exact ce si cum terbuie facut

daca ai vreodata ceva timp liber sa imi zici te rog pas cum pas ce si cum ar trebui facut ar fi super...intre timp ma mai chinui.

multumesc mult.

alex.

Re: interogare useri din Active Directory

B_gd_n[ ]Sahlean — Wed, 15 Aug 2007 07:31:23 GMT

Trebuie sa folosesti furnizorul de date OLE DB (OLE DB Data Provider) "OLE DB Provider for Microsoft Directory Services" !

Citeste aici: http://msdn2.microsoft.com/en-us/library/ms190803.aspx !

interogare useri din Active Directory

Alex — Wed, 15 Aug 2007 07:19:54 GMT

salut

am inteles ca din SQL se pot interoga userii din Active Directory....stie cineva mai multe despre lucrul asta....cum se face....exista vreo functie

alex.