https://community.databricks.com/t5/administration-architecture/databricks-connect-sql-server-login-error-with-all-purpose/m-p/91821#M1908 <P>Hello everyone,</P><P>I'm using the Databricks connect feature to connect to an SQL server on cloud.</P><P>I created a foreign catalog based on the connection&nbsp;but whenever I try to access the tables, I get a login error :&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="erigaud_0-1727337571433.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/11506i0FBCD3759B08CF32/image-size/medium?v=v2&amp;px=400" role="button" title="erigaud_0-1727337571433.png" alt="erigaud_0-1727337571433.png" /></span></P><P>I have tried with a serverless cluster and got a different error (firewall). When I added the ip of the serverless cluster to the networking configuration of the cloud database, I was able to connect without issue, showing that the credentials are correct.</P><P>Does someone have an idea as to why I'm seeing the login error ?&nbsp;</P><P>Thank you</P> Thu, 26 Sep 2024 08:00:53 GMT erigaud 2024-09-26T08:00:53Z https://community.databricks.com/t5/administration-architecture/databricks-connect-sql-server-login-error-with-all-purpose/m-p/91821#M1908 <P>Hello everyone,</P><P>I'm using the Databricks connect feature to connect to an SQL server on cloud.</P><P>I created a foreign catalog based on the connection&nbsp;but whenever I try to access the tables, I get a login error :&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="erigaud_0-1727337571433.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/11506i0FBCD3759B08CF32/image-size/medium?v=v2&amp;px=400" role="button" title="erigaud_0-1727337571433.png" alt="erigaud_0-1727337571433.png" /></span></P><P>I have tried with a serverless cluster and got a different error (firewall). When I added the ip of the serverless cluster to the networking configuration of the cloud database, I was able to connect without issue, showing that the credentials are correct.</P><P>Does someone have an idea as to why I'm seeing the login error ?&nbsp;</P><P>Thank you</P> Thu, 26 Sep 2024 08:00:53 GMT https://community.databricks.com/t5/administration-architecture/databricks-connect-sql-server-login-error-with-all-purpose/m-p/91821#M1908 erigaud 2024-09-26T08:00:53Z https://community.databricks.com/t5/administration-architecture/databricks-connect-sql-server-login-error-with-all-purpose/m-p/92424#M1948 <P>Solved.</P><P>Turns out it was a networking issue, once the subnets from databricks where allowed by the cloud sql server we managed to connect. The error message is misleading because the credentials were correct</P> Tue, 01 Oct 2024 11:40:01 GMT https://community.databricks.com/t5/administration-architecture/databricks-connect-sql-server-login-error-with-all-purpose/m-p/92424#M1948 erigaud 2024-10-01T11:40:01Z