Solved

Create linked server from 64-bit SQL to 32-bit SQL or use a join query

Posted on 2013-11-01
1
303 Views
Last Modified: 2013-11-20
I have one database on a 64-bit version of SQL Server 2008.  I have another "Linked Server" in my 32-bit SQL Express instance on the same server.  

I was going to try to create another linked server with my 64-bit instance to the 32-bit instance, but SQL Mgmt Studio isn't recognizing it.  

My other option was to use join statements to connect the two, but that doesn't seem to work, either.  

How can I get the 32-bit piece to talk to the 64-bit piece?  I can see both of them in my SQL Mgmt Studio, obviously in separate connections to the SQL instances.
0
Comment
Question by:saturation
[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
1 Comment
 
LVL 70

Accepted Solution

by:
Qlemo earned 500 total points
ID: 39618123
1. You can't use different instances in a join without having them defined as Linked Server.
2. Bitness does not matter for Linked Servers. However, you might have to use TCP explicitly to get it work between 32- and 64-bit instances on the same server.

Proving a full servername\instance as server might help; adding the port the other instance listens to could work, too:   servername,1555 (if 1555 is the listening port of that instance, see its network connection properties).
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

691 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