unable to check logging for a database maintenance job

I am unable to check logging for a database maintenance plan.I’m running SQL Server 9.0.1399.I logged into the computer which hosts SQL then brought up Microsoft SQL Server Management Studio and logged into the instance as sa.I clicked on “Maintenance Plans” and then “Modify” for the plan under interest.As soon as I click on “Logging…” a dialogue window pops up and states:Microsoft .NET Framework / Unhandled exception has occurred in a component in your application. / Failed to retrieve data for this request. / EXECUTE permission denied on object 'sp_help_operator', database 'msdb', schema 'dbo'.That error does not make much sense because msdb is owned by sa and I logged in as sa.Further, using the new query window, sa can indeed execute sp_help_operator.

[942 byte] By [DavidZokaites] at [2007-12-25]
# 1

Hi David,

Which operating system is SQL running under?

Do you get the same error if you use integrated security?

Terrence Nevins

SQL Server Program Manager

TerrenceNevins at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 2

Terrence,

Winver tells me that I'm running Microsoft Windows Server 2003 Enterprise Edition version 5.2 build 3790.srv03_sp1_rtm.050324-1447 service pack 1.

After no replies to my post for a few days, I was starting to think that posting to MSDN forums could be a waste of time. But now I've received a reply from a Program Manager - wow!

David

DavidZokaites at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 3

These forums are an excellent resource if someone else has already experienced your problem and found a solution. Unfortunately, for my problem, I have found no solution via this forum. I utilized a free service and got what I paid for.

DavidZokaites at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Tools General...

SQL Server

Site Classified