<p>I'm using keda in my k8s cluster for autoscaling. After deploying my scaled object with MSSQL trigger , I'm getting ready and active status as unknown.. In logs I'm only seeing that it's trying to create a HPA and then nothing happens. I guess the keda-operator is getting stuck here as I'm not getting any updates on logs.</p>
<p><a href="https://i.stack.imgur.com/ndhIX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ndhIX.png" alt="Scaledobject status" /></a></p>
<p>My ScaledObject:</p>
<p><a href="https://i.stack.imgur.com/oV3rz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oV3rz.png" alt="Scaledobject" /></a></p>
<p>On query execution, I'm getting value as 300 which is enough to initate scaling.</p>
<p>Also I'm attaching operator logs :
2021-06-04T08:06:20.130Z INFO controller Starting EventSource {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;ScaledJob&quot;, &quot;controller&quot;: &quot;scaledjob&quot;, &quot;source&quot;: &quot;kind source: /, Kind=&quot;}
2021-06-04T08:06:20.130Z INFO controller Starting EventSource {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;ScaledObject&quot;, &quot;controller&quot;: &quot;scaledobject&quot;, &quot;source&quot;: &quot;kind source: /, Kind=&quot;}
2021-06-04T08:06:20.130Z INFO controller Starting EventSource {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;TriggerAuthentication&quot;, &quot;controller&quot;: &quot;triggerauthentication&quot;, &quot;source&quot;: &quot;kind source: /, Kind=&quot;}
2021-06-04T08:06:20.230Z INFO controller Starting Controller {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;ClusterTriggerAuthentication&quot;, &quot;controller&quot;: &quot;clustertriggerauthentication&quot;}
2021-06-04T08:06:20.230Z INFO controller Starting workers {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;ClusterTriggerAuthentication&quot;, &quot;controller&quot;: &quot;clustertriggerauthentication&quot;, &quot;worker count&quot;: 1}
2021-06-04T08:06:20.230Z INFO controller Starting Controller {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;TriggerAuthentication&quot;, &quot;controller&quot;: &quot;triggerauthentication&quot;}
2021-06-04T08:06:20.230Z INFO controller Starting workers {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;TriggerAuthentication&quot;, &quot;controller&quot;: &quot;triggerauthentication&quot;, &quot;worker count&quot;: 1}
2021-06-04T08:06:20.230Z INFO controller Starting EventSource {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;ScaledObject&quot;, &quot;controller&quot;: &quot;scaledobject&quot;, &quot;source&quot;: &quot;kind source: /, Kind=&quot;}
2021-06-04T08:06:20.232Z INFO controller Starting Controller {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;ScaledJob&quot;, &quot;controller&quot;: &quot;scaledjob&quot;}
2021-06-04T08:06:20.330Z INFO controller Starting Controller {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;ScaledObject&quot;, &quot;controller&quot;: &quot;scaledobject&quot;}
2021-06-04T08:06:20.331Z INFO controller Starting workers {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;ScaledObject&quot;, &quot;controller&quot;: &quot;scaledobject&quot;, &quot;worker count&quot;: 1}
2021-06-04T08:06:20.332Z INFO controller Starting workers {&quot;reconcilerGroup&quot;: &quot;keda.sh&quot;, &quot;reconcilerKind&quot;: &quot;ScaledJob&quot;, &quot;controller&quot;: &quot;scaledjob&quot;, &quot;worker count&quot;: 1}
2021-06-04T08:07:19.986Z INFO controllers.ScaledObject Reconciling ScaledObject {&quot;ScaledObject.Namespace&quot;: &quot;xyz&quot;, &quot;ScaledObject.Name&quot;: &quot;mssql-keda-scaledobject&quot;}
2021-06-04T08:07:19.986Z INFO controllers.ScaledObject Adding Finalizer for the ScaledObject {&quot;ScaledObject.Namespace&quot;: &quot;xyz&quot;, &quot;ScaledObject.Name&quot;: &quot;mssql-keda-scaledobject&quot;}
2021-06-04T08:07:20.052Z INFO controllers.ScaledObject Detected resource targeted for scaling {&quot;ScaledObject.Namespace&quot;: &quot;xyz&quot;, &quot;ScaledObject.Name&quot;: &quot;mssql-keda-scaledobject&quot;, &quot;resource&quot;: &quot;apps/v1.Deployment&quot;, &quot;name&quot;: &quot;xyzxyzxyzxyzxyzxyzxyz&quot;}
2021-06-04T08:07:20.052Z INFO controllers.ScaledObject Creating a new HPA {&quot;ScaledObject.Namespace&quot;: &quot;xyz&quot;, &quot;ScaledObject.Name&quot;: &quot;mssql-keda-scaledobject&quot;, &quot;HPA.Namespace&quot;: &quot;xyz&quot;, &quot;HPA.Name&quot;: &quot;keda-hpa-mssql-keda-scaledobject&quot;}</p>
<p>I'm getting hpa created for other scaled objects. Also if I'm providing sql connection credentials wrong, I'm getting appropriate authentication error. So I guess this is not a connection issue.</p>
<p>Any leads would be greatly appreciated. Thanks in advance</p>

Savitha
<p>I also had issues when I started using the MSSQL Trigger for KEDA on an Azure Function app in Azure Kubernetes Service.</p>
<p>I faced a couple issues so you could try checking these out as well:</p>
<p><strong>KEDA VERSION</strong></p>
<p>KEDA version 2.2 was the first version to support the MSSQL trigger, I had to get the operator logs for keda-operator to figure out that the MSSQL trigger could not be found using version 2.1 of KEDA. Your operator logs don't seem to say &quot;cannot find trigger MSSQL&quot; but you could double check. I have had the best luck with KEDA 2.4 which you can install using these instructions: <a href="https://keda.sh/docs/2.4/deploy/" rel="nofollow noreferrer">https://keda.sh/docs/2.4/deploy/</a></p>
<p><strong>Troubleshooting ScaledObject Issues</strong></p>
<p>You can start by finding the name of your ScaledObject with</p>
<pre><code>kubectl get scaledobject -A
</code></pre>
<p>Then describe the ScaledObject, and you should see any errors or issues listed towards the bottom such as authentication issues or issues creating an HPA for KEDA:</p>
<pre><code>kubectl describe scaledobject &lt;your-scaled-object-name&gt; 
</code></pre>
<p>Ultimately my issue required installing the right version of KEDA, and also modifying my MSSQL connection string.</p>
