Create SQL Server Linked Server specifying particular Certificate?

techresearch7777777 1,881 Reputation points
2024-10-16T18:23:19.2333333+00:00

Hello, sorry if my question here is not clear on the concept...but is there a way via SQL Server script command to create a Linked Server which also specifies which Certificate to use that has been installed?

(Also to note if makes a difference the SQL Server instance here in reference is within SQL Server Clustered setup.)

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,976 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,306 Reputation points Microsoft Vendor
    2024-10-17T03:29:20.01+00:00

    Hi @techresearch7777777

    I agree with Erland, it seem we cannot specify which Certificate to use when create linked server. I also search this online but not luck, I could not find any helpful information.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.