none
Add SQL server instance in SCOM group

    Question

  • Hi All,

    My customer has installed SCOM 2012 SP1 UR3. Customer has to monitor the SQL servers, for that imported the SQL MPs in SCOM.

    Customer provided me the list of SQL servers for testing with the instance details.

    Customer wants me to create a new group for provided SQL servers in SCOM.

    The details of SQL server is as follows:

    SQLServer1

    SQLServer2\INST2

    SQLServer3\INST3

    SQLServer4\INST4

    SQLServer6\ENV001

    SQLServer6\ENV001

    Out of that, the SQLServer1 able to add in new created group in SCOM.

    For other SQL servers, able to add the SQL servers directly but not able to add the instances of those SQL servers like INST2, INST3, INST4 & ENV001

    My question is, can we separately add the instances of SQL servers in the newly created groups for SQL in SCOM.

    If yes, then kindly provide the details in terms of document or respective link.

    Regards,

    SandeepK

    Monday, August 19, 2013 6:51 PM

Answers

All replies

  • When you add explicit member in your group, type "SQL Server" to search an object and then you can find SQL Server instrance.

    Roger

    Tuesday, August 20, 2013 3:28 AM
  • Hi,

    Thanks for your inputs.

    But I am not able to add SQL instances in the group.

    The steps followed are:

    1. Go to properties of Group
    2. Click Explicit Member Tab
    3. Click Add/ Remove object tab
    4. In Create Group Wizard- Object Selection window, select "Object" under Search for & put "SQL Server" undr optional.

    => The "SQL Server" is not listed in drop down list under Search for

    kindly suggest how to proceed.

    Regards,

    SandeepK 

    Tuesday, August 20, 2013 5:30 AM
  • May be my typing mistake. type "SQLServer" under optional.

    Pay attention, there is one word of "SQLSERVER"

    Roger

    Tuesday, August 20, 2013 7:14 AM
  • Hi,

    I done with SQL Role option.

    Regards,

    SandeepK

    • Marked as answer by sandeepk Wednesday, August 21, 2013 7:19 PM
    Wednesday, August 21, 2013 7:18 PM