user1171387
Reputation: 1
How can I get the user's AD name when using SQL Auth in sql server 2005?
I want to monitor which people connect to my database.
Most of the users connect to SQL Server with an application user like crm_xxx.
I want to know which person is behind this crm_xxx, so I want to know what's his user login name to the windows.
The question is how do I find this data?
I tried the following : system_user, suser_sname, suser_name.
All of them returned my login name to the windows instead of returning the name of the actual login name of the user who connected with crm_xxx.
thanks in advance
Upvotes: 0
Views: 185
Answers (1)
gbn
Reputation: 432200
You can't. SQL Server doesn't have this information when you connect using a SQL login
Upvotes: 3
Related Questions
- How to get Windows Log-in User Name for a SQL Log in User
- Get current user while using SQL Authentication
- How to find login name in SQL Server from a user_name of database
- Get login name in SQL SERVER
- How to get the SQL Server username through a query?
- How to retrieve login name of a user from Active Directory?
- Get real user windows login name if connection authorized by SQL auth and impersonated
- Using Active Directory user info with SQL
- How can I query an which Active Directory account is associated with a SQL Server user?
- SQL Server 2005 Get Login name from User name