SQL Server – Azure key vault Error – Msg 15507, Level 16, State 1, Line 6 A key required by this operation appears to be corrupted.

One of our SQL Server which is part of Always On got restarted from Azure side. Once server back online, the Availability group is not coming online. When we look at the SQL error log, we found that an error saying that “Failed to obtain or decrypt for secret for credential < credential name>”

When I tried to re-create credential in TSQL, I was getting another error,

Msg 15507, Level 16, State 1, Line 6

A key required by this operation appears to be corrupted.

 

Solution:

The reason for this error is due to master key got corrupted, the same can be regenerate by the following command.

ALTER SERVICE MASTER KEY FORCE REGENERATE

Entrepreneurship – A must watch video for CEO’s / Leader’s.

Leadership is nothing but a strong vision, if you have that you can align people, materials, run an organization etc. For vision you need a strong knowledge. Rakesh Gupta (Ex-CEO of ACIS – Allianz Company) is a great Human being than a Leader. His views towards the business are quite different than what the current world is following. It is a great privilege in my life to meet this great corporate leader who has multidimensional thoughts about modern business strategies and also know how to plug in vedic principles in corporate culture. The outcome of his approach is Universal happiness and business growth. I worked under him and I know how he made Allianz (ACIS) – A Great place to work.

Few days back, while I was scrolling my YouTube videos, I came across a wonderful video “The Vedic Leadership – Need of our times by Rakesh Gupta”. It is an awesome video. I suggest this is a must watch video for CEO’s, start-up leaders and for all.

A small story:

Recently I came across a corporate award function and it was  funny. The presenter was saying one of the project managers got the award because he usually calls people at night 1:00 am and asks the status. This is the quality of current leadership in many industries and I strongly believe that we need to change the culture. The leaders who want to grow really from their heart, they can use this video.