Agent not showing in SSMS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Agent not showing in SSMS

Agent not showing in SSMS

Rate Topic

Display Mode

Topic Options

Author

Message

krypto69

Posted Wednesday, August 15, 2012 6:56 AM

SSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 6:50 AM
Points: 624, Visits: 1,546

I have remote server. Checked it this morning and I can't see SQL Agent in SSMS.

I have stopped and restarted both the SQL Service & The Agent Service.

Version is Standard.

Agent service shows as running, but is not in SSMS. What the...?

Post #1345243

anthony.green

Posted Wednesday, August 15, 2012 7:05 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

The only posibility then that I am aware of is that the account your loging in as isn't sysadmin or a member of the SQL Agent fixed roles.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1345247

krypto69

Posted Wednesday, August 15, 2012 7:16 AM

SSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 6:50 AM
Points: 624, Visits: 1,546

yeah it was a rights thing...

thanks for your help..

Post #1345259

fearghalohare

Posted Thursday, August 23, 2012 2:42 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, August 23, 2012 6:34 AM
Points: 2, Visits: 1

Hi, I have the same problem as above and its def priv related as i tightened security on my db yest and no wmy sql server agent jobs dont complete running (they dont error either. Also when i create a new one i get 'sql server agent job not chached'.

Does anybody know what may be lacking matching/correct permissions - server, db, tables, agent?

Any advise will do as I know this is a small issue but im flummoxed (spelling) :)

ferg

Post #1348946

fearghalohare

Posted Thursday, August 23, 2012 6:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, August 23, 2012 6:34 AM
Points: 2, Visits: 1

found solution, i was not a sa anymore so sql server agent refsed to run under me or indeed run any jobs where i was given as user account.

Post #1349063

« Prev Topic | Next Topic »

Permissions