I'm trying to set up a linked service to a Microsoft SQL Server 2019 box that's in a remote location from my integration runtime node. I've confirmed the integration runtime node can remote to the vendors SQL box by connecting to it in SSMS.

When I go to create a linked service in azure data factory, I select SQL Server (on-premise), select my self hosted integration runtime, use SQL authentication, and have tried pointing the server at subdomain.domain.com\instance as well as 10x.10x.10x.10x,502xx and 10x.10x.10x.10x:502xx in case adf interprets ports differently, and continue to receive the error message:

Connection failed Cannot connect to SQL Database: '50.1xx.1xx.2xx,50xxx', Database: 'YourRemoteDatabase', User: 'SQLAuthUser'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. Cannot open database "YourRemoteDatabase" requested by the login. The login failed. Login failed for user 'SQLAuthUser'., SqlErrorNumber=4060,Class=11,State=1, Activity ID: 6a792f26-af68-4746-b222-47258...