DX Unified Infrastructure Management

  • 1.  Permissions for SQL Server Probe

    Broadcom Employee
    Posted Nov 21, 2013 10:12 PM

    Hi all,
    someone know what permissions are really necessary for SQL server monitoring?
    I made all configurations that are listed on oficial doc but I get a error message to collect some informations that seems to be a permission problem.
    I tryed to use a user with sysadmin and its worked, but I can´t use sysadmin,
    So I need to give just the permission that is really necessary.
    This is the error message:
    Nov 21 17:05:15:464 [6092] sqlserver: Profile: ipbtbdbman01\default/fg_freeSpace_with_avail_disk/Run Query - DB Provider: Code=0x80040e14 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]There is already an object named '#temptab' in the database.

    Thanks



  • 2.  Re: Permissions for SQL Server Probe

    Posted Nov 25, 2013 10:45 PM

    I got the following from support earlier in the year:

     

    For SQL Server versions 9 and 10: 

    set VIEW SERVER STATE permission on master database. Also GRANT SELECT permission to a user for these tables 
    Table Names 
    master.sys.databases 
    master.dbo.sysperfinfo 
    msdb.dbo.sysjobsteps 
    msdb.dbo.sysjobs 
    .sys.database_files 
    .sys.partitions 
    .sys.allocation_units 
    .sys.internal_tables 
    .sys.filegroups 

    For SQL Server version 8: 

    GRANT SELECT permission to a user for these tables 

    Table Names 
    master.dbo.sysprocesses 
    master.dbo.sysperfinfo 
    master.dbo.sysdatabases 
    msdb.dbo.backupset 
    master.dbo.sysfiles 
    master.dbo.sysindexes 
    master.dbo.sysfilegroups