MS SQL server discovery 's MSSql DB On Windows Pattern is not able to create MSFT SQL Instance CIs if the instance name contains an underscore "_"


Description

Discovery's MSSql DB On Windows Pattern is not able to create MSFT SQL Instance CIs if the instance name contains an underscore "_" (underline, low line, low dash)
The "MSSQL populate database table" pattern library step 2 "Set parameter for Condition two - list db from wmi" is responsible.

Steps to Reproduce

  1. Install a SQL server database with and create SQL instance with "_" in it example: vin_inst
  2. Discovery of the SQL server.
  3. You will see the SQL server databases are not discovered running on the instance which has "_" in it.

Workaround

This problem has been fixed. If you are able to upgrade, review the Fixed In or Intended Fix Version fields to determine whether any versions have a planned or permanent fix.

The fix in Rome was to add fail over steps to remove '_' from instance name in case if the dbs are not discovered, update set attached


Related Problem: PRB1485278