Verify Source and Destination Database Reside on Same Server

Contact your SQL ServerĀ® DBA and have them verify both the source and destination databases reside within the same SQL ServerĀ® instance. In the following image, we have verified both the source (TDA) and the destination (2008_Archive_Toxicall) reside in the same (CASSQL) server instance.

Rounded Rectangular Callout: Both databases reside under same server instance (CASSQL)Rounded Rectangular Callout: Destination Database (Archive)Rounded Rectangular Callout: Source Database (Network)