February 5, 2013 at 7:51 am
We are using a SQL database on a specific server. All our users are logged in on different other servers (6). When they connect to the database a default user is used to avoid that every users needs to log on at the database server. But when I want to know which user is causing problems like locking I don't see the name of the user when I use:
use master
go
exec sp_who;
go
In the result I see the SPID and the hostname where the user is logged on. Is there a way that I can retrieve the name from the user from the other servers?
February 5, 2013 at 7:54 am
You want the name of the logged on users of the server, or the SQL login used
February 5, 2013 at 7:57 am
I want to see the name of the logged on users, when the connect to the SQL server they all use the same login name
February 5, 2013 at 8:00 am
You could use PSLoggedOn from the sysinternals suite of tools.
or
Login to the server and see who is logged in
or
Use windows based authentication instead of using a generic account, then you can get the information out of SQL without invoking other processes.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply