https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2793#M1274 <P>Looks like it is unable to create a working directory which is required to persist some data for temporay use. Please see this https://docs.workato.com/on-prem/agents/profile.html#connection-profiles</P> Thu, 28 Apr 2022 17:35:55 GMT philipp-schone 2022-04-28T17:35:55Z https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2788#M1269 <BR /><P></P><BR /> Thu, 28 Apr 2022 14:40:34 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2788#M1269 andrian-davinta 2022-04-28T14:40:34Z https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2789#M1270 <P>Is this Database on Premise? If yes you need to select the Gateway (OPA). If this is a cloud instance you need to provide a FQDN (full qualified domain name). In your config you just have a simple Hostname </P> Thu, 28 Apr 2022 14:50:28 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2789#M1270 philipp-schone 2022-04-28T14:50:28Z https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2790#M1271 <P>This Link explains the OnPremise Config https://docs.workato.com/on-prem/agents/connection.html</P> Thu, 28 Apr 2022 14:51:49 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2790#M1271 philipp-schone 2022-04-28T14:51:49Z https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2791#M1272 <P>We can't connect my SQL directly to the workato, you can connect using the on-prem agent.</P> Thu, 28 Apr 2022 15:29:15 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2791#M1272 muniraja-katuru 2022-04-28T15:29:15Z https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2792#M1273 <P>thanks for the help, i tried to setup on prem agent, any suggestions? </P><P></P><BR /> Thu, 28 Apr 2022 16:34:33 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2792#M1273 andrian-davinta 2022-04-28T16:34:33Z https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2793#M1274 <P>Looks like it is unable to create a working directory which is required to persist some data for temporay use. Please see this https://docs.workato.com/on-prem/agents/profile.html#connection-profiles</P> Thu, 28 Apr 2022 17:35:55 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2793#M1274 philipp-schone 2022-04-28T17:35:55Z https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2794#M1275 <P>Hi Andrian, you need to specifically create the work directory</P> Fri, 29 Apr 2022 07:04:43 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2794#M1275 bcastro 2022-04-29T07:04:43Z https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2795#M1276 <P>Thankyou everyone for the help, i have successfully connect my sql server with on prem agent. Thanks a lot.</P> Fri, 29 Apr 2022 14:42:17 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2795#M1276 andrian-davinta 2022-04-29T14:42:17Z https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2796#M1277 <DIV dir="auto">I suspect it cannot resolve your local SQL server name/address.</DIV><DIV id="ms-outlook-mobile-signature" dir="auto"><DIV><BR /></DIV><DIV dir="auto">O guess you need some address translation to point to your local SQL server.</DIV></DIV><DIV dir="auto" id="mail-editor-reference-message-container"><BR /><HR tabindex="-1" /><DIV id="divRplyFwdMsg"></DIV></DIV> Fri, 29 Apr 2022 15:28:01 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/solved-hi-everyone-i-m-trying-to-connect-my-sql-server-to/m-p/2796#M1277 james-chan 2022-04-29T15:28:01Z