Same database instances appears twice in Application View

Issue

A single instance of a Microsoft SQL or DB2 database is displayed as two separate members in the Application View, once with the database name in the form of host:port/schema, and once with the connection string.

Probable cause

Within a selected five-minute period, a Microsoft SQL or DB2 database instance receives some requests that successfully connect to the database and some requests which fail to connect to the database. When a request cannot connect to the database, the database name appears as the connection string. If the five-minute period comprises requests that successfully connect and requests that fail to connect, the database appears as two separate members.

Failed requests might be caused by a user error (such as database credentials), an offline database, or other reasons.

Resolution

• Confirm that requests have the required database credentials.
• Confirm that the database is online.