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
DBSM: Error when configuring Oracle adapter: ORA-28575: unable to open RPC connection to external procedure agent 3Number of Views Forgot the password used to compress and encrypt a file with RSA SureFile 18Number of Views SilverFort - RSA MFA API (REST) Configuration - RSA Ready Implementation Guide 25Number of Views CrowdStrike Falcon Identity Protection - Authentication Manager - RSA MFA API (REST) Configuration - RSA Ready Implementat… 26Number of Views RSA May 2024 Release Announcements 57Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators