A “Error 404” error is encountered when linking a database to Team Foundation Server in a different domain from the host

Applies to
ApexSQL Source Control

Symptoms
During the process of a database linking to Team Foundation Server located in a different domain from the host machine, ApexSQL Source Control will not be able to resolve a DNS address and an error will be thrown:

Affected versions
ApexSQL Source Control 2015.03.0065 and earlier

Workaround
To prevent the above mentioned error and be able to link a database to Team Foundation Server located on a different domain:

  1. Close SQL Server Management Studio

  2. Navigate to the hosts file located in %systemroot%\system32\drivers\etc\

  3. Open the hosts file in an editor and input a Team Foundation Server IP and a corresponding DNS address

  4. Save the hosts file and close the editor
  5. Start SQL Server Management Studio and link a database to Team Foundation Server

Planned Resolution
ApexSQL is currently working to fix this issue permanently

Related posts:

  1. ApexSQL Source Control shared database model doesn’t work after update
  2. Restore job fails during the log shipping process and the ‘System.Data.SqlClient.SqlError: …. An earlier log backup that includes LSN can be restored.’ error is encountered
  3. “Check-in failed Source control error: Cannot checkin pending changes” error
  4. The “The server <server_name> doesn’t exist in the database” error is encountered when disabling the monitored SQL Server
  5. The “System.FormatException” error is encountered when documenting a specific database