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://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 (https://blog.sqlauthority.com)
5 Comments. Leave new
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
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
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
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.
thank you :D
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