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).
bryancmx5Asked:
Who is Participating?
 
grayeConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.