Skip to content

SQL Jana

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

Tag: Administration

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

Advertisements
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

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: MERGE (AKA UPSERT) =(INSERT / UPDATE / DELETE) - All In One
  • 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
  • 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
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