Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Active Directory Rss

   Items 1 to 12 of 12   
 

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,211 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,496 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,168 reads

Function to convert UserAccountControl number to details text

Function that converts AD UserAccountControl number to details text  Read more...
By Shane Clarke 2013/05/27 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 584 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 | 717 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 | 352 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 | 1,912 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,240 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,109 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 | 4,847 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,647 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,240 reads
   Items 1 to 12 of 12   
 
Tags
powershell (3)    
security (3)    
ldap (2)    
windows 2008 r2 (2)    
windows 2012 (2)    
active directory service interfaces (adsi) (1)    
ad (1)    
adsi (1)    
analysis services (1)    
analysis services (ssas) (1)    
dns (1)    
document environment (1)    
domain (1)    
double hop (1)    
function (1)    
iis (1)    
kerberos (1)    
openquerry (1)    
record limit (1)    
reporting services (ssrs) (1)    
sql server cluster (1)    
t-sql (1)    
useraccountcontrol (1)