Microsoft SQL 凭证#

您可以使用这些凭证来验证以下节点：

Microsoft SQL

先决条件#

在 Microsoft SQL 服务器数据库上创建用户账户。

支持的身份验证方法#

SQL 数据库连接

使用 SQL 数据库连接#

要配置此凭证，您需要：

Server 名称
Database 名称
您的 User 账户/ID
您的 Password
用于连接的 Port
Domain 名称
是否使用 TLS
是否 Ignore SSL Issues
Connect Timeout
Request Timeout
连接应使用的 TDS Version

要设置数据库连接：

将 SQL Server 主机名输入为 Server。在现有的 SQL Server 连接中，主机名位于实例名之前，格式为 HOSTNAME\INSTANCENAME。查找主机名：
- 在 Object Explorer 窗格中作为数据库的顶级对象。
- 在查询窗口的页脚中。
- 查看当前连接的 Properties 并查找 Name 或 Display Name。
- 请参考 Find SQL Server Instance Name | When you're connected to SQL Server for more information. You can also find the information in the Error logs.
将 SQL Server 实例名输入为 Database 名称。使用上面列出的查找主机名的相同步骤来查找此名称。
- 如果您在任何这些地方都看不到实例名，那么您的数据库使用默认的 MSSQLSERVER 实例名。
输入您的 User 账户名或 ID。
输入您的 Password。
对于 Port：
- SQL Server 默认为 1433。
- If you can't connect over port 1433, check the Error logs for the phrase Server is listening on to identify the port number you should enter.
You only need to enter the Domain name if users in multiple domains access your database. Run this SQL query to get the domain name:
1
SELECT DEFAULT_DOMAIN()[DomainName];
Select whether to use TLS.
Select whether to Ignore SSL Issues: If turned on, the credential will connect even if SSL certificate validation fails.
Enter the number of milliseconds n8n should attempt the initial connection to complete before disconnecting as the Connect Timeout. Refer to the SqlConnection.ConnectionTimeout property documentation for more information.
- SQL Server stores this timeout as seconds, while n8n stores it as milliseconds. If you're copying your SQL Server defaults, multiple by 100 before entering the number here.
Enter the number of milliseconds n8n should wait on a given request before timing out as the Request Timeout. This is basically a query timeout parameter. Refer to Troubleshoot query time-out errors for more information.
Select the Tabular Data Stream (TDS) protocol to use from the TDS Version dropdown. If the server doesn't support the version you select here, the connection uses a negotiated alternate version. Refer to Appendix A: Product Behavior for a more detailed breakdown of the TDS versions' compatibility with different SQL Server versions and .NET frameworks. Options include:
- 7_4 (SQL Server 2012 ~ 2019): TDS version 7.4.
- 7_3_B (SQL Server 2008R2): TDS version 7.3.B.
- 7_3_A (SQL Server 2008): TDS version 7.3.A.
- 7_2 (SQL Server 2005): TDS version 7.2.
- 7_1 (SQL Server 2000): TDS version 7.1.