When synchronizing passwords using the NDS Migrator NDSPSK website, the process may fail with the following error:
Account Migration Failed
Furthermore, in the passwordsync log file, the following is seen:
SQL Server does not exist or access denied
This error can be caused if the NDS Migrator database has been installed as a seperate instance, rather than using the default instance. For example, NDS_SQL\Quest rather than NDS_SQL.
If the above is true, then during installation of NDS Migrator, a registry key is set incorrectly to ignore the instance name. This causes an incorrect call to the db provider, and results in the SQL error.
To resolve the issue, browse to the following registry key:
HKLM\Software\Quest Software\NDS Migrator\4.2\Database - PswdSyncDBServer
Here you will notice that the string for "Data Source =" will not take into account the instance name. This must be changed from Data Source = Servername to Data Source = Servername\Instance where the correct server and instance are specified.
The password sync process can now be retried and should complete successfully.
Quest does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 "Description of the Microsoft Windows registry": http://support.microsoft.com/default.aspx?kbid=256986.
If the above solution provided does not seem to help resolve the issue this may be related to missing DNS records for the Netbios domain name. NDS Migrator attempts to resolve the LDAP binding for AD users through ldap://DOMAIN/ldap-path; and the query fails because DOMAIN does not resolve through DNS correctly.