Skip to main content
Database Administrators

Return to Question

Fix grammar, syntax
Source Link
edit approved Aug 7, 2015 at 19:03
elixenide
edit approved Aug 7, 2015 at 19:03
elixenide
  • 159
  • 1
  • 2
  • 7

I'm trying to grant access to the Job Activity Monitor. OneOn my model office server I can create a new login and add it to the SQLAgentReaderRole role in msdb, and the id has access to the monitor. HoweverHowever in my production environment the exact same process gives me the following error:

enter image description hereScreenshot of error message

Both are 2008 R2, but production is SP2, and MO is SP3. I'mI'm making the assumption this doesn't matter but I could be wrong.

I checked and the associated permissions (SQLAgentReaderRole, SQLAgentUserRole, PUBLIC in msdb and master) and they appear to be the same.

I'm trying to grant access to the Job Activity Monitor. One my model office server I can create a new login and add it to the SQLAgentReaderRole role in msdb and the id has access to the monitor. However in my production environment the exact same process gives me the following error:

enter image description here

Both are 2008 R2 but production is SP2 and MO is SP3. I'm making the assumption this doesn't matter but I could be wrong.

I checked and the associated permissions (SQLAgentReaderRole, SQLAgentUserRole, PUBLIC in msdb and master) and they appear to be the same.

I'm trying to grant access to the Job Activity Monitor. On my model office server I can create a new login and add it to the SQLAgentReaderRole role in msdb, and the id has access to the monitor. However in my production environment the exact same process gives me the following error:

Screenshot of error message

Both are 2008 R2, but production is SP2, and MO is SP3. I'm making the assumption this doesn't matter but I could be wrong.

I checked and the associated permissions (SQLAgentReaderRole, SQLAgentUserRole, PUBLIC in msdb and master) and they appear to be the same.

Source Link
Kenneth Fisher
Kenneth Fisher
  • 24.3k
  • 12
  • 61
  • 115

Granting access to the Job Activity Monitor

I'm trying to grant access to the Job Activity Monitor. One my model office server I can create a new login and add it to the SQLAgentReaderRole role in msdb and the id has access to the monitor. However in my production environment the exact same process gives me the following error:

enter image description here

Both are 2008 R2 but production is SP2 and MO is SP3. I'm making the assumption this doesn't matter but I could be wrong.

I checked and the associated permissions (SQLAgentReaderRole, SQLAgentUserRole, PUBLIC in msdb and master) and they appear to be the same.