pankajgharge
asked on
How can I enable SQL Server Agent on SQL Server 2005
I can not see SQL Server Agentn on my SQL Server. I have SQL Express Trial version. How can I enable it?
You will not have SQL Server Agent in express
sql agent doesn't come with sql express
ASKER
Ok.. In my SQL Server Configuration Manager, I can see SQK Server Agent Service. Also I can see same service in my Services....
in the services dialog, right click the service and go to properties...can you start it from there?
do you have more than one SQL instance installed on your box?
ASKER
Yes I can start the service. I do not have more than 1 SQL Server instance on my machine. Here is a snapshot.
snap.JPG
snap.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.