SCOM 2012 SQL 2000 MP

All replies

• 

  

  0

  Sign in to vote

  SQL 2000 is not supported in SCOM 2012, but there is a workaround: http://thoughtsonopsmgr.blogspot.dk/2010/08/how-to-monitor-sql-2000-with-latest-sql.html

  ---

  www.coretech.dk - blog.coretech.dk

  • Proposed as answer by Mai AliMVP Monday, June 23, 2014 11:08 PM

  Monday, June 23, 2014 6:11 PM
• 

  

  0

  Sign in to vote

  SQL 2000 MP - this is not supported and there is no workaround for this. But you can install it and it does work as long a the underlying OS is supported for the SCOM agent. 

  http://www.microsoft.com/en-us/download/details.aspx?id=10631

  Also refer below link

  http://social.technet.microsoft.com/Forums/systemcenter/en-US/b49ebfe4-61eb-445a-8df5-adeced303d2f/mps-for-om-2012-sql-2000-and-dfs?forum=operationsmanagermgmtpacks
  

  ---

  Please remember, if you see a post that helped you please click "Vote As Helpful" and if it answered your question, please click "Mark As Answer" Mai Ali | My blog: Technical | Twitter: Mai Ali

  Monday, June 23, 2014 11:08 PM
• 

  

  0

  Sign in to vote

  Hi Tech.bird,

  The SQL 2000 management pack version 6.0.6648.0 can be installed separately. Please refer to the next link:

  http://thoughtsonopsmgr.blogspot.ca/2010/08/how-to-monitor-sql-2000-with-latest-sql.html

  Can be downloaded here and works OK under SCOM 2012 R2:

  http://www.microsoft.com/en-us/download/details.aspx?id=15226

  ---

  Natalya

  • Edited by Natalya Vank Tuesday, June 24, 2014 12:27 AM
  • Proposed as answer by Natalya Vank Saturday, June 28, 2014 2:10 AM
  • Marked as answer by Yan Li_ Monday, June 30, 2014 1:32 AM

  Tuesday, June 24, 2014 12:24 AM
• 

  

  0

  Sign in to vote

  SQL MP 6.1.314.35 removes the support of SQL Server 2000. One of the workaround is downloading previous SQL MP(6.0.6648.0) and then import just SQL Server 2000 (Monitoring) and SQL Server 2000 (discovery) as stated on http://thoughtsonopsmgr.blogspot.dk/2010/08/how-to-monitor-sql-2000-with-latest-sql.html. Moreover, SCOM 2012 R2 agent supports Windows 2003 SP2 platform. This means that your SQL Server should be installed on Windows 2003 SP2 otherwise it is useless to import SQL Server 2000 monitoring or discovering MP.  For supporting configuration of SQL Server 2000, please refer to http://technet.microsoft.com/en-us/library/aa175274(v=sql.80).aspx

  Roger

  • Marked as answer by Yan Li_ Monday, June 30, 2014 1:32 AM

  Tuesday, June 24, 2014 3:11 AM