This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

"Disable Check for SQL Express" against SQL Server Agent

Question
0

Sign in to vote
Good afternoon,

Seeing as it has been a know issue for many years now[1], is there a reason why Microsoft has yet to include a “Disable Check for SQL Express” override (similar to the Automatic Configuration (& other) monitors) for each of the following objects included in the Microsoft SQL Server Management Pack?

SQL Server Agent Windows Service (Monitor)
Discover SQL Server Agent for a DB Engine (Discovery)

This would prevent me from have to continually create overrides disabling the monitor|discovery each time a new instance of SQL Express is installed in our Management Group.

Thanks,

Larry

[1] http://jmkehayias.blogspot.ca/2009/01/sql-server-2008-express-sql-agent-won.html

http://sqlblogcasts.com/blogs/sqldbatips/archive/2008/06/28/sql-server-2008-express-installs-sql-agent-but-don-t-bother-trying-to-start-it.aspx
Monday, May 7, 2012 8:10 PM

Answers

0

Sign in to vote
I ended up creating a SQL Express Edition DB Engine Instances group which is dynamically populated with SQL Server Express DB Engine instances. I then targeted some Disabled=True overrides against the newly created group for each of the Discover SQL Agent for a DB Engine discoveries.

Enjoy,

Larry
- Marked as answer by larry.leblanc Wednesday, May 9, 2012 3:07 PM
Wednesday, May 9, 2012 3:07 PM

All replies

0

Sign in to vote

For those interested in seeing this request go through, I woud suggest that you vote it up on the Microsoft Connect web site (https://connect.microsoft.com/site16/feedback/details/740988/disable-check-for-sql-express-against-sql-server-agent).

Thanks

Larry

Monday, May 7, 2012 8:14 PM
0

Sign in to vote
I ended up creating a SQL Express Edition DB Engine Instances group which is dynamically populated with SQL Server Express DB Engine instances. I then targeted some Disabled=True overrides against the newly created group for each of the Discover SQL Agent for a DB Engine discoveries.

Enjoy,

Larry
- Marked as answer by larry.leblanc Wednesday, May 9, 2012 3:07 PM
Wednesday, May 9, 2012 3:07 PM
0

Sign in to vote
Hello,

This is much easier http://blogs.technet.com/b/emreguclu/archive/2013/01/21/undiscovering-stop-monitoring-sql-2008-express-editions.aspx

just exclude sqlexpress

Regards
Mohammad, IT NOC Team
- Proposed as answer by Mohammad Shaaban Wednesday, February 19, 2014 2:46 PM
Wednesday, February 19, 2014 2:46 PM