Test connection error on SQL asset when using Directory Service Account
说明
When trying to use a domain account to manage the SQL asset, Test connection fails with the error below:
Task History Queuing task. Starting task. A fully qualified hostname that can be resolved by DNS is required to connect with asset SQLSERVERNAME. Unable to log in to the asset using service account {DiectoryServiceAccount} System connection test failed. Connecting with asset SQLSERVERNAME (x.x.x.x). Connecting to Server x.x.x.x:1433 using TCP/IP connection as Windows/AD user {domain\DiectoryServiceAccount}. Saving task results. Task completed with failure.
原因
Network Address is configured with IP address
解决办法
Configure network address using the Fully qualified Domain name of the SQL Server instead of IP address