SQLSERVER2005 64 bit linked server problem

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 ?

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




"Áõ°½" wrote:

> 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 ?
>
>
>
>
>
>