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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Asymmetric Keys with Logins

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 3
Cannot 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
Go to Top of Page

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.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -