I have a dll that will perform some webservice calls function. in order to use in SQLServer 2016 i would like to create a user called sqlex from a certificate. When I try to do this I get the below error:
/****** Object: Login [sqlRext] Script Date: 10/07/2020 12:06:30 ******/
CREATE LOGIN [sqlRext] FROM CERTIFICATE [POKCodeSigning]
Msg 15151, Level 16, State 1, Line 5
Cannot find the certificate 'POKCodeSigning', because it does not exist or you do not have permission.
I tried to create the certificate on the server box through windows but cannot get the certificate to show in SQL server.
I have attached an image of SQL Server Network Configuration screen in my SQL Server, please
Any step by step help?