Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

Create Linked Server from MS SQL Server 2005 to Remote MS SQL Express 8

Does anything prevent the creation of a linked server to SQL Express 8 from MS SQL Server 2005?  We have successfully created linked server objects to other versions of SQL Server (not MySQL or SQL Express).
0
bryancmx5
Asked:
bryancmx5
1 Solution
 
grayeCommented:
Yes it is supported (at least from 2005 to 2005 Express).... all that's required on the remote end is the SQL Native Client OLE DB Provider (SQLNCLI)
0
 
bryancmx5Author Commented:
Thank you; looks like we were able to connect from a 2005 SQL 64-bit server, but not from any of our 2005 SQL 32-bit servers.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now