We help IT Professionals succeed at work.

Linked servers


Is there a way to create a SQL linked server from SQL Server 2016 to SQL Server 2005?

Many thanks
Watch Question

Vitor MontalvãoIT Engineer
Distinguished Expert 2017

It's the same way that you create a linked server to another SQL Server instance.
Here's the MSDN article that explains how to do it.
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

For this you need to install the install the Native Client.

Read more from https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine

Note from above

" SQL Server distributed queries are designed to work with any OLE DB provider that implements the required OLE DB interfaces. However, SQL Server has been tested against only the SQL Server Native Client OLE DB Provider and certain other providers. "
IT Engineer
Distinguished Expert 2017
Since this is from a more recent SQL Server version (2016) to an old one (2005), I don't think you'll need to install nothing. The opposite would be true. But let us know about the outcome, ok?