由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - SQL SERVER moving certificate and symmetric keys between servers
相关主题
journal for sql server请问有什么好的SQL Server Clustering 的书或training 推荐的吗?
Re: How to migrate a database from one sql server to another?Pluggable Databases vs Database Virtualization
大俠 问个关于asp连SQL server的问题发包子,每周一题
Oracle到sql server的migration问题兼3个openingshow to register SQL Server in intranet
linked serverAny SSIS high hand here?
Re: A question for SQL Server什么也不懂,要考个SQL Server 的证
SQL Server restore(transferred from other DB) error... HELP!请问Enterprise level experience
HELP: How to restore SQL server 7 backup file to SQL server 2000?shutdown 200+ SQL SERVERS in 45 minutes
相关话题的讨论汇总
话题: server话题: symmetric话题: sql话题: keys
进入Database版参与讨论
1 (共1页)
w****n
发帖数: 266
1
We migrated our databases to a new server. I backup previous databases,
restore on the new server with full recovery mode. While clients tried to
login some web applications, they got error message as follows.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Cannot find the symmetric key 'Generickey', because it does not exist or you
do not have permission.
I check the database and certificate as well as symmetric keys are there in
new machine. Do I need backup and restore those certificate and keys? Or I
need recreate them?
s**********o
发帖数: 14359
2
你的数据Encrypted了吗?原则上加密数据RESTORE到另一个SERVER也是不能用的,
如果能直接用,那就失去了加密的意义,这里有篇文章关于如何MIGRARTE加密的
DATABASE
http://www.csharpcity.com/2011/moving-a-sql-server-database-wit
w****n
发帖数: 266
3
客户的帐号和密码加密了, 现在不能登录。
1 (共1页)
进入Database版参与讨论
相关主题
shutdown 200+ SQL SERVERS in 45 minuteslinked server
decrypt data,求大神提示Re: A question for SQL Server
如何migrate Oracle DBSQL Server restore(transferred from other DB) error... HELP!
有谁知道Oracle还会support Oracle Application Server多久?HELP: How to restore SQL server 7 backup file to SQL server 2000?
journal for sql server请问有什么好的SQL Server Clustering 的书或training 推荐的吗?
Re: How to migrate a database from one sql server to another?Pluggable Databases vs Database Virtualization
大俠 问个关于asp连SQL server的问题发包子,每周一题
Oracle到sql server的migration问题兼3个openingshow to register SQL Server in intranet
相关话题的讨论汇总
话题: server话题: symmetric话题: sql话题: keys