Morpheus7
asked on
Linked servers
Hi,
Is there a way to create a SQL linked server from SQL Server 2016 to SQL Server 2005?
Many thanks
Is there a way to create a SQL linked server from SQL Server 2016 to SQL Server 2005?
Many thanks
Last Comment
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. "
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. "
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Here's the MSDN article that explains how to do it.