October 29, 2008 at 9:19 am
Hi, I want SQL Server Agent to run on my development machine. I have checked that the service is running and all services look the same as on the production machine however in Mgmt Studio it does not show up in the Object Explorer. How do I fix this? Thank you for you time.
Warm regards,
October 29, 2008 at 10:14 am
refresh?
If the service is running (is this the same instance), it should be there. Try running a job and see if it works.
October 29, 2008 at 10:56 am
if your dev machine is running SQL Express or SQL Express Advanced, SQl Server Agenct does not exist; it's not part of the featureset, and i suspect that is what happened.
To get Agent you'll need to upgrade to SLQ 2005 Developer, which costs under 50 bucks i think.
Lowell
October 29, 2008 at 4:21 pm
Found the problem, the admin login I was using was given only the Public server role. It should have been identical to the production login but was not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply