Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pdset
Constraint Violating Yak Guru
310 Posts |
 Posted - 2015-01-12 : 01:12:22
|
| We have a login is created with ASYMMETRIC KEY on the source server and this needs to be transferred to Target Server. I have tried to create but is denied.error:Msg 15151, Level 16, State 1, Line 3Cannot find the asymmetric key 'CVDBCLRKey', because it does not exist or you do not have permission.I have found this on MASTER database under the Security of Asymmetric key but cannot script out since there is no such option.Is there any way that I can still enforce for Target Server where it can be created.Many Thanks |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-01-12 : 07:21:39
|
| back up the key on the source server. copy the backup file to the target server. Create the key on the target server using the backup file, then create your login |
 |
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2015-01-12 : 16:12:53
|
| Thanks Gbritton. However, I tried to locate the KEY on the source then how to get it? Please advise. |
|
|
|
pdset
Constraint Violating Yak Guru
310 Posts |
Posted - 2015-01-12 : 16:21:09
|
| Also there is no way that i can backup the asymmetric key but only for symmetric key only.Any thoughts as to how to do this. Thanks. |
|
|
|
|
|
|
Asymmetric Keys with Logins