Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Active Directory Rss

   Items 1 to 15 of 15   
 

Liberating the DBA from SQL Authentication with AD Groups

It's 15 years after the beginning of the century. Time to eliminate the security exposure of SQL logins, and implement integrated security. Active Directory Groups make this easy for the DBA.  Read more...
By John F. Tamburo 2015/12/21 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 4,307 reads

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text  Read more...
By Shane Clarke 2015/07/27 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,111 reads

Azure Active Directory - Schema Extensions

The Azure Active Directory Graph API enables some interesting scenarios that you can implement in your applications by enabling you to query and manipulate directory objects in Azure AD. In this article, Rick Rainey provides a clear walkthrough of its implementation.  Read more...
By Additional Articles 2015/04/03 | Source: Just Azure | Category: active directory
Rating: (not yet rated)  Rate this |   Briefcase | 6,225 reads

Overcoming the OPENQUERY Record Limit for AD

Sometimes you have to pull more than 50,000 records. A script to do that inside the 1000 record limit.  Read more...
By Steven Burns 2014/11/13 | Source: SQLServerCentral.com | Category: openquerry
Rating: |  Discuss |   Briefcase | 5,445 reads

Solving Kerberos Issues in SSRS When Running Beside IIS

When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.  Read more...
By Ian Massi 2014/10/07 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,810 reads

Connecting to Analysis Services in Another Domain

Connecting to resources in untrusted domains with windows authentication can be tricky. Here's how to make it easy.  Read more...
By Ian Massi 2014/10/06 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,517 reads

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text  Read more...
By Shane Clarke 2015/07/27 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,111 reads

PowerShell to search for domain Computer objects

Query Active Directory Computer objects to verify existence  Read more...
By Fahim Ahmad 2013/05/01 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 734 reads

PowerShell to Pre-Create domain objects for SQL Server Cluster

Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster   Read more...
By Fahim Ahmad 2013/04/30 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 364 reads

Powershell - Document your environment

This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details".   Read more...
By Justin Manning 2013/03/22 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,041 reads

Check AD membership

Check AD membership (including nested) using ADSI as linked server.  Read more...
By raghu h 2012/09/07 | Source: SQLServerCentral.com | Category: ldap
Rating: |  Discuss |   Briefcase | 3,259 reads

Query Active Directory to Display Login Information

Query Active Directory to get information on user logins.  Read more...
By Rudy Panigas 2011/05/19 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,225 reads

Query Active Directory Data from SQL Server using T-SQL

Learn how to use SQL Server Transact SQL with OPENROWSET and OPENQUERY commands to access and retrieve data from Active Directory.  Read more...
By Additional Articles 2009/12/09 | Source: Database Journal | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 5,010 reads

How To Get Active Directory Users and Groups Using SQL Server Integration Services SSIS 2005

We would like to update the user, role, and user role tables automatically from Active Directory. Ideally we'd like an SSIS package that we could schedule and/or run on demand to take care of the update. Can you provide an example of how to do this?  Read more...
By Additional Articles 2009/01/08 | Source: MSSQLTips.com | Category: active directory
Rating:  Rate this |   Briefcase | 3,863 reads

Check AD membership

Check AD membership (including nested) using ADSI as linked server.  Read more...
By raghu h 2012/09/07 | Source: SQLServerCentral.com | Category: ldap
Rating: |  Discuss |   Briefcase | 3,259 reads
   Items 1 to 15 of 15   
 
Tags
security (4)    
powershell (3)    
ad (2)    
ldap (2)    
windows 2008 r2 (2)    
windows 2012 (2)    
active directory groups (1)    
active directory service interfaces (adsi) (1)    
ad groups (1)    
adsi (1)    
analysis services (1)    
analysis services (ssas) (1)    
azure (1)    
clustering (1)    
dns (1)    
document environment (1)    
domain (1)    
double hop (1)    
function (1)    
iis (1)    
integrated security (1)    
kerberos (1)    
openquerry (1)    
record limit (1)    
reporting services (ssrs) (1)    
t-sql (1)    
useraccountcontrol (1)