SQLSERVERSENSOR documentation lacking all permissions required

Technote (troubleshooting)


Problem(Abstract)

When attempting to discover a Microsoft SQL Server 2008 SP3 (Enterprise Edition)
none of the "Primary Data Files" were discovered for the databases/modules.

Cause

It was discovered that the "VIEW_ANY_DEFINITION" permission was missing from the service account. The only permission specified in the Sensor Guide was "db_datareader"

Resolving the problem

Add the "VIEW_ANY_DEFINITION" permission to the service account user.

Product Alias/Synonym

TADDM

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Application Dependency Discovery Manager

Software version:

7.2.2

Operating system(s):

Windows

Reference #:

1643767

Modified date:

2014-06-10

Translate my page

Machine Translation

Content navigation