Blog

Determine if SQL login is using Windows Authentication or SQL Authentication

November 13, 2019

Windows Authentication

SELECT * FROM sys.sysusers WHERE isntuser = 1

SQL Authentication

SELECT * FROM sys.sysusers WHERE issqluser = 1

0 Comments

Leave Your Comment

Your email address will not be published. Required fields are marked *


about me

An information technology professional with twenty four years experience in systems administration, computer programming, requirements gathering, customer service, and technical support.