Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-11-01
1
Medium Priority
?
315 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 72

Accepted Solution

by:
Qlemo earned 2000 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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.
Suggested Courses

578 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