I have a requirement to audit user's hostanmes connected to SQL Server using SQL Authentication. I know I can get this information if the user has connected from SQL Server tools installed in his local machine. But in my case, all users are
connecting to SQL Server database using another Server. Basically , users whoever need access to SQL Server Databases they need to first login into one terminal server using RDP and from Terminal Server (TS01) they connect to SQL Server Database using
SQL Authentication. If I am trying to audit these users the hostname is same for all these users which is Terminal Server (TS01)in my case. But I want to get users actual hostname from which he\she RDP into TS01 Server.
Here is my environment Details:
Windows Version: Windows 2008 Standard
DB Server: SQL Server 2008 Standard With SP1
Terminal Server : Windows Server 2008 Standard, SQL Server 2008 Client Tools
Please let me know if there is anyway to get the actual hostname and would grealty appreciate response on this post.
View Complete Post