Tuesday, March 20, 2012

Can't see property of SQL Server Agent

Hello!

I am working on Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2) and want just see properties of SQL Agent. What I do: Start Agent's service, right click on SQL Server Agent node(in Object Explorer) and select "Properties". All I get is:

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.


ADDITIONAL INFORMATION:

Property ErrorLogFile is not available for JobServer '[ASUS]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=ErrorLogFile&LinkId=20476


BUTTONS:

OK

Do you have any idea about this trouble?

Thanks In Advance for your tips!!

I looked through our bug database and could not find any bug mentioned after RTM related to this issue.

Questions:
1) Can you install Microsoft SQL Server 2005 Service Pack 1?
2) Are you running as an administrator?
3) Are you connecting to a local server?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Paul Mestemaker - MSFT wrote:

I looked through our bug database and could not find any bug mentioned after RTM related to this issue.

Questions:
1) Can you install Microsoft SQL Server 2005 Service Pack 1?

YES! This simple step solve all my troubles. :) Thanks a lot!

No comments:

Post a Comment