1
Vote

SQL 2008 fails to create asymetric key

description

On SQL 2005 (9.0.5057) I am able to install this without incident. Following the same installation process on a SQL 2008 (10.50.2500) instance I receive the following error.

Msg 15208, Level 16, State 1, Line 4
The certificate, asymmetric key, or private key file does not exist or has invalid format.

This is being generated by this code:

USE master
GO

-- First Create the Asymmetric Key from the Assembly
-- !!CHANGE!! the location of the folder where the DLL is located for your environment.
CREATE ASYMMETRIC KEY FileSystemHelperKey
FROM EXECUTABLE FILE = 'C:\temp\FileSystemHelper.dll'
GO

As a result, all the subsequent steps fail also and the procedures do not get created.

comments