Event Source: 2000, 2005, 2008, 2012, and MS SQL Express
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.
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.
Related Articles
How to generate a report of registered users in RSA Authentication Manager 8.x database 116Number of Views How to export Web Tier Virtual Host Key Pair to a PFX file for RSA Authentication Manager 8.x 1.04KNumber of Views How to generate a Certificate Signing Request (CSR) with the Subject Alternative Name (SAN) field using openssl on RSA Aut… 523Number of Views Authentication Manager Prime: SSP Keystore Import Fails with "Failed to Establish Chain from Reply" 1.39KNumber of Views How to create and configure certificates for HTTPS access when using intermediate CA certs in RSA Identity Governance & Li… 1.09KNumber of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA Authentication Manager Upgrade Process Unexpected error during command com.rsa.ucm.request.CompleteWorkflowRequestActionsCommand execution when approving token r… After an installation or upgrade of RSA Identity Governance and Lifecycle the links to the log files in the Initialization… RSA Authentication Manager Patch Updates