RE: SQLSERVER2005 64 bit linked server problem

#1

Are the servers you are connecting to runing 32bit SQL?
If so, that's the problem.
http://support.microsoft.com/default...en-us%3b906954

"Áõ°½" wrote:

Quote:

Hello,I have a two node cluster with 64 bit sql server 2005 .
I am having a hard time finding any information on an error I am receiving
from attempting to connect 2 SQL Server 2005 servers linked server. I
am setting the linked server to use the credentials of a SQL Server login.
In searching the web, someone suggested enabling OLE automation... I
enabled it but the linked server still did not work.

Any help would be greatly appreciated.

Error message below:
--***************************************

TITLE: Microsoft SQL Server Management Studio
------------------------------

Alter failed for LinkedServerLogin ''. (SqlManagerUI)

For help, click:
http://go.microsoft.com/fwlink?ProdN...n&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

An error occurred during decryption.
There is no remote user 'LinkedSvr' mapped to local user '(null)' from the
remote server '10.1.2.167'. (Microsoft SQL Server, Error: 15466)

For help, click:
http://go.microsoft.com/fwlink?ProdN...6&LinkId=20476

Subsequently, I change the instance to the other node then try again,
How wondered the linked server did work! My God , why is ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: SQLSERVER2005 64 bit linked server problem

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

RE: SQLSERVER2005 64 bit linked server problem - 11-20-2007 , 04:41 AM