Skip to content

SQL Jana

Jana's ramblings on Oracle, SQL Server, PowerShell and technology

Tag: AD

PowerShell & Active Directory: Quickly Find The Manager For A Bunch Of Users

PowerShell & Active Directory: Quickly Find The Manager For A Bunch Of Users

Today, I received a request to find the manager for a whole bunch of users. This was a list of names (not UserId's) in a Excel worksheet. It is not actually that complex to do it Locate the AD user based on the name Check the Manager property Lookup AD again for Manager to get … Continue reading PowerShell & Active Directory: Quickly Find The Manager For A Bunch Of Users

Advertisements
Posted on February 19, 2018February 16, 2018 by SQLJanaPosted in Account Lookup, Active Directory, PowerShellTagged Active Directory, ActiveDirectory Module, AD, AD Account, AD User, CSV, Employee, Excel, Find, Lookup, Manager, Module, Output, PowerShell, PowerShell Module, SAMAccountName, Spreadsheet, Status, StatusMessage, USER, Workbook. 1 Comment

PowerShell: Add, Remove, Copy And Move Users To Another AD Group Conditionally

Be sure to read the related blog post first before proceeding! PowerShell: Lookup Active Directory Accounts Flexibly/Exhaustively For A List Of First/Middle/Last Names If you are an AD admin, you are very likely a pro at managing AD group membership but for mere mortals, this can be a tedious task. Please read on to find out … Continue reading PowerShell: Add, Remove, Copy And Move Users To Another AD Group Conditionally

Posted on February 2, 2018May 31, 2018 by SQLJanaPosted in Active Directory, AD Groups, PowerShellTagged Account, Active Directory, AD, AD Account, AD Groups, AD Module, AD User, Add, Add-ADPrincipalGroupMembership, ADGroup, COPY, Filter, Get-ADGroupMember, Get-ADUserNames, Lookup, Move, PowerShell, Remove, Remove-ADPrincipalGroupMembership, Search, Search by name, Specific. 3 Comments

PowerShell: Lookup Active Directory Accounts Flexibly/Exhaustively For A List Of First/Middle/Last Names

Before we begin, if you are running Windows 7 or above and if you do not have the PowerShell Active Directory module installed, please do so first by downloading and installing “Remote Server Administration Tools”. I personally cannot live without this module. Please be sure to check out my related blog post which uses the function described … Continue reading PowerShell: Lookup Active Directory Accounts Flexibly/Exhaustively For A List Of First/Middle/Last Names

Posted on January 12, 2018February 2, 2018 by SQLJanaPosted in Active Directory, Logins & Users, Permissions, PowerShell, Security, SQL Server, UncategorizedTagged Active Directory, Active Directory Lookup, AD, AD Account, AD Module, Add to AD Group, Add-ADGroupMember, Find AD Account, Full Name List, Full Name To AD, Get-ADUser, List, Lookup, Lookup Names, Match, Matches, Name Lookup, Names String, Partial Match, Permissions, PowerShell, Security, Split, User List. 3 Comments

SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication

SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication

A great and related reference to what we will discuss in this blog post is this one: https://thesqldude.com/2011/12/30/how-to-sql-server-bulk-insert-with-constrained-delegation-access-is-denied/ Linked Servers in a sentence or two: Linked servers in SQL Server are connection definitions from one data source to another (or same instance) so that queries can be written joining tables spanning the multiple data sources. Although … Continue reading SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication

Posted on June 16, 2017February 11, 2019 by SQLJanaPosted in Error Messages, Linked Server, Security, SQL ServerTagged Active Directory, Active Directory Module, AD, Administration, ADSI, Audit, Authentication, Configure, Connection, DBA, Delegation, DNS alias, DoubleHop, Error, FQDN, Kerberos, Least Privilege, Linked Server, Linked Server Best Practices, Linked server error, Named Pipes, NT AUTHORITYANONYMOUS LOGON, NTLM, OPENQUERY, Pass Through, Passthrough, Passthrough Authentication, Performance, PowerShell, Remote Server Administration Tools, RSAT, Security, Security Context, ServicePrincipalName, Setspn, SPN, sp_addlinkedserver, SQL Server, SQL Server Native Client, SQL Server Service Account, SQLServer, TCP/IP, Trust. 5 Comments

SQL Server – Resolve – Cannot generate SSPI context

These links are more for my own reference than anything else to resolve the error: "Cannot generate SSPI context" It is a pesky error message that is related to security setup. All the things you need to check are in the MS article below. How to troubleshoot the "Cannot generate SSPI context" error message In … Continue reading SQL Server – Resolve – Cannot generate SSPI context

Posted on January 13, 2017January 13, 2017 by SQLJanaPosted in Active Directory, Error Messages, Permissions, SQL ServerTagged Active Directory, AD, AD User, Cannot generate SSPI context, Connection, Connectivity, Error, Kerberos, Login, Login error, Logon, Logon error, References, Service Account, Service Principal Name, SPN, SQL Server, SQL Server Service, SSPI. Leave a comment

Posts navigation

Older posts

Categories

Enter your email address to follow this blog and receive notifications of new posts by email.

Follow SQL Jana on WordPress.com

Tags

Active Directory AD Add Backups Capture Code CommandLine COMMIT Compare Convert COPY Database Databases Date Dates DateTime Days DBA DDL Delete Duration Dynamic SQL Error Errors Fast File Files Filter GB Generate hangs Host Indexes INSERT ISE Linked Server Logging Login LOOP MB Oracle Oracle Tip Output Parallel Performance Permissions PIVOT PLSQL PowerBI PowerShell Query ROLLBACK Run Search Security SELECT Session Size SQL SQL*Plus SQL Server SQLServer SQL Server Tip SSMS Storage String Table Tables Tip TSQL UNDO Update Usage USER Windows

Recent Posts

  • SQL Server: Compare Database Tables/Indexes/Views/SP’s etc. For Differences Across Instances February 6, 2019
  • PowerShell: Invoke-RDPLogoff – Logoff From Windows Servers In Parallel November 29, 2018
  • SQL Server: Compare The Configuration Of Two Instances Using sys.configurations September 12, 2018
  • SQL Server – Space – Data And Log File Growth Auto-Grow History TSQL August 3, 2018
  • SQL Server: Quick Space & File Layout Analysis With PowerShell and PowerBI April 30, 2018

Top Posts & Pages

  • Oracle - CLOB vs. VARCHAR2 - When & When Not To Use?
  • Oracle: Find The Total Size Of All Of Your CLOB & BLOB Columns In All Tables
  • SQL Server: Curse Of Linked Server Security And The Fix: Pass-through Authentication
  • Setup a Linked Server to MS Access from SQL Server - Beat the errors
  • Oracle - Data Dictionary Views - USER vs ALL vs DBA Views - 100 Level Basics
  • SQL Server - Drop An User In All Databases & Drop The Login Too!
  • Oracle - Return SELECT Statement Results Like SQL Server SP's - Using Pipelined Functions
  • SQL Server: MERGE (AKA UPSERT) =(INSERT / UPDATE / DELETE) - All In One
  • How to Resolve - "ORA-24381: error(s) in array DML"
  • SQL Server - Find Effective Permissions of An User At Database, Server or Object Level - The Right Way!

Archives

  • February 2019 (1)
  • November 2018 (1)
  • September 2018 (1)
  • August 2018 (1)
  • April 2018 (5)
  • March 2018 (3)
  • February 2018 (5)
  • January 2018 (6)
  • December 2017 (1)
  • October 2017 (1)
  • September 2017 (2)
  • August 2017 (4)
  • July 2017 (2)
  • June 2017 (3)
  • May 2017 (1)
  • April 2017 (11)
  • March 2017 (14)
  • February 2017 (23)
  • January 2017 (31)
  • December 2016 (10)
  • November 2016 (1)
  • October 2016 (3)
  • April 2016 (1)
  • March 2016 (1)
  • January 2016 (1)
  • November 2015 (2)
  • October 2015 (3)
  • September 2015 (1)
  • August 2015 (4)
  • July 2015 (1)
  • April 2015 (1)
  • December 2014 (1)
  • March 2014 (6)
  • February 2014 (1)
  • August 2012 (3)
  • October 2011 (1)
  • March 2011 (1)
  • February 2011 (1)
  • January 2011 (2)
  • December 2010 (2)

Follow me on Twitter

My Tweets
Advertisements
Create a free website or blog at WordPress.com.
Cancel
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy