• You can find out the hosname (usually) of a connection by running the sproc [master].[dbo].[sp_who2]

    It will list the login name, SPID, Hostname, and a bunch of other useful things.  If the application connects to the SQL server using SQL authentication, then no, you will not know their windows login.  I don't believe that the windows login name is exposed to the connection in any way that would allow it to be learned from SQL server.  I'm not 100% positive, however.

    I do believe that GP requires that the sa account be used to perfom certain administration tasks, but the users connect with SQL server user names.  At least that's how the last GP system I used was working.

    jg