SQLPrompt Doesnot work in Visual Studio 2022

jmontero19

Hello Redgate Folks,

Starting on version 10.14.2.447 the SQLPrompt Suggestion stopped working to suggest schema objects, and the error looks like it is related to updates on the SSDT to include the set_Encrypt option in the latest version of the SSDT for Visual Studio 2022.

I tried to revert the version to the prior one, but the issue is the same in the SQLPrompt 10.14.1.4347.

Below is part of the SQLPrompt Log.
Thank you for being so helpful.

023-11-27 16:01:46.983 -06:00 [Verbose] Usage reporting request made to https://productusage.red-gate.com/v1/usageevents

  Number of submitted usage events = 2

  HTTP status code = 200 OK

  Response body =

2023-11-27 16:02:04.896 -06:00 [Information] Created new ServerCandidate for server: PROD

2023-11-27 16:02:05.188 -06:00 [Warning] Failed to do background loading of database candidate PROD.

2023-11-27 16:02:05.286 -06:00 [Debug] AutoRefreshing database master

2023-11-27 16:02:20.511 -06:00 [Error] Report error dialog UI shown

System.MissingMethodException: Method not found: 'Void Microsoft.Data.SqlClient.SqlConnectionStringBuilder.set_Encrypt(Boolean)'.

   at RedGate.SqlPrompt.Shell.Api.ConnectionProperties.ToMsDataConnectionString(Int32 connectionTimeout)

   at RedGate.SqlPrompt.Shell.Api.ConnectionFactory.CreateMsDataConnection(ConnectionProperties connectionProperties)

   at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadServer()

2023-11-27 16:02:57.444 -06:00 [Debug] AutoRefreshing database master

chrisqtran

Hi all, 

For the error below, there should be an update later this week that should resolve the issue:


I will keep y'all updated as soon as it is released.

paulcrafts

I'm getting the same issue as above

WendyK

I cannot load in Visual Studio, {servername} Failed to Load since I updated to version:  10.14.3.4664

I also got this error in SSMS - SqlSourceControlPackage packe did not load correctly.

chrisqtran

@WendyK

For the SQL Source Control issue, are you using our latest version? We are currently on 7.6.31.

jmontero19

@chrisqtran
Thank you so much. I'll be waiting for the release. 
Have a wonderful day

jmontero19

Thank You, @chrisqtran.
The problem has been solved in the latest version released today, Ver. [10.14.4.4865]. 
Have a great weekend. 

chrisqtran

Hi everyone,

I appreciate your patience on this.

SQL Prompt 10.14.4 should fix this issue. I've listed the installer for you below:

SQL Prompt 10.14.4