000013348 - Unable to configure MSSQL Server audit procedure. Error ?The certificate  asymmetric key  or private key file does not exist or has invalidformat'

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000013348
Applies ToRSA enVision 4.0 and 4.1
Event Source: 2000, 2005, 2008, 2012, and MS SQL Express
 
IssueUnable to configure MSSQL Server audit procedure. Error ?The certificate, asymmetric key, or private key file does not exist or has invalid format?

The below error is received while configuring the SQL server audit procedure and executing the command to add a certificate to the database and Grant Load permissions.


USE MASTER
GO
CREATE CERTIFICATE SQLCLRTestCert FROM EXECUTABLE
FILE = 'C:\MyDBApp\RSA_MSSQLAuditStoredProcedures.dll'
CREATE LOGIN SQLCLRTestLogin FROM CERTIFICATE
SQLCLRTestCert
GRANT EXTERNAL ACCESS ASSEMBLY TO SQLCLRTestLogin
GO

Msg 15208, Level 16, State 1, Line 1
The certificate, asymmetric key, or private key file does not exist or has invalid format.
Msg 15151, Level 16, State 1, Line 3
Cannot find the certificate 'SQLCLRTestCert', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 5
Cannot find the login 'SQLCLRTestLogin', because it does not exist or you do not have permission.




 
CauseThis could be either due to a permission issue or a corrupt .dll file.
Resolution

Please follow the below steps to resolve the issue.


  • Ensure you are logged on as a database administrator to install the audit procedure.
  • Check if file RSA_MSSQLAuditStoredProcedures.dll is located at C:\MyDBApp\
  • Please download the latest copy of the .dll file from SCOL and re-try adding the certificate.
Legacy Article IDa61074

Attachments

    Outcomes