Re: An error occurred during decryption

It does look like an error with the service master key decryption. Have you
copied your master database from another instance or performed any changes
to your installation before starting to see this?

I wrote a post on this exact topic on my blog. See
http://blogs.msdn.com/lcris/archive/2006/04/10/572678.aspx.

Also, I am not clear of what you mean by linked servers and how do they
relate to your clustered installation and encryption. Can you elaborate on
your setup?

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:123435F7-6631-4C05-B5CD-CA50884DCB64@xxxxxxxxxxxxxxxx
I read your blog on the Service Master Key (SMK). One other question I have
is what is encrypted by the SMK? If I regenerate the key and/or force the
regeneration of the key, what data am I at risk of losing? I would assume
SQL
login passwords and other database master keys. Anything else? I am just
wondering what I may need to recreate if I need to regenerate the key.

"Laurentiu Cristofor [MSFT]" wrote:

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?







.