Hi ,
I had SQL 2005 Standard edition installed in Windows Server 2003 SP2. SQL
Server Agent is not available SQL Server Management Studio 2005 Object
explorer.

But I could see/start/stop SQL Server Agent at
Program Files --> Microsoft Sql Server 2005 --> Configuration tools --> SQL
Server Configuration manager --> SQL Server 2005 Services.

It is installed in mixed mode and i tried with windows login and sql
authentication but failed to view Sql Server Agent in SSMS object explorer.

Could any one please help me out ASAP. Due to this issue i m not able to
create any SQL Jobs.

Regards,
Ganesh

Ganesh (Ganesh (AT) discussions (DOT) microsoft.com) writes:
The only thing that I can think of is that you for some reason have the
Express version of Mgmt Studio installed. Since Express Edition does not
come with Agent, I guess that SSMS Express does not include the node for
Agent.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

I agree with Erland, it sounds like you installed the Express Edition of
Management Studio. What edition of SQL Server do you have installed? You
should uninstall the Express Edition of the tools and install the client
tools from the edition you have.


On 2/9/09 1:06 PM, in article
26B732B7-D83C-4140-AEF8-97EFE333C3C5...soft (DOT) com, "Ganesh"
<Ganesh (AT) discussions (DOT) microsoft.com> wrote: