I want to add a managed SQL Server in a untrusted Domain. Between both domains a firewall is active.A Connection test at the end of "Add Servers" wizard fails.
I can ping the target machine from diagnostic Manager Server, tcp port is open. MSMS on diagnostic Manager server connects successfully to target machine.Used SQL Login has sysadmin rights. Anything else I missed to configure for successfully manage this Server?Are there any logfiles written while connection test?
thanks a lot
I remember having some issues in the past with certain servers. The workaround that worked, was creating a SQL Client Alias on the server where the SQLdm collection service is installed. You can do that with the cliconfg.exe.
Instead of the DNS-Name you may also enter an IP-Address.
Be aware that there are 2 cliconfg.exe, one for 32-bit and one for 64-bit (default). If you have the 32-bit Version of SQLdm installed you need the one from SysWOW64.