Solved

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

Posted on 2008-10-08
2
265 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
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

911 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now