SQL Server Agent not showing up under Object Explorer

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?
fyzalkabuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Regards,

Jim
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fyzalkabuAuthor Commented:
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.


0
ValentinoVBI ConsultantCommented:
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.
0
jmoss111Commented:
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.

Regards,

Jim


0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.