Karthikeyan

sqlserver "logfile_usage" alert

Discussion created by Karthikeyan on Sep 1, 2014
Latest reply on Sep 8, 2017 by sirajdn

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

Outcomes