May 2, 2006 at 12:49 pm
Hello,
MSSQL2000/SP4
I assigned a user the server role "Process Administrator" via Enterprise Manager (EM). The user belongs in user db with db_datareader and db_datawriter db roles (no other server roles). The user is unable to kill processes via EM tool? The user has disconnected, connected and refreshed within EM, but each time the "Kill Process" button is ghosted (Management>Current Activity>Process Info>dbl click on a ProcessID).
However, the user is able to kill processes via Query Analyzer using "KILL" ???? ie: KILL 135
Any thoughts why they can't in EM?
Many thanks. Jeff
May 2, 2006 at 1:48 pm
What account was used to register the server in EM? Make sure it's the one with Process Administrator rights. Maybe that's the issue.
HTH,
Mark
May 2, 2006 at 1:56 pm
I tested that on my test server by creating a server alias and having 2 registrations in EM: one for sysadmin and one for the serveradmin only. I do observe the same issue. Also the Send Message entry which is above the Kill Process entry in EM is missing when connecting as ServerAdmin. I tested it from the server's EM to make sure that the service pack is applied to the EM. This machine has SP3A
I do know that not everything is role-compliant. For example, sp_adduser would not accept roles, it is only dbo who can add users, db_securityadmin can not do it per this sp's code (not permissions, but one line inside the code that checkes if the adding person is a DBO).
So maybe Kill Process feature of EM was not modified when roles were introduced. When I connectd to the same server using the same serveradmin user from Management Studio (2005) Kill Process is enabled but give me an error 6102 that this user does not have permissions to run KILL statement
Regards,Yelena Varsha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply