We are getting below error while creating credential in SQL 2012.
Error MSG 15297 – “The certificate, asymmetric key, or private key data is invalid”.
We have a SAN server setup which has one cluster and 3 nodes associated to the cluster.
Below query is executed using service account which is administrator on the SQL server.
Any pointers to fix this issue?
CREATE CREDENTIAL [Mercury_SQL] WITH IDENTITY = N'REDMOND\osdfnsql', SECRET = N'PWD'