Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How can I see which user is running sqlserver process in a windows 7 machine? I need to know this in order to change some permissions. I opened the task manager but the list is almost empty, maybe because I'am on a virtual machine, do I have a command line option? Thanks

share|improve this question

2 Answers 2

up vote 3 down vote accepted

The Applications tab of task manager will only show desktop applications. You should be able to see the SQL Server process in the Processes tab. Make sure you click the Show Processes from All Users button at the bottom of the task manager screen.

The other way do do this is to see what user is defined in the service properties:

  1. Start, then type "Services" in the search box, and choose Services from the results
  2. Find the SQL Server service, and right-click and choose properties
  3. Go to the Log On tab and you will see that SQL Server is either running as system, or a specific account.
share|improve this answer

You can try it from the command line, here is a quick guide: http://www.howtogeek.com/howto/windows/display-a-list-of-started-services-from-the-command-line-windows/

share|improve this answer
    
:( unfortunately this doesn't give me the name of the user running the process –  Lucia Feb 28 '12 at 2:35
    
Hmmm you can try installing an application to help you, technet.microsoft.com/en-us/sysinternals/bb896653 –  xXPhenom22Xx Feb 28 '12 at 2:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.