June 5, 2024 at 4:05 pm
Hello experts,
I'm trying to disable (0) Ole Automation Procedures via sp_configure. But each time I do so, the next day the setting has been re-enabled (1).
I've tried a SQL trace but didn't catch it. Maybe I need to revise the trace. And there may be a Windows policy in place doing this but our Systems team hasn't found which one it could be.
Does anyone know how I can pinpoint the process that is re-enabling this setting?
Thanks for any help.
-- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 5, 2024 at 4:36 pm
check the sql server errorlog file
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 7, 2024 at 12:39 pm
What events are you capturing in the trace?
as pointed out already the sql server error log or windows application log will contain details, the error log event in the default trace will also show the host and user who ran the configuration change
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 28, 2024 at 3:41 am
Check the following:
a) Facets in SQL Server Management Studio (SSMS):
In SSMS, you can navigate to the server instance, right-click, and select “Facets.” Look for the “Surface Area Configuration” facet, where you’ll find the OleAutomationEnabled property. Ensure it’s set to “False” to disable Ole Automation Procedures.
b) Scheduled Jobs or Scripts
=======================================================================
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply