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
RSA May 2024 Release Announcements 57Number of Views What is the difference between 'IP address matching' and 'Threshold \Consider if X events come in within Y seconds' corre… 18Number of Views Error: The system cannot locate the specified RDN 'DC=x, DC=y' in the external identity source 'example. Verify that the d… 9Number of Views Configuring RSA Authentication Agent 7.1 for PAM on SELinux 424Number of Views Release Notes Archive - Cloud Authentication Service and Authenticators (October 2024 - March 2024) 411Number of Views