I am using a SQL server based commercial software program and have been told by the developer that I must run the software while logged in and working under a Windows administrator-level user ID. Apparently it is not enough to right-click and choose "run as administrator" because the SQL server agent process cannot be activated manually in this way even though the overlying program can.
I am super uncomfortable with this idea. I do all my various types of work in a limited-privilege Windows user account except when absolutely necessary.
I know enough to be wary of this but not enough about SQL server to discuss sensibly with the developer why or if this is necessary or if it is a real security issue. Can anyone more knowledgeable please throw in their two cents here?