SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server

Following email is received from SQL Server Expert Roy Cheung. He faced issue of creating and running distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server. He has found solution and would like to share with SQLAuthority Blog Readers.

Hi Pinal,

Recently, I’ve a problem on create and run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server. The solution below works perfect for us, I think it is good to share.

http://support.microsoft.com/kb/906954

http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx

Thanks,
Roy

If you have tip or solution like this and would like to share with community, please send me email and I will list it on this blog.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

5 thoughts on “SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server

  1. Hi Dave,

    Its a gr8 feeling reading ur Articles & how deeply & in simple words u Explain various topics. Hatz off to ur Research & Efforts.

    I have a Query & i am quite sure u have a solution to it.

    I am facing a problem Trying to connect Remote servers SQL 2005 to SQL 2000 using Linked Server
    It was Easy on LAN but Over Internet i am Strugling Hard
    —Config—
    Server 1
    Windows Server 2003 SP2 —
    Sql Server 2005 Enterprise E. Version 9.00.3073.00

    Server 2
    Windows Server 2003 — Sql Server 2000
    ———
    I set the Linked Server with Same Server Name (Just for Safe check)
    Provider MS OLE DB for SServer
    Product Name : SQLOLEDB
    Security : Be made using the Security Context
    & username & password

    An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 – No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

    I tried every bits & Pieces like
    the configuration Manager is Set with TCP/IP on 1433
    read most of the material on Google

    I even came accross a Blob where u had a debate over the same with Microsoft. & den u had done a spl. setup with Machine to prove the Error….
    ur Link
    http://sql-server-performance.com/Community/forums/p/1461/136247.aspx

    I think u’ve already put a lot of Efforts on this topic & mayb i could resolve my Problem with ur Help

    Hope if u can reach this Article & possibly Reply…..
    Thanks a Ton
    & Good Wishes

  2. I am having teh same trouble connecting from sql 2008 to sql 2005 using linked server I wonder if your solutions can help me.

    The stored proc runs but after a little while
    Error message is: Exception of type ‘System.OutOfMemoryException’ was thrown.

    comes up

  3. Just wanted to note that the issue and instructions in the KB article also apply to a SQL Server 2008 64-bit system linking to SQL 2000 SP4 32-bit. The instructions in this KB article fixed my issue. Thanks.

  4. Hello Pinal Sir,

    I am saving image in SQL Server 2008 but when i tried to save image more than 980kb it gives me error System.OutOfMemoryException. I am using c# as code behind.

    Please help me to get rid of this issue.

    Regards,
    Rahul Nikam

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s