Having issue with Keyword not supported: 'trust server certificate in Visual Studio VB

Chaim Bochner 10

Hi. I'm trying to run VB code in visual studio form project but get an error when code is trying to run. Error is: "System.ArgumentException: 'Keyword not supported: 'trust server certificate'.'". The line in code affected is: "Using connection As New SqlConnection(My.Settings.ConnString)". My data source is "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog="C:\CHAIM\STUDIO SAMPLE PROJECT\SAMPLEDATABASEWALKTHROUGH\SALES.MDF";Integrated Security=True;Connect Timeout=30;Encrypt=False;Trust Server Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False" No luck trying ANYTHING suggested. I have windows 10 64bit on old laptop. Please assist. Thanks

Jiachen Li-MSFT 32,376 Reputation points Microsoft Vendor

2023-04-13T08:00:13.7333333+00:00

May I know if you have got any chance to check my answer? I am glad to help if you have any other questions.
Chris L 10 Reputation points

2023-04-23T14:00:27.7433333+00:00

I'd like to add that Jiachen's advice worked for me but I also had to remove the space between "Application Intent" and make sure to rebuild the application before trying to Run it or it will use the initial spaced string.

1 answer

Jiachen Li-MSFT 32,376 Reputation points Microsoft Vendor

2023-04-04T01:25:20.19+00:00

Hi @Chaim Bochner ,

Try removing the space in Trust Server Certificate and Multi Subnet Failover.

Best Regards.

Jiachen Li

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

9 people found this answer helpful.
Talvane Ramos 0 Reputation points

2023-05-16T12:54:55.1933333+00:00

Obrigado @Jiachen Li-MSFT ! Além de remover os espaços do Trust Server certficate e Multi Subnet Failover, tive que remover também do Application Intent para resolver meu problema em C#

james kenlon 0 Reputation points

2023-05-28T17:29:41.2433333+00:00

Used Chris L's comment to get it working:

I'd like to add that Jiachen's advice worked for me but I also had to remove the space between "Application Intent" and make sure to rebuild the application before trying to Run it or it will use the initial spaced string.

Matthew Patterson 0 Reputation points

2023-05-30T07:03:47.6233333+00:00

I also had to remove the space in Application Intent for mine to work. Thanks a lot for this - very helpful

RNJP 0 Reputation points

2023-08-29T15:11:24.5133333+00:00

Jiachen, Thank you for your attention to detail. Your suggestion helped in my situation as well!

Vishwamurthy-MSFT 105 Reputation points Microsoft Vendor

2023-11-23T11:47:24.46+00:00

This worked for me. Thank you!

anil kumar 0 Reputation points

2024-01-05T09:34:28.8166667+00:00

The same issue appears, but there is no hard coded connection string, it is with vs2022, ssis integration package, while setup db servers local, that connect successfully on test connection, but when tried to run the package, an similar to "Error An error has occurred while connecting Keyword not supported: 'trust server certificate'" displayed.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Having issue with Keyword not supported: 'trust server certificate in Visual Studio VB

1 answer

Your answer