Jump to content
Microsoft Windows Bulletin Board

Recommended Posts

Posted

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 agent

name: 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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...