After adding a resource mapping to a credential for SQL Server agent and associated host, the new SQL Server agent can't find the credential using these new resource mappings.
Resource mappings were created manually just like the default created by the Database Dashboard wizard.
Usage equals 'WMI Connection for DB Monitoring' AND Target Host Name is domain name 'SQLSERVERHOST_NEW' AND Agent Name equals 'SQLSERVERHOST_NEW-INSTANCE'
Agent log shows this error:
com.quest.qsi.fason.core.errorhandling.AgentConnectionException: No credentials were provided to establish a connection to host SQLSERVERHOST_NEW- Profile:FglAM Connection Profile {Host = SQLSERVERHOST_NEW, Agent = SQLSERVERHOST_NEW-INSTANCE}at com.quest.qsi.fason.sqlserver.agent.SqlServerAgentDataDelegate.internalGetWmiConnection(SqlServerAgentDataDelegate.java:643)at com.quest.qsi.fason.sqlserver.agent.SqlServerAgentDataDelegate.getWmiConnection(SqlServerAgentDataDelegate.java:591)at com.quest.qsi.fason.sqlserver.agent.SqlServerAgentData.getWmiConnection(SqlServerAgentData.java:389)at com.quest.qsi.fason.sqlserver.services.spi.SqlServerSPIController.getWmiConnection(SqlServerSPIController.java:227)at com.quest.qsi.fason.sqlserver.common.spi.BaseSpiController.execute0(BaseSpiController.java:247)at com.quest.qsi.fason.sqlserver.services.spi.SqlServerSPIController.execute0(SqlServerSPIController.java:222)at com.quest.qsi.fason.sqlserver.common.spi.BaseSpiController.execute(BaseSpiController.java:175)at com.quest.qsi.fason.sqlserver.common.spi.BaseSpiServiceFactory$2.execute(BaseSpiServiceFactory.java:98)at com.dell.dsgi.spi.engine.base.changeTracking.collection.system.WmiChangeTrackingCollection.query(WmiChangeTrackingCollection.java:41)at com.dell.dsgi.spi.engine.base.changeTracking.collection.system.WmiJoinChangeTrackingCollection.getRecordsMap(WmiJoinChangeTrackingCollection.java:98)at com.dell.dsgi.spi.engine.base.changeTracking.collection.system.WmiJoinChangeTrackingCollection.query(WmiJoinChangeTrackingCollection.java:46)at com.dell.dsgi.spi.engine.base.changeTracking.collection.SnapshotChangeTrackingCollection.collectCurrentState(SnapshotChangeTrackingCollection.java:169)at com.dell.dsgi.spi.engine.base.changeTracking.collection.SnapshotChangeTrackingCollection.collectChanges(SnapshotChangeTrackingCollection.java:63)at com.dell.dsgi.spi.engine.base.changeTracking.BaseChangeTrackingManager.collect(BaseChangeTrackingManager.java:112)at com.dell.dsgi.spi.engine.base.collection.BaseCollectionTask$1.run(BaseCollectionTask.java:117)Caused by: com.quest.qsi.fason.framework.connections.common.exceptions.FrameworkConnectionException: No credentials were provided to establish a connection to host SQLSERVERHOST_NEW- Profile:FglAM Connection Profile {Host = SQLSERVERHOST_NEW, Agent = SQLSERVERHOST_NEW-INSTANCE}at com.quest.qsi.fason.framework.connections.fglam.wmi.winrm.WinRMConnectionService.createNewConn
The FMS Support Bundle includes a DiagnosticSnapshot*.txt file that shows this event:
---- credential event ----
severity: WARN
error code: connection.nocredentialstimestamp: 1533144178301 (Wed Aug 01 13:22:58 EDT 2018)root cause: No credentials were provided to establish a connection to host SQLSERVERHOST_NEWagent id: 2287remote home: fglam_name.fqdn_name, 1a452f22-3ac8-4dbd-9fc5-7384232fc2ac, fglam_name.fqdn_namelockbox id: nullcredential id: nullpolicy id: null**Query Parameters**Query TimeStamp: 1533144157880Query Id: -1893802545lockbox IDs: []targetHostName: nulltargetAddress: nulltargetPort: 0sourceHostName: nullsourceAddress: nullpurpose: WindowsDBtypes: [com.quest.forge.credentials.type.localUser, com.quest.forge.credentials.type.windows]agent.name=SQLSERVERHOST_NEW-INSTANCE
---- credential mapping ----
credential id: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxrecords: nn[...] target.host.name: IDNA_EQUIVALENT: [SQLSERVERHOST_NEW], null matches: false AND property.agent.name: STRING_EXACT_MATCH: [SQLSERVERHOST_NEW-INSTANCE], null matches: false AND purpose: STRING_EXACT_MATCH: [WindowsDB], null matches: false
The credential query event listed in the Diagnostic Snapshot shows that the query passed null as targetHostName, but the resource mapping is defined as null matches: false.
The Database Dashboard Wizard creates these resource mappings with null matches:true.
Modify the resource mappings for Agent Name and Target Host Name and deselect the option "Evaluate This Condition".
