http://technet.microsoft.com/en-us/library/cc966539.aspx
http://searchsqlserver.techtarget.com/tip/15-SQL-Server-replication-tips-in-15-minutes
http://www.sql-server-performance.com/2005/replication-tuning/
Posted by Simon Cho on 02/23/2012
http://technet.microsoft.com/en-us/library/cc966539.aspx
http://searchsqlserver.techtarget.com/tip/15-SQL-Server-replication-tips-in-15-minutes
http://www.sql-server-performance.com/2005/replication-tuning/
Posted in Common | Leave a Comment »
Posted by Simon Cho on 02/23/2012
Master DB rebuild and change check list
https://simonsql.com/2012/02/23/an-error-occurred-during-decryption/
ALTER SERVICE MASTER KEY FORCE REGENERATE
use master declare @srvname varchar(255), @new_srvname varchar(255) set @srvname = @@servername set @new_srvname = 'new hostname' --your computer hostname exec sp_dropserver @srvname exec sp_addserver @new_srvname, local go
Posted in Common | Leave a Comment »
Posted by Simon Cho on 02/23/2012
I guess, you had a problem on Master database.
After changed you got linked server error like this.
“An error occurred during decryption.”
The reason why login mapping password can decrypt due to master key changed.
So, you need to generate again master key with force option.
http://support.microsoft.com/kb/914261
ALTER SERVICE MASTER KEY FORCE REGENERATE
Posted in Common | 1 Comment »