[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • 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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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