Get Windows Account from SQL Login

From: Jeff M (anonymous_at_discussions.microsoft.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 05:30:17 -0700

Hello,
Does anyone know if there's a way to retrieve the Windows
account name from a connection established using an SQL
Server user account? I couldn't find any built-in
function such as USER_NAME or SYSTEM_USER that will do
this. Perhaps this is only possible if using Windows
Authentication to establish the connection. Any insight?

Thanks,
Jeff

Relevant Pages

  • Re: connection options to yukon
    ... If you use TLS you can increase the security of your SQL auth ... connection but unless you're good at setting up groups/schema/logins/users, ... Windows auth is slower as the domain must ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help - IIS fails to access MSSQL on a nother computer
    ... > authentication running on top of Windows 2003 machine. ... > the MSSQQL sever on A using an SQL authentication. ... > The connection is working (the "test connection" step at the end of ... > Server Enterprise Manager and the SQL Query Analyzer. ...
    (microsoft.public.inetserver.asp.db)
  • Re: connection options to yukon
    ... If these are asp.net apps connecting to the database, ... If you use TLS you can increase the security of your SQL ... > Windows auth can lead to trojan operations as the application using SSPI ... >> Connection pooling does not depend on what method you choose to connect - ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Db connexion mode ???
    ... was designed to deal with ASP issues and does not really help Windows Forms ... Hitchhiker's Guide to Visual Studio and SQL Server ... the Connection pool is not a factor. ...
    (microsoft.public.sqlserver.connect)
  • Re: Detect all NtUserName
    ... NTUserName...but now my Network is Windows 2000 AD. Do you know some? ... >> other needs, but in all most that connection, the ntusername come blank ... >> other with the real ntusername, no different that library are Named Pipe ... >>> If you want to get the username even the User connects with Sql Server ...
    (microsoft.public.sqlserver.connect)