My SQL Configuration changes automatically

Is you SQL instance exposed on the internet? In such case, you need to fix that.

Exactly what do these log entries say? Changes to configuration options such as "Max server memory" manifest themselves in the SQL Server errorlog, but only the spid is logged, not the user. The default trace will also have the user information, but the information here is not kept for very long.

Hi @Jorge ,

HiI would like to know why my SQL configuration is changing automatically...

SQL configuration can't be changed automatically by itself unless someone trying to change it.
Try code as next and show scrrenshot of the result:

SELECT  
 T.DatabaseName,  
 T.TextData,  
 T.HostName,  
 T.ApplicationName,  
 T.LoginName,  
 T.StartTime,T.EventClass,  
    CASE T.IsSystem  
 WHEN 1 THEN 'YES'  
 ELSE 'NO'  
 END AS IsSystem  
FROM sys.FN_TRACE_GETTABLE(CONVERT(VARCHAR(150),   
 ( SELECT TOP 1 f.[VALUE]                                                   
   FROM    sys.FN_TRACE_GETINFO(NULL) f  
   WHERE   f.property = 2  
 )), DEFAULT) T  
  
WHERE T.TextData LIKE '%configuration option%'  
 AND T.EventClass = 22 -- Configuration related  
 Order by t.starttime desc;  

If the result is same as you use sql-server-ssms-configuration-changes-history

Please track the failed logins as this : audit-failed-sql-server-logins-part-iii-the-solution (note: you need to download one third party tool as the doc. describes)

And track the unauthorized configuration as this: spotting-unauthorized-configuration-settings-sql-server

BR,
Mia

If the answer is helpful, please click "Accept Answer" and upvote it.

Hi @Jorge ,

Is the reply helpful?

BR,
Mia

If the answer is helpful, please click "Accept Answer" and upvote it.