通过Apache Spark连接 [英] Connecting via Apache Spark

问题描述

我们正在尝试使用Apache使用Apache Spark登录Azure SQL Server数据库但是我们收到以下错误：

We are trying to Login to Azure SQL Server Database using Apache Spark using JDBC but we are getting the following error:

com.microsoft.sqlserver.jdbc.SQLServerException：与主机npg-poc-server.database.windows.net，端口1433的TCP / IP连接失败。错误："连接超时。验证连接属性。确保SQL Server实例在主机上运行
并接受端口上的TCP / IP连接。确保防火墙不阻止与端口的TCP连接。"。

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host npg-poc-server.database.windows.net, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

推荐答案

嗨Debbie，

Hi Debbie,

有几种设置需要检查：

启用"允许访问Azure服务配置"选项后，它将更容易允许受信任的Azure服务连接到SQL Server实例。如果从Azure外部进行连接，则需要添加源目标的公共IP。
请参阅单个客户端AllowList的ClientAddr配置。

With the Allow access to Azure services configuration option enabled it makes it easier to allow trusted Azure services to connect to your SQL Server instance. If you are connecting from outside Azure, you need to add the Public IP of the source destination. See the ClientAddr configuration for individual client AllowList.

您可以通过SSMS与用户一起访问数据库吗？

Can you access the database with the user via SSMS?

Apache在哪里Spark连接器托管？

Where is the Apache Spark connector hosted?

感谢您提供更多详细信息。

Thank you for the additional details.

这篇关于通过Apache Spark连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！