How can we help you today? How can we help you today?
Ashlee
Activity overview Badges (0) Posts (1) Comments (5)

Activity overview

Latest activity by Ashlee

miltonacademy - Try this page for older installer versions https://www.red-gate.com/products/old-versions In case that link doesn't work directly, I found that by logging in, then clicking on my initials in the top right corner and navigating to My products. That should open the Redgate Portal for your account. Click on Licenses, then click on a product in the list and that should display a button in the top right corner labeled Download Specific Version which takes you to the URL above. Not sure if this is the case for all products, but I did notice that SQL Prompt has a sparse list of available past versions. Might not be able to find the exact version you're looking for, but that's the only self-service solution I've found so far. / comments
  1. Community
  2. SQL Prompt
  3. Suggestions Stopped Working After Upgrade to Version 10.14.12.7945
miltonacademy - Try this page for older installer versions https://www.red-gate.com/products/old-versionsIn case that link doesn't work directly, I found that by logging in, then clicking on my ini...
0 votes
I was able to resolve this issue by downloading the installer directly from my license management page, uninstalling SQL Prompt, then reinstalling using the downloaded installer. / comments
  1. Community
  2. SQL Prompt
  3. Suggestions Stopped Working After Upgrade to Version 10.14.12.7945
I was able to resolve this issue by downloading the installer directly from my license management page, uninstalling SQL Prompt, then reinstalling using the downloaded installer.
0 votes
Sharing more info, I enabled verbose logging and noted an error when launching SSMS. Here are the last 5 entries in the log after opening SSMS and connecting to my locally-hosted dev database: <div>2024-04-03 12:55:01.249 -05:00 [Verbose] Check for updates: Update results received: End of update results.</div><div>2024-04-03 12:55:01.251 -05:00 [Verbose] Check for updates: State: UpToDate</div><div>2024-04-03 12:55:01.253 -05:00 [Verbose] Check for updates: Exiting check for updates</div><div>2024-04-03 12:55:18.106 -05:00 [Information] Sql History initialized successfully</div><div>2024-04-03 12:55:21.240 -05:00 [Error] Error checking for platform availability</div><div>System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 20.90.200.114:443</div><div>&nbsp; &nbsp;at System.Net.Sockets.Socket.InternalEndConnect(IAsyncResult asyncResult)</div><div>&nbsp; &nbsp;at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult)</div><div>&nbsp; &nbsp;at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)</div><div>&nbsp; &nbsp;--- End of inner exception stack trace ---</div><div>&nbsp; &nbsp;at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)</div><div>&nbsp; &nbsp;at System.Net.Http.HttpClientHandler.GetResponseCallback(IAsyncResult ar)</div><div>&nbsp; &nbsp;--- End of inner exception stack trace ---</div><div>&nbsp; &nbsp;at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)</div><div>&nbsp; &nbsp;at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)</div><div>&nbsp; &nbsp;at Microsoft.Extensions.Http.Logging.LoggingHttpMessageHandler.<SendAsync>d__5.MoveNext()</div><div>--- End of stack trace from previous location where exception was thrown ---</div><div>&nbsp; &nbsp;at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)</div><div>&nbsp; &nbsp;at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)</div><div>&nbsp; &nbsp;at Microsoft.Extensions.Http.Logging.LoggingScopeHttpMessageHandler.<SendAsync>d__5.MoveNext()</div><div>--- End of stack trace from previous location where exception was thrown ---</div><div>&nbsp; &nbsp;at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)</div><div>&nbsp; &nbsp;at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Platform.Client.KillSwitchChecker.<GetEnabled>d__5.MoveNext()</div><div>--- End of stack trace from previous location where exception was thrown ---</div><div>&nbsp; &nbsp;at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)</div><div>&nbsp; &nbsp;at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)</div><div>&nbsp; &nbsp;at RedGate.SqlPrompt.Platform.Client.KillSwitchChecker.<RunOperation>d__4.MoveNext()</div> A log created earlier today includes the warning shown below. Note, I've replaced the actual server name with placeholder <servername>. No changes have been made to my SQL Server database or settings aside from updating SQL Prompt. Also, I've been using and regularly updating SQL Prompt for several years. This is my first time encountering an issue like this. All previous upgrades continued to function as expected. <div>2024-04-03 08:46:23.782 -05:00 [Information] Created new ServerCandidate for server: <servername></div><div>2024-04-03 08:46:53.519 -05:00 [Warning] Failed to load server <servername></div><div>Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: HTTP Provider, error: 0 - )</div> Question, is there a way to fix the ServerCandidate connection manually? Not finding any obviously related settings in the SQL Prompt menu. / comments
  1. Community
  2. SQL Prompt
  3. Suggestions Stopped Working After Upgrade to Version 10.14.12.7945
Sharing more info, I enabled verbose logging and noted an error when launching SSMS. Here are the last 5 entries in the log after opening SSMS and connecting to my locally-hosted dev database:<div>...
0 votes
Suggestions Stopped Working After Upgrade to Version 10.14.12.7945
  1. Community
  2. SQL Prompt
I upgraded SQL Prompt to Version 10.14.12.7945 yesterday and no longer get suggestions or some auto-formatting features in SSMS v18.12.1. I do not use SQL Prompt anywhere else, so I cannot confirm ...
3 followers 6 comments 0 votes
I can confirm installing 10.10.3.25844 resolved the issue for me. Not seeing duplicate tabs in Tab History anymore. I did clear my history to remove any duplicates that were created previously. Did you try clearing after the upgrade? / comments
  1. Community
  2. SQL Prompt
  3. Tab History - Duplicate Entries
I can confirm installing 10.10.3.25844 resolved the issue for me. Not seeing duplicate tabs in Tab History anymore. I did clear my history to remove any duplicates that were created previously. Did...
0 votes
Same problem immediately after updating to version 10.10.2.25539. Not all tabs are duplicated, but most are. Cannot determine a pattern explaining why only some tabs are duplicated. Tried closing all tabs, then removing all tabs from Closed history. Immediately saw duplicates appearing under Open again when creating a new query. For duplicate tabs, I'm finding that one instance opens the tab as expected and the duplicate instance displays an error Document not found. [image] / comments
  1. Community
  2. SQL Prompt
  3. Tab History - Duplicate Entries
Same problem immediately after updating to version 10.10.2.25539.Not all tabs are duplicated, but most are. Cannot determine a pattern explaining why only some tabs are duplicated. Tried closing al...
0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2