defyant_2004 (12/17/2013)
I am still not seeing what functions on the server they would need. If they can work in SSMS from their machine, why do they need to login to the Server to use SSMS their? It seems like I would be creating more risk in the environment by letting them login to the machine. Are their resources on the server they need access to?
I have given some examples but you seem to be ignoring them, perhaps because they do not fit the answer you want?
iptech reiterates one in point 4), and its true of any database related file.
point 1) is valid for the DAC as well which I mentioned
These are the things I tend to access when local to the server to complete my duties (note, none are SSMS)
sql configuration manager
explorer
event viewer
component services
computer management
security policies
cluster administrator
perfmon
BIDS
I am always very careful when doing this and only touch the parts I understand, by nature DBAs are cautious and I am also lazy and don't want to create problems and therefore extra work for myself.
Some of these your DBAs won't need as they relate to SSIS or SSRS, but that might change one day.
---------------------------------------------------------------------