Code signing a dll with certificate for use in SQL Server 2016

  • 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:

    USE [master]

    GO

    /****** Object: Login [sqlRext] Script Date: 10/07/2020 12:06:30 ******/

    CREATE LOGIN [sqlRext] FROM CERTIFICATE [POKCodeSigning]

    GO

    results:

    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?

    regards

    Attachments:
    You must be logged in to view attached files.
  • You might find this link helpful.


Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply