I have installed SQL Server on a server(lets say Server1) which is joined to a domain in AD(lets say domain01), and I have another server(lets say server2) which is joined to another domaim(lets say domain02).
There is not any trusted connection between domain01 and domain02.
Now I want to install Microsoft AzureDevops on server2, in Database page, when I enter the SQL Server instance I get the following error:
login failed in initializing the provider
What I suspect, is the lack of trusted connection between domains(I am not sure). If I am true, is there any solution to solve this problem, without making both domains trust eachother?
I have tested the connection using udl file too, and got the same result for windows authentication method, however using SQL Server authetication, udl test connection is ok, but this option is not suitable for me.