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 |
sdruelinger
Starting Member
4 Posts |
Posted - 2010-11-24 : 11:23:29
|
HelloWhile trying to copy a database from one db server to another I encouter this error:Message: ERROR : errorCode=-1073548784 description=Executing the query "CREATE USER [U_MSP_DAL_Cert] FOR CERTIFICATE [MSP_..." failed with the following error: "Cannot find the certificate 'MSP_DAL_Cert', because it does not exist or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.I do see a U_MSP_DAL_Cert user in the security container for the source database and the user name: is listed as a Certificate Name. I have never worked with Certificate names before so I am a little lost on how to replicate this over to the new server.Thanks in advance |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
sdruelinger
Starting Member
4 Posts |
Posted - 2010-11-24 : 13:43:30
|
ok .thanks for the advice.. I will try that.ThanksSean |
|
|
|
|
|