Solved

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

Posted on 2008-10-08
2
294 Views
Last Modified: 2010-04-21
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
Comment
Question by:bryancmx5
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 41

Accepted Solution

by:
graye earned 500 total points
ID: 22672977
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
 

Author Closing Comment

by:bryancmx5
ID: 31504334
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question