souje03

Permissions for SQL Server Probe

Discussion created by souje03 Employee on Nov 22, 2013
Latest reply on Nov 26, 2013 by craig.schotke

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

Outcomes