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

  • fafful

    Right there with Babe

    Points: 745

    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.
  • Phil Parkin

    SSC Guru

    Points: 244662

    You might find this link helpful.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

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

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