Hi All,
I could see the below mentioned alerts from some of the SQL servers being monitored by NIMSOFT. on checking the permissions from DB end, we could find all the permissions are given to the Nimsoft user. (some servers with similar permissions and configuration are fine without these alerts) please suggest what is to be done to fix this issue and the cause for this issue.
Profile XXXXX, checkpoint logfile_usage, query execution did not run successfully, error msg: Profile: Tup003/logfile_u
sage/(ProcessResult) - COM Error: Code=0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Server user 'nimmon' is not a valid user in database 'model'.
Profile: xxxxxxx /logfile_usage/Run Query - DB Provider: Code=0x0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][SQL Server]Server user 'nimmon' is not a valid user in database 'INF_ABERDEEN'.
Thanks,
Karthikeyan. R