• State Verified Answer
  • Locked Locked
  • Replies 1 reply
  • Subscribers 94 subscribers
  • Views 2725 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

6.1.2 Load AD mapping rule error

Kerry Barnes
over 8 years ago

I have successfully imported a domain using the wizard over 12 months ago using a Job Server on the domain controller. The domain controller is remote from the SQL server behind firewalls etc. The job server itself can poll the SQL server for it's queue and process jobs. The issue is when the Import mapping Write Definitions SQL is executed. The process fails with

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

We have entries in the local hosts file for the SQL server name, NetBIOS and fqdn. And since the job service polls happily it's not a firewall routing issue. Is there anyway we can further log what is happening. I can see netstat -n -p tcp has time_wait on connections so it has opened a connection.

Thanks