• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 397
  • Last Modified:

Active Directory to SQL Server

Is there any way to setup SQL Server to link to Active Directory so I can setup various reports to run automatically querying the SQL server?  I am looking for a solution that will work with my existing setup, so I do not have to purchase expensive software.

Thanks for any help!
0
blouckswwu
Asked:
blouckswwu
  • 4
  • 3
1 Solution
 
FDzjubaCommented:
0
 
blouckswwuAuthor Commented:
I am want to be able to query Windows Active Directory users using SQL server.  Your first link is what I am looking for, but it doesn't go into much detail on how to user Enterprise Manager to peform this task.

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21064994.html
0
 
blouckswwuAuthor Commented:
I found in Enterprise Manager where the linked servers option is.  I attempted to create a link to our primary Active Directory server and I get the following Error.

Error 7301: Could not obtain a required interface from OLE DB provider 'ADsDSOObject'.
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' IUnknown::QueryInterface returned 0x80004002:  IDBSchemaRowset].

There just isn't much information regarding this.  Almost all the links that I have found on the web are broken links to Microsoft.  Its frustrating how Microsoft does not make this very easy and does not provide much information on this.  I believe they want to you just spend $1,000's of dollars on a 3rd party vendor.  I spend enough on their software and I do not want to spend any more on other vendors to get information that their OS should already provide.  Ok ...I'm off the soapbox now...sorry.

Thanks for your input and help!
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
FDzjubaCommented:
try to update Service Pack and MDAC drivers, then try to create link to Active Direcotries

MDAC 2.8 should fix the problem
0
 
blouckswwuAuthor Commented:
I installed the MDAC 2.8 (client and SQL server) and I am still having the same problem.  I think I am missing something in my setup.  I just can't find anything on the Internet that tells me what the right settings are to connect to Active Directory.  When I right click on the linked server I created and go to properties there are some settings that need to entered in:

**General Tab**
Product name: Microsoft Active Directory Services
Data source: XXXXX - I put in one of my catalog masters (pdc server)
Provider string: <blank>
Location: <blank>

**Security Tab**
I have setup nothing under the local server login to remote server login mappings section.
0
 
FDzjubaCommented:
0
 
Ken SelviaRetiredCommented:
0
 
blouckswwuAuthor Commented:
I got it to works.  Thanks all for your comments.  
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now