An Error Occurred During Decryption. Microsoft Sql Server Error 15466
Contents |
“An error occurred during decryption” ★★★★★★★★★★★★★★★ Karthick P.K - karthick krishnamurthyJuly 18, 20120 0 0
An Error Occurred During Decryption. Linked Server
0 Problem Description Linked server connection fails an error occurred during service master key decryption linked server with below error { Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) —————————— ADDITIONAL INFORMATION: An
An Error Occurred During Service Master Key Decryption 33094
exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— An error occurred during decryption. (Microsoft SQL Server, Error: 15466) Msg 15593, Level 16, alter service master key force regenerate 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 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 there is no remote user mapped to local user '(null)' from the remote server 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 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 t
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Security » An
An Error Occurred During Service Master Key Decryption (microsoft Sql Server, Error: 33094)
error occurred during decryption (Error:... An error occurred during decryption (Error: 15466, Severity: an error occurred while decrypting master key that was encrypted by the old master key 16, State: 1.) Rate Topic Display Mode Topic Options Author Message Tim-257797Tim-257797 Posted Tuesday, March 3, 2009 1:44 AM Grasshopper
Event Id 5601 Mssql$microsoft##wid
Group: General Forum Members Last Login: Wednesday, May 18, 2016 8:41 PM Points: 12, Visits: 428 Hello Everyone:I hope someone can assist with my question:============================================================================================Environment:----------------Production Environment running: SQL Server 2005 - 9.00.2153.00 (Intel https://blogs.msdn.microsoft.com/karthick_pk/2012/07/18/linked-server-connection-fails-with-an-error-occurred-during-decryption/ X86) Standard Edition Windows NT 5.2 (Build 3790: Service Pack 1)Using a domain service account. The problem that was encountered:-------------------------------------------I have a two node cluster; I will call the nodes - node1 and node2. - SQL Server has been running on node1 since I started DBA support for the SQL Cluster. - Recently an incident occurred which caused SQL to failover onto node2. - When SQL http://www.sqlservercentral.com/Forums/Topic667093-6-1.aspx started up the following errors were displayed in the error log. 2009-02-21 11:06:59.90 spid5s Error: 15466, Severity: 16, State: 1. 2009-02-21 11:06:59.90 spid5s An error occurred during decryption. 2009-02-21 11:07:00.13 Server Error: 17190, Severity: 16, State: 1. 2009-02-21 11:07:00.13 Server FallBack certificate initialization failed with error code: 4. 2009-02-21 11:07:00.13 Server Warning:Encryption is not available, could not find a valid certificate to load. - In addition to this I noticed that the existing full text indexes could not be used. After a lot of investigation I ended up failing it back onto node1 again …… and the errors / warning disappeared and fti works. When SQL server starts up now, I receive the following message in the logs: 2009-02-23 19:06:12.87 Server A self-generated certificate was successfully loaded for encryption. My concern:---------------Is that if it ever fails over again …… the same problem will occur again. Backup of SMK--------------------Now that it is running on node 1 I have backed up the SMK using the command: BACKUP SERVICE MASTER KEY TO FILE = 'H:\smk_20090224.smk' ENCRYPTION BY PASSWORD = 'aspecificpassword' What I would like to do:-----------------------------1. I would like to schedule some down time of the system and
during decryption.PN: Also, when configuring distribution for replication following error occurred.An error occurred during decryption.There is no remote user 'distributor_admin' mapped to local user '(null)' from the remote server 'repl_distributor'.Changed database context to 'master'. (Microsoft http://dbfriend.blogspot.com/2010/01/error-occurred-during-decryption-when.html SQL Server, Error: 15466)This also due to unable to create linked server named repl_distributor.The Service Master Key is the root of the SQL Server encryption hierarchy. It is generated automatically the first time it is needed to encrypt another key. By default, the Service Master Key is encrypted using the Windows data protection API and using the local machine key. The Service Master Key can only be opened by the an error Windows service account under which it was created or by a principal with access to both the service account name and its password.Solution is to regenerate the service master key with following command.ALTER SERVICE MASTER KEY REGENERATEIn case above statement generates an error, you have to use with FORCE command. http://support.microsoft.com/kb/914261ALTER SERVICE MASTER KEY FORCE REGENERATE Labels: FAQ 6 comments: Josh PattersonOctober 19, 2011 at 10:00 AMThe correct syntax is:ALTER SERVICE an error occurred MASTER KEY FORCE REGENERATEReplyDeleteDave OttNovember 7, 2011 at 4:42 PMJust had to do this. And Josh is correct the syntax is off.ALTER SERVICE MASTER KEY FORCE REGENERATEReplyDeleteAnonymousSeptember 30, 2013 at 10:15 AMbrillant piece of information, I had come to know about your web-page from my friend hardkik, chennai,i have read atleast 9 posts of yours by now, and let me tell you, your webpage gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a million once again, Regards, obiee training in hyderebadReplyDeleteAnonymousOctober 8, 2013 at 2:24 PMThanks. this has been so helpful to resolve issues of my ownReplyDeleteAnonymousDecember 4, 2013 at 12:56 AMIs there a risk to run this command ??ALTER SERVICE MASTER KEY FORCE REGENERATEReplyDeleteRepliesRejoy CherianFebruary 18, 2016 at 11:24 AMplease comment on the question asked....we are also facing the same issue......pls comment what will happen when we run this command. will it change any current databases properties/data.....any other issues?? please let usknow.DeleteReplyAdd commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom) Hit Counters Live Traffic Stats Popular Posts Temp Ta