December 6, 2005 at 6:46 am
Hi all
We have users on our SQLServer with Server role of system Administrator. These users are not able to view any of the items under Enterprise Manager>Management>SQL server Agent. They are NOT able to view the Jobs, Alerts etc... Users with Local Admin rights to the server are OK...
I am not the DBA, he is away. I am just the humble Data Architect who is trying to help them. Is this a weird security issue?
We are running SQLServer 2000 SP3, Window 2003 SP1.
Any suggestion would be of great help.
December 6, 2005 at 7:32 am
Users who need to view agent information like jobs and schedules can be added to a role within the MSDB database called TragetServersRole. This should allow them to view the above mentioned information.
December 6, 2005 at 7:53 am
If they are system administrators, they should be able to view everything.
If they are running EM, go to Tools, then Query Analyzer and startup a profile on that tool. SELECT user_name() and see if Sa comes back.
If not, they are not mapped as system administrators.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply