Windows user with SQL Server Authentication

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  April 9, 2015 at 10:15 am

  #296696

  I'm almost sure that it's not possible, but I wanted to ask in case that I'm missing something.

  Is it possible to get the Windows user when someone logins using SQL Server Authentication?

  I know how to get the hostname, but I can't find how to make the next step.

  By the way, do sleeping connections affect performance? Would they consume resources such as RAM or network?

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Grant Fritchey

  SSC Guru

  Points: 399289

  More actions

  April 9, 2015 at 10:48 am

  #1789934

  Only if it's supplied through the connection string. Which, effectively, means no.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning