Windows Server Posted January 23 Posted January 23 we installed MS Sql Server 2022 standard edition DB at on-prem K8S cluster using helm chart (taken from: https://artifacthub.io/packages/helm/mssql/mssql/1.1.2 ) and added following configuration to helm chart(templates/primary/statefulset.yaml) to enable SQL Server agentname: MSSQL_AGENT_ENABLED value: "true"and was trying also to trigger from sa user:EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'Agent XPs', 1;RECONFIGURE; however, although SQL server agent is enabled, i'm still not able to start or stop it when login as sa user, what helm chart configuration or sql statement i can execute to start it? for example: View the full article Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.