SQL Server Agent not showing

Question

Hi I got two instance of Database. the other one has maintenance plan with SQL Server Agent and the other instance doesn't have.  How can I put or enable or install the SQL Server Agent in my other instance of Database.  Thanks!

Answer 1

Hi I got two instance of Database. the other one has maintenance plan with SQL Server Agent and the other instance doesn't have.  How can I put or enable or install the SQL Server Agent in my other instance of Database.  Thanks!

I am using SQL 2005 Standard edition.

---

ianskee

Answer 2

Hi,

Is it only client tools are installed on your system? If incase full version of Database Engine Services are installed we can find the SQL Agent Services. If you want to install SQL Agent Services then run the SQL Server media in the feature selection screen select the Database Engine Serives.

If you have installed Database Engine Services then you can find the SQL Server Agent Services. You can check in Run->services.msc->SQL Server Agent, You can start it by Rigth Click->Start(if it is not started). If it is a stand alone server you can make the SQL Server Agent to start automatically by Rigth Click->Properties->Startup Type automatic.

 

---

Thanks & Regards, Pramilarani.R

Answer 3

Hi,

I preassume that your are talking about two different servers with one of them shows SQL Server Agent & on other it doesn't.

Have you checked that both servers have database services & client components installed?

If yes, Please check the account you logged on is member of local administaror group i.e you are admin on that machine? Because if you're logged on with some other account which has restricted permissions then SQL Agent won't show up?

If any non admin is logged in then in order to view SQL Server Agent he must be added to SQLAgentUser, SQLAgentOperator role.

Hope this helps.

 

---

Regards, Vishal Srivastava

Answer 4

Are you connecting through the same SSMS?

If so, then one is Express Edition, most likely.

If not, then the SSMS where you don't see Agent is the "Express" edition of SSMS.

More info here: http://sqlblog.com/blogs/tibor_karaszi/archive/2011/02/10/what-does-this-express-edition-look-like-anyhow.aspx 

 

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 5

Hi Tibor,

This might not be true. I can use SQL Server 2008 or later Management Stdio Express (installed from Management Tools - Basic) to connect non-Express instances, and SQL Server Agent would be shown there. However, if it is an instance of SQL Server Express, SQL Server Agent node won't be listed there since SQL Server Express does not include SQL Server Agent feature at all no matter you are using Management Studio Express or not.

Here is a blog post talking about differences between SQL Server Management Tools- Basic and Management Tools - Complete: http://blogs.msdn.com/b/psssql/archive/2008/09/02/sql-server-2008-management-tools-basic-vs-complete-explained.aspx.

---

Best Regards
Alex Feng | Forum Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact [e-mail].

Answer 6

to check whether your db account has been set permission on SQL Agent.

 

Answer 7

Very interesting, Alex - thanks!

I didn't consider that SSMS changes (Agent node) depending of what edition of the server you connect to. So, Basic has an Agent node, if connected to a non-express instance. Cool, makes this type of troubleshooting easier. I'll go and update my old blog post.

I recall that "Express SSMS" (don't recall what version) didn't have Execution Plan GUI at some point. Do you happen to have an Express SSMS to see if that is still the case?

---

Tibor Karaszi, SQL Server MVP | web | blog