SQL Prompt 10.1.1 Error and Locks up SSMS

• 

  alphonseg said:

  I just updated to SQL Prompt 10.1.1. Now when I open SSMS (17 or 18), I get the error
  Failed to load 'C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xml'.
  The file exists and looks fine. All worked well before the update.
  SSMS then locks up and I can't do anything at all.
  How can I revert back to 10.1.0?

  I'm experiencing the exact same issue. I also receive an error trying to send the error notification to Red Gate.

  cmfox1970 March 18, 2020 16:05

  - 0 +
• 
  I had just done a Windows 10 update this morning also, so I was able to use the restore point to restore my machine back, which included SQL Prompt 10.1.0, so I'm able to get back to work.
  

  alphonseg March 18, 2020 16:12

  - 0 +
• 

  alphonseg said:

  I had just done a Windows 10 update this morning also, so I was able to use the restore point to restore my machine back, which included SQL Prompt 10.1.0, so I'm able to get back to work.
  

  I uninstalled SQL Prompt and when I downloaded the latest version from Red Gate it installed 10.1.0.

  cmfox1970 March 18, 2020 16:16

  - 0 +
• 
  Now, that's interesting!
  

  alphonseg March 18, 2020 16:20

  - 0 +
• 
  My SSMS is blowing up due to C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xml
  
  Tried uninstalling and clearing the appdata and then reinstalling.  No luck.  Wish I had saved the previous version setup file now

  corey March 18, 2020 16:22

  - 0 +
• 

  corey said:

  My SSMS is blowing up due to C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xml
  
  Tried uninstalling and clearing the appdata and then reinstalling.  No luck.  Wish I had saved the previous version setup file now

  Try this - https://download.red-gate.com/SQLDeveloperBundle.exe
  
  Also, restore the app data if you can so all your settings are still there.

  cmfox1970 March 18, 2020 16:29

  - 0 +
• 

  cmfox1970 said:

  corey said:

  My SSMS is blowing up due to C:\Users\<userprofile>\AppData\Local\Red Gate\SQL Prompt 10\ConnectionColoringServers.xml
  
  Tried uninstalling and clearing the appdata and then reinstalling.  No luck.  Wish I had saved the previous version setup file now

  Try this - https://download.red-gate.com/SQLDeveloperBundle.exe
  
  Also, restore the app data if you can so all your settings are still there.

  Installed this and restored my previous settings and everything is good to go.
  
  Thank you.

  corey March 18, 2020 16:41

  - 0 +
• 
  Thanks for getting in touch. We are aware of an issue with SQL Prompt v10.1.1 and are currently looking into it. We will post an update when we have a fix.

  AdrianB March 19, 2020 09:45

  - 0 +
• 
  Guys, I think this must be a typo?
  
  

  jsreynolds1 March 19, 2020 15:56

  - 0 +
• 
  Yes, that is a typo. Well spotted, and thanks for letting us know. I've just fixed it.

  AdrianB March 19, 2020 16:00

  - 0 +
• 
  Good morning all, should we consider SQL Prompt v10.1.2 a fix for the issue listed above?

  jsreynolds1 March 19, 2020 16:03

  - 0 +
• 
  Yes, it should be.

  AdrianB March 19, 2020 16:07

  - 0 +

Add comment

Please sign in to leave a comment.