Lesson Learned #87: Connecting from SQL Server 2008/R2 to Managed Instance using Linked Server.
Published Jun 01 2019 05:01 AM 3,159 Views

 

 

Hello Team,

 

As you know, the support of SQL Server 2008 and SQL Server 2008 R2 is approaching to the end and some customers are using Linked Server to connect to Azure SQL Managed Instance for sending or retrieving data. We found a particular error message here and we explain how to fix it.

 

In this situation our customer tried to send data from SQL Server 2008 to Azure SQL Managed Instance using linked server but they got the error messages at the moment of the definition, using multiple providers Microsoft OLE DB Provider for SQL Server or SQL Server Native Client 10.0

 

  • Server name not found
  • Server name needs to be the same in the connection string
  • Server name cannot be determined. It must appear as the first segment of the server's dns name). etc..

 

Capture.PNG

 

The workaround used to be able to connect was specifying the connection string of Azure SQL Managed instance in the provider string section of the linked server definition without password parameter.

 

Enjoy!!!

1 Comment
Version history
Last update:
‎Jun 01 2019 05:01 AM
Updated by: