How can we help you today? How can we help you today?

SQLPrompt Doesnot work in Visual Studio 2022

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


jmontero19
0

Comments

7 comments

Sort by
  • paulcrafts
    I'm getting the same issue as above
    paulcrafts
    0
  • 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.
    WendyK
    0
  • 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.

    chrisqtran
    0
  • chrisqtran
    @WendyK

    For the SQL Source Control issue, are you using our latest version? We are currently on 7.6.31.
    chrisqtran
    0
  • jmontero19
    @chrisqtran
    Thank you so much. I'll be waiting for the release. 
    Have a wonderful day
    jmontero19
    0
  • jmontero19
    Thank You, @chrisqtran.
    The problem has been solved in the latest version released today, Ver. [10.14.4.4865]. 
    Have a great weekend.
    jmontero19
    0
  • 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

    chrisqtran
    0

Add comment

Please sign in to leave a comment.