自托管的集成运行时无法在PREM SQL SERVE上访问
我已经成功地创建了自托管的集成运行时，它也在ADF中显示并运行。
但是，当我尝试创建一个链接服务以连接到ON PERM系统上的SQL数据库时 - 我会收到以下错误：
无法连接到SQL数据库：'（localdb）\ mssqllocaldb'，数据库：'xxxx'，用户：'xxxxx'。 检查链接的服务配置是正确的，并确保SQL数据库防火墙允许集成运行时访问。 无法打开登录请求的数据库“ xxxx”。登录失败。 用户“ NT Service \ DihoStservice'。
I have successfully created the Self Hosted Integration Runtime and it is showing up and running in ADF as well.
However when I try to create a linked service to connect to SQL database on the on prem system - I am getting the below error:
Cannot connect to SQL Database: '(localdb)\mssqllocaldb', Database: 'XXXX', User: 'XXXXX'.
Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.
Cannot open database "XXXX" requested by the login. The login failed.
Login failed for user 'NT SERVICE\DIAHostService'., SqlErrorNumber=4060,Class=11,State=1..
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
这不是防火墙错误，这是身份验证错误。
您尚未批准Windows用户帐户
nt Service \ DihoStservice访问数据库。这个问题与该问题相同，该问题具有有关如何解决的说明：
用户'iis apppool \ asp.net v4.0'
登录
This is not a firewall error this is an authentication error.
You have not granted that windows user account
NT SERVICE\DIAHostServiceaccess to your database.This issue is identical to this one, which has instructions on how to solve:
Login failed for user 'IIS APPPOOL\ASP.NET v4.0'
To select data from a table in SQL Server you need three things set up:
请执行以下操作：
允许两个Windows防火墙上的端口1433上出站TCP通信[
windows-firewall-stup ]和公司防火墙[ ports-and-firewalls ]
配置SQL数据库的防火墙设置自托管集成运行时计算机的IP地址到允许的IP地址列表。
shir设置
Please do the below :
Allow outbound TCP communication on port 1433 for both the Windows firewall [
Windows-firewall-setup ] and the corporate firewall [ Ports-and-firewalls ]
Configure the firewall settings of the SQL Database to add the IP address of the self-hosted integration runtime machine to the list of allowed IP addresses.
SHIR setup reference