April 16, 2015 at 6:05 am
Hi,
I am in process to migrated one of our sqlserver 2000 server to mssql 2008.
Everything went well but when app started , it gave error "master.. xp_rsa_load_key not found". I investigated this sp on my source server and found it is referring to some dll file 🙁
I am not aware about it yet I have tried to search google but not found enough information. I came to know that I need to install "XP_CRYPT" , but I am not sure about process and what else to consider while doing so.
Can you please guide me what I should do on source and target to make it work ?
April 16, 2015 at 6:23 am
Googling on xp_rsa_load_key I get a lot of hits on xpcrypt.com. To register the DLL, you use sp_addextendedproc. However, most likely you cannot take the DLL from the SQL 2000 installation and copy it to the SQL 2008 instance. To wit, I expect that you are installing SQL 2008 64-bit, so the old 32-bit DLL will not work. So I guess that you will need to get a bit 64-version of the DDL from xp_crypt.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
April 16, 2015 at 7:12 am
Thank you Erland Sommarskog.
I got the same link.
I was curious about its impact. Whether I have to generate and embed it to app or just install it and it may work.
April 16, 2015 at 7:20 am
You need to install it on the SQL Server instance. There is no need to embed in the app. Unless, that is, this is an app that you install at customer sites. In this case, you may want to install the XP with the app-installation. But in such case I would expect you to already be aware of it.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
April 24, 2015 at 7:33 am
Thank you
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply