Solved

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

Posted on 2013-11-01
1
302 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
1 Comment
 
LVL 69

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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

733 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