System Center,Windows,Cloud,Vmware etc

Friday, March 22, 2019

SQL spn and linked server double hop and kerberos

Good link to setup linked server and spn's

https://sqljana.wordpress.com/2017/06/16/sql-server-curse-of-linked-server-security-and-the-fix-pass-through-authentication/


https://www.alexandreviot.net/2014/09/30/sql-server-could-not-register-the-service-principal-name-spn/


Query to see if Kerberos is being used.


Posted by Parag at 2:42 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: kerberos, linked server, spn, sql
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Search Archive

  • ►  2012 (7)
    • ►  February (2)
    • ►  March (1)
    • ►  April (1)
    • ►  June (1)
    • ►  September (1)
    • ►  October (1)
  • ►  2013 (7)
    • ►  January (1)
    • ►  June (1)
    • ►  July (1)
    • ►  August (3)
    • ►  September (1)
  • ►  2014 (6)
    • ►  February (1)
    • ►  April (1)
    • ►  May (1)
    • ►  September (2)
    • ►  October (1)
  • ►  2015 (3)
    • ►  January (2)
    • ►  July (1)
  • ►  2016 (12)
    • ►  June (1)
    • ►  September (2)
    • ►  October (4)
    • ►  December (5)
  • ►  2017 (34)
    • ►  January (1)
    • ►  February (7)
    • ►  March (2)
    • ►  April (6)
    • ►  May (4)
    • ►  June (5)
    • ►  July (1)
    • ►  August (1)
    • ►  October (2)
    • ►  November (3)
    • ►  December (2)
  • ►  2018 (9)
    • ►  March (3)
    • ►  April (1)
    • ►  May (1)
    • ►  August (2)
    • ►  September (1)
    • ►  December (1)
  • ►  2019 (6)
    • ►  January (2)
    • ►  March (2)
    • ►  April (1)
    • ►  May (1)
  • ►  2020 (7)
    • ►  February (1)
    • ►  April (1)
    • ►  July (2)
    • ►  September (1)
    • ►  December (2)
  • ►  2021 (11)
    • ►  January (3)
    • ►  March (1)
    • ►  May (1)
    • ►  June (1)
    • ►  September (1)
    • ►  October (2)
    • ►  December (2)
  • ►  2022 (8)
    • ►  February (2)
    • ►  March (1)
    • ►  April (1)
    • ►  May (1)
    • ►  June (1)
    • ►  July (1)
    • ►  September (1)
  • ►  2023 (9)
    • ►  April (1)
    • ►  May (3)
    • ►  July (2)
    • ►  August (1)
    • ►  October (1)
    • ►  November (1)
  • ►  2024 (5)
    • ►  January (1)
    • ►  March (1)
    • ►  April (1)
    • ►  July (1)
    • ►  November (1)
  • ▼  2025 (1)
    • ▼  March (1)
      • SQL SPN Powershell Commands

Search This Blog

Parag Waghmare. Simple theme. Powered by Blogger.