<div>
<div class="content wysiwyg-content">
I have one database on a 64-bit version of SQL Server 2008. &nbsp;I have another &quot;Linked Server&quot; in my 32-bit SQL Express instance on the same server. &nbsp;<br />
<br />
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. &nbsp;<br />
<br />
My other option was to use join statements to connect the two, but that doesn't seem to work, either. &nbsp;<br />
<br />
How can I get the 32-bit piece to talk to the 64-bit piece? &nbsp;I can see both of them in my SQL Mgmt Studio, obviously in separate connections to the SQL instances.
</div>
</div>


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.

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.