on 12-02-2014 11:48 AM
Hello folks,
While checking the status on a machine, I noticed these entries in Windows log (eventvwr):
Text is:
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
These messages come from SQL Server:
Messages appear each 15 minutes. I monitored the activity at DB level on these moments using sys.dm_exec_requests queries but nothing came up.
Using Profiler, I set up a general trace and found the PID who was launching command sp_configure. Using Sysinternals' Process Explorer, I identified the PID as an instance of sapdbctrl.exe started by SAP Host Agent.
I ensured that these messages were being caused by this program. If SAP Host Agent is stopped or sapdbctrl.exe is not present (renamed to .exe.bak, for example) the messages no longer appear.Also the reconfigure command is always being executed:
OS is Microsoft Windows Server 2008 R2 Standard SP1
DB is Microsoft SQL Server 2008 R2 Service Pack 1 CU1
SAPHOSTAGENT is SAPHOSTAGENT 720 SP 73
Is there any way to avoid these messages?
Thanks in advance and best regards.
José Enrique
Hi Jose
Event ID 15457 is just information, its not warning or error, you can refer the Microsoft link with same issue
SQL server agent- agent Xps disabled
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sriram,
Thanks for your answer.
I am aware that the messages don't pose any threat but I would like to have only relevant messages in the log (whenever possible).
I think that when config_value matches run_value in SQL Server the message asking for RECONFIGURE should not be issued.
Likewise, SAP Host Agent should verify whether the advanced options are being shown before executing the sp_configure command.
Any of these two behaviors would suffice, but I don't know whether it is even possible to configure them.
Best regards,
José Enrique
Hi Jose
Thanks for info
1. Is it possible to raise the support ticket to Microsoft. to check this message. In my view it may be missing some of MS Sql Service pack or windows update.
The same message appeared in my system last year.
2. On your system which version & release of kernel used?
BR
SS
Hi Sriram,
We don't have direct support with Microsoft and the issue is not even a problem, its more of a matter of aesthetics.
Versions are:
OS is Microsoft Windows Server 2008 R2 Standard SP1
DB is Microsoft SQL Server 2008 R2 Service Pack 1 CU1
SAPHOSTAGENT is SAPHOSTAGENT 720 SP 73
Best regards,
José Enrique
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.