SQL Prompt 10.1.1 Error and Locks up SSMS

alphonseg · March 18, 2020 3:35PM

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?

cmfox1970 · March 18, 2020 4:05PM

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.

alphonseg · March 18, 2020 4:12PM

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.

cmfox1970 · March 18, 2020 4:16PM

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.

alphonseg · March 18, 2020 4:20PM

Now, that's interesting!

corey · March 18, 2020 4:22PM

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

cmfox1970 · March 18, 2020 4:29PM

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.

corey · March 18, 2020 4:41PM

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.

AdrianB · March 19, 2020 9:45AM

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.

jsreynolds1 · March 19, 2020 3:56PM

Guys, I think this must be a typo?

AdrianB · March 19, 2020 4:00PM

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

jsreynolds1 · March 19, 2020 4:03PM

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

AdrianB · March 19, 2020 4:07PM

Yes, it should be.

SQL Prompt 10.1.1 Error and Locks up SSMS

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk