SQL Server Agent Not Available in SSMS 2005 Object explorer

9 Feb 2009 6:06 PM

Ganesh

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

9 Feb 2009 11:09 PM

Erland Sommarskog

Ganesh (Gan***@discussions.microsoft.com) writes:
Show quoteHide quote

> 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.

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, esq***@sommarskog.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/prodinfo/previousversions/books.mspx

10 Feb 2009 12:41 AM

Aaron Bertrand [SQL Server MVP]

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-97EFE333C***@microsoft.com, "Ganesh"
<Gan***@discussions.microsoft.com> wrote:

Show quoteHide quote

> 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

10 Feb 2009 8:05 AM

Ekrem_Ã–nsoy

First thing came to my mind was the same just like Erland and Aaron, however
another possibility came to my mind later and wanted to add it to this
thread.

You may not have sufficient permissions on the SQL Server instance at server
level as well. For instance if your Login is only member of Public fixed
server role then you'll not see SQL Agent in SSMS even if it's the full
version of SSMS.

--
Ekrem Ã–nsoy

Show quoteHide quote

"Ganesh" <Gan***@discussions.microsoft.com> wrote in message
news:26B732B7-D83C-4140-AEF8-97EFE333C3C5@microsoft.com...
> 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