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.


about me

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