Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Agent not showing in SSMS Expand / Collapse
Author
Message
Posted Wednesday, August 15, 2012 6:56 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:07 AM
Points: 701, Visits: 1,733
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
Posted Wednesday, August 15, 2012 7:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:20 AM
Points: 5,231, Visits: 5,106
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
Posted Wednesday, August 15, 2012 7:16 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, September 15, 2014 10:07 AM
Points: 701, Visits: 1,733
yeah it was a rights thing...

thanks for your help..



Post #1345259
Posted Thursday, August 23, 2012 2:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, August 23, 2012 6:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse