An Error Occurred During Decryption 15466
Contents |
“An error occurred during decryption” ★★★★★★★★★★★★★★★ Karthick P.K - karthick krishnamurthyJuly 18, 20120 0 0 0 Problem Description Linked server connection fails with below an error occurred during decryption. linked server error { Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) —————————— ADDITIONAL INFORMATION: an error occurred during service master key decryption linked server An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— An error occurred during decryption. (Microsoft SQL an error occurred during service master key decryption 33094 Server, Error: 15466) Msg 15593, Level 16, State 1, Line 1 An error occurred while decrypting the password for linked login ‘distributor_admin’ that was encrypted by the old master key. The
Alter Service Master Key Force Regenerate
error was ignored because the FORCE option was specified. } Cause SQL Server service account was changed from services control manager (or) service master key was not backed up and restored when migrating SQL Server to another computer domain. { http://msdn.microsoft.com/en-us/library/ms187788.aspx To change the SQL Server service account, use SQL Server Configuration Manager. To manage a change of the service account, SQL Server an error occurred during service master key decryption (microsoft sql server, error: 33094) stores a redundant copy of the service master key protected by the machine account that has the necessary permissions granted to the SQL Server service group. If the computer is rebuilt, the same domain user that was previously used by the service account can recover the service master key. This does not work with local accounts or the Local System, Local Service, or Network Service accounts. When you are moving SQL Server to another computer, migrate the service master key by using backup and restore. The REGENERATE phrase regenerates the service master key. When the service master key is regenerated, SQL Server decrypts all the keys that have been encrypted with it, and then encrypts them with the new service master key. This is a resource-intensive operation. You should schedule this operation during a period of low demand, unless the key has been compromised. If any one of the decryptions fail, the whole statement fails. The FORCE option causes the key regeneration process to continue even if the process cannot retrieve the current master key, or cannot decrypt all the private keys that are encrypted with it. Use
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies an error occurred while decrypting master key that was encrypted by the old master key of this site About Us Learn more about Stack Overflow the company
There Is No Remote User Mapped To Local User '(null)' From The Remote Server
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges
Msg 33094
Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a https://blogs.msdn.microsoft.com/karthick_pk/2012/07/18/linked-server-connection-fails-with-an-error-occurred-during-decryption/ minute: Sign up SQL Server 2005 - Restoring an encrypted DB on a different server up vote 3 down vote favorite I have backed up an encrypted DB (symmetric key/certificate) and restored it on a different server. Unfortuantely we're having problems with the decryption... hoping someone can help. In the restored db, I can see the Symmetric Key and the Certificate in http://stackoverflow.com/questions/209927/sql-server-2005-restoring-an-encrypted-db-on-a-different-server SSMS, but when I try to Open the key using the cert ( open symmetric key KeyA decryption by certificate CertB )I get the following very descriptive error: Msg 15466, Level 16, State 1, Line 1 An error occurred during decryption. Any ideas? Thanks in advance. sql-server sql-server-2005 encryption symmetric-key share|improve this question edited Oct 16 '08 at 19:57 Mark Brady asked Oct 16 '08 at 19:30 user24531 17115 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote http://blogs.msdn.com/lcris/archive/2007/11/16/sql-server-2005-restoring-the-backup-of-a-database-that-uses-encryption.aspx answers this: "When you restore a database that uses encryption features, there is only one thing you need to take care off - if the database master key (DbMK) needs a service master key (SMK) encryption, you need to regenerate this encryption. Note that this encryption is made by default when you create the DbMK, but it may be intentionally dropped, if you want tighter control of access to the encrypted data. Anyway, if you did have such SMK encryption for the DbMK, the steps to regenerate it are the following: OPEN MASTER KEY DECRYPTION BY PASSWORD = 'password'
SERVICES Services Overview Education Services Business Critical Services Consulting Services Managed Services Appliance Services CUSTOMER CENTER Customer Center Support Community MyVeritas Customer Success Licensing Programs http://support.veritas.com/docs/290690 Licensing Process ABOUT About Corporate Profile Corporate Leadership Newsroom Research Exchange Investor Relations Careers Legal Contact Us English 中文(简体) English Français Deutsch Italiano 日本語 한국어 Português Español USA Site: Veritas Veritas PartnerNet The error "MSSQL$BKUPEXEC: ID 15466: An error occurred during decryption" is logged in the Application Event log after a an error manual disaster recovery Article:000089047 Publish: Article URL:http://www.veritas.com/docs/000089047 Support / Article Sign In Remember me Forgot Password? Don't have a Veritas Account? Create a Veritas Account now! Welcome First Last Your Profile Logout Sign in to Subscribe Please sign in to set up your subscription. Close Sign In Print Article Products Article an error occurred Languages Subscribe to this Article Manage your Subscriptions Problem The error "MSSQL$BKUPEXEC: ID 15466: An error occurred during decryption" is logged in the Application Event log after a manual disaster recovery. Error Message Log Name: ApplicationSource: MSSQL$BKUPEXECEvent ID: 15466Task Category: ServerLevel: ErrorKeywords: ClassicDescription: An error occurred during decryption. Cause By design, Backup Exec is installed temporarily to restore the data on the temporary Operating System (OS) during the disaster recovery. The SQL Instance "BKUPEXEC" is installed and generates a Service Master Key to provide the function of the encryption for the databases. The Temporary OS is overwritten by the restore operation and the OS is recovered as before. However, the SQL Instance "BKUPEXEC" is not overwritten because Backup Exec is in use during the restore operation. Therefore the Service Master Key of the temporary OS is retained on the recovered OS and the error "An error occurred during decryption" occurs due to the incons