https://community.qlik.com/t5/Data-Movement-Streaming/Unable-to-Create-SQL-Server-Direct-Gateway-Access-Connection/m-p/2470747#M2488 <P>I have a configured Direct Access Gateway, but the following error persists when trying to connect on-premise SQL Server;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Error when testing conncection" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169374i308798F1E2330884/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2024-07-15 102417.png" alt="Error when testing conncection" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Error when testing conncection</span></span></P> <P>&nbsp;</P> <P><STRONG>My checks in the Direct Access Agent logs shows the following;</STRONG></P> <P><EM><SPAN class="management-console-seed-qmfe-management-console-1228 management-console-seed-qmfe-management-console-1236">An error occurred trying to start process 'C:\Program Files\Qlik\ConnectorAgent\dcaas_gs\StartDcaaS.bat' with working directory 'C:\Program Files\Qlik\ConnectorAgent\dcaas_gs'. Access is denied.</SPAN><SPAN class="management-console-seed-qmfe-management-console-1228 management-console-seed-qmfe-management-console-1236"> at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)</SPAN><SPAN class="management-console-seed-qmfe-management-console-1228 management-console-seed-qmfe-management-console-1236"> at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)</SPAN><SPAN class="management-console-seed-qmfe-management-console-1228 management-console-seed-qmfe-management-console-1236" title=" at Qlik.ConnectorAgent.DependentProcessManager.StartProcess(DependentProcessRegistration registration, DependentProcessInstance existingInstance)"> at Qlik.ConnectorAgent.DependentProcessManager.StartProcess(DependentProcessRegistration registration, DependentProcessInstance existingInstance)</SPAN></EM></P> Wed, 19 Mar 2025 21:58:43 GMT dennismachel 2025-03-19T21:58:43Z https://community.qlik.com/t5/Data-Movement-Streaming/Unable-to-Create-SQL-Server-Direct-Gateway-Access-Connection/m-p/2470747#M2488 <P>I have a configured Direct Access Gateway, but the following error persists when trying to connect on-premise SQL Server;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Error when testing conncection" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/169374i308798F1E2330884/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2024-07-15 102417.png" alt="Error when testing conncection" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Error when testing conncection</span></span></P> <P>&nbsp;</P> <P><STRONG>My checks in the Direct Access Agent logs shows the following;</STRONG></P> <P><EM><SPAN class="management-console-seed-qmfe-management-console-1228 management-console-seed-qmfe-management-console-1236">An error occurred trying to start process 'C:\Program Files\Qlik\ConnectorAgent\dcaas_gs\StartDcaaS.bat' with working directory 'C:\Program Files\Qlik\ConnectorAgent\dcaas_gs'. Access is denied.</SPAN><SPAN class="management-console-seed-qmfe-management-console-1228 management-console-seed-qmfe-management-console-1236"> at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)</SPAN><SPAN class="management-console-seed-qmfe-management-console-1228 management-console-seed-qmfe-management-console-1236"> at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)</SPAN><SPAN class="management-console-seed-qmfe-management-console-1228 management-console-seed-qmfe-management-console-1236" title=" at Qlik.ConnectorAgent.DependentProcessManager.StartProcess(DependentProcessRegistration registration, DependentProcessInstance existingInstance)"> at Qlik.ConnectorAgent.DependentProcessManager.StartProcess(DependentProcessRegistration registration, DependentProcessInstance existingInstance)</SPAN></EM></P> Wed, 19 Mar 2025 21:58:43 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Unable-to-Create-SQL-Server-Direct-Gateway-Access-Connection/m-p/2470747#M2488 dennismachel 2025-03-19T21:58:43Z