Unix Technical Forum

SQL Server and Active Directory

This is a discussion on SQL Server and Active Directory within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hello, Since Active Directory has a SQL server database can these tables be queried by another SQL Server instance ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 07:11 PM
Simone
 
Posts: n/a
Default SQL Server and Active Directory

Hello,

Since Active Directory has a SQL server database can these
tables be queried by another SQL Server instance and what
kind of permissions is required for this type of job.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 07:12 PM
Ray Higdon
 
Posts: n/a
Default SQL Server and Active Directory

You have to have permissions to read AD. You can setup AD
as a linked server and issue select statements using
openquery.

HTH

Ray Higdon MCSE, MCDBA, CCNA

>-----Original Message-----
>Hello,
>
>Since Active Directory has a SQL server database can

these
>tables be queried by another SQL Server instance and what
>kind of permissions is required for this type of job.
>.
>

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:29 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com