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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy