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..
CodePudding user response：
The login failed. Login failed for user 'NT SERVICE\DIAHostService'.
This is not a firewall error this is an authentication error.
You have not granted that account access to your database. Is that the account you intend to use?
CodePudding user response：
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.