Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SQL Server Agent not showing up under Object Explorer

Posted on 2008-11-16
Medium Priority
Last Modified: 2012-05-05
Select @@Version = Standard
SELECT serverproperty(edition) = standard
SELECT serverproperty(editionid) = 2
All the above queries shows that version is STANDARD.
Here I am not able to view SQL SERVER ANGENT under the object explorer. Enabled under SQL Sever configuration manager.
Here please note that on the server the tool is MICROSOFT SQL SERVER MANAGEMENT STUDIO EXPRESS.
This has been installed by one of our vendor.

Please advice

Please suggest any tips for enabling the SQL Server Agent so that I can schedule the backups?
Question by:fyzalkabu
  • 2
LVL 18

Accepted Solution

jmoss111 earned 1600 total points
ID: 22970095
Hi fyzalkabu,

If the tool is SQL Server Management Studio Express then there is no SQL Server Agent. It appears  that you are using SQL Standard Edition... I wonder why Studio Express is installed instead of Studio. You can download a free scheduler that is actually pretty good for Express at www.lazycoding.com .



Author Comment

ID: 22970164
Thanks Jim,
Can you please answer one more question here..

By default when installing SQL Server standard edition , it should come SQL Server Mangement Studio, AND NOT SQL Server Management Studio Express.
How is this possible..? i.e. version is STANDARD but tool is SSMSE. How is this installed.

LVL 37

Assisted Solution

ValentinoV earned 400 total points
ID: 22970269
hi fyzalkabu,

I think you should ask your vendor why they installed the Express edition of SSMS.

SSMSE is a free download from Microsoft, meant to manage SQL Server Express Edition.  Of course it's compatible with the other editions as well but you don't get the extra functionality, as you've noticed.
LVL 18

Expert Comment

ID: 22970373
Hi fyzalkabu,

By default yes that is true but I think that you can opt to not install Studio, but its beyond me why someone would install Express in its place.

I think that the vendor needs to do some explaining.




Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question