Re: An error occurred during decryption



Could be. Can you post the error from the errorlog, including a few lines
before and after it, for context? You can remove sensitive information like
IP addresses or account names - I just need to see the error number, state,
and message.

Thanks

--
Laurentiu Cristofor [MSFT]
Software Development Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/

This posting is provided "AS IS" with no warranties, and confers no rights.

"Dave B" <DaveB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:535415A4-4727-4652-82DC-401A3FD74D00@xxxxxxxxxxxxxxxx
I have a 2 node cluster that I recently installed. During the installation,
node 2 was active. After the installation of SQL 2005 and the SP1, I added
some linked servers that use SQL authentication. When I fail over to node
1,
I get the following error:

An error occurred during decryption.

On all of my linked servers. If I fail back, everything works great. I
have
these same linked servers on several other non-clustered machines and they
work fine. Is this possible a service master key issue?




.



Relevant Pages

  • Re: An error occurred during decryption
    ... The issue that I am seeing on my cluster is any linked servers using sql ... authentication created on NodeA fail when I move over to NodeB. ... Before I regenerate the key, I just want to know how ... SQL Server Engine ...
    (microsoft.public.sqlserver.security)
  • Re: Linked Server Access Problems
    ... > Under SQL Server's Linked Servers, ... >>database on a SQL 2K box. ...
    (microsoft.public.sqlserver.security)
  • Linked Servers Fail
    ... error to a modal messagebox that the client provider ... >configured 6 linked servers using OpenLink Database Proxy ... I have had to cycle the SQL ... >the failure to the interaction between SQL and the DSN ...
    (microsoft.public.sqlserver.server)
  • Delete from Oracle table based on IDs in a SQL table
    ... Unfortunately we cannot use linked servers as the Oracle tables contain ... Two seperate SQL Tasks. ... second task dynamically by looping through the global variable. ...
    (microsoft.public.sqlserver.dts)