My Oracle Support Banner

EM 13c MS SQL Server Databases page blank (Doc ID 2442675.1)

Last updated on SEPTEMBER 17, 2021

Applies to:

Enterprise Manager for Miscellaneous Plug-ins - Version 13.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms


MS SQL DB discovered successfully and it is showing as up but the tenant DBs list showing as blank in DB home page under databases tab.

Create a Non-Sysadmin user and provide below permission. here will monitor only few Databases not all DBs.

a. Execute this command to give access to the user:
b. GRANT VIEW SERVER STATE TO "login name"
c. Provide database access to the user.(which needs to be monitored)
d. Provide SQLAgentOperatorRole fixed database role in msdb to the user.
 

The Below screen shot will confirms that the Databases tab showing as blank

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.