Ok I found it… and reading it… I think you should leave that enabled.
This is Database specific not server setting.
Notice Auto Close.
This is an old article and it advocates for not enabling this setting.
@emre what is your thought? Is this something you designed SambaPOS to enable? if so why?
I want to point out that even WITH this setting enabled it is certainly not closing on EVERY query. It has a timeout feature.
“By default, databases created by SQL Server aren’t set to AutoClose by default (unless your model database has been explicitly set to enable AutoClose)”
"And, in the case of databases that were designed to be deployed on mobile laptops without full-blown ‘server’ capabilities, I think you COULD argue that it sort of makes sense that AutoClose might be beneficial. "
That last quote makes sense to me.