Comments
20 comments
-
I have had the same issue; I have run the options AI said to try which included deleting the settings file and recreating them but still does not work
The following power shell script confirms my settings are ok
# Check if SSMS 22 settings are initialized $ssmsSettingsPath = "$env:APPDATA\Microsoft\SQL Server Management Studio\22.0" Write-Host "Checking SSMS 22 settings at: $ssmsSettingsPath" if (Test-Path $ssmsSettingsPath) { $files = Get-ChildItem -Path $ssmsSettingsPath -File if ($files.Count -gt 0) { Write-Host "✅ SSMS 22 settings folder exists and contains files. Import Settings likely completed." } else { Write-Host "⚠️ SSMS 22 settings folder exists but is empty. Import Settings may not be completed." } } else { Write-Host "❌ SSMS 22 settings folder does not exist. Import Settings has not been run." } -
I would appreciate some guidance on the migration from SSMS 21 to SSMS 22 in this area as well… the last conversion was a bit of a mess.
If I have both SSMS 21 and 22 installed, do they continue to share settings in some way, or is it a one-time import and done, etc.
-
The same here. I've tried everything with no success.
-
FYI I installed SSMS 22, then installed the very latest version of SQL Prompt which supports SSMS 22. I then opened SSMS 21 and poked about. Closed it.
Then opened SSMS 22, and other than switching the menu settings so the menus appear (it's in RedGate's latest docs), everything was there and came over this time. Same goes for SQL history, etc. So this round - things seemed to work OK! -
Same problem here, cannot install Prompt 11.2
-
same issue here!
-
same here… I was using ssm22 since a week so the import step is done!
I upgraded Sql prompt but doesn't appear in sssm22 (and none of other tools like sql search, sql history, sql test, sql integration pack, etc.)
So I try to uninstall and reinstall (before to read this post!!) and I'm stuck… now I havent't sql prompt either in ssms 20 & 21 (and I can't live without ssf !!!!)
PLEASE REDGATE SUPPORT!! help us how to resolve ASAP this issue
-
OK, I found the issue and the resolution…
My user is non-localadmin (as nobody should be in 2025!) and smss22 was installed under this user (let's say “sandror”); so the usersettings who search the installer is here
%APPDATA%\Microsoft\SQL Server Management Studio\22.0\
that is
"C:\Users\sandror\AppData\Roaming\Microsoft\SQL Server Management Studio\22.0\UserSettings.xml"
But the installer must be “run as admin” so it seeks in the %APPDATA% folder of the user we use on UAC to elevate the privileges; it doesn't found and so the error.
Resolution; copy the folder 22.0 in the folder of that localadmin user
eg in my case from
"C:\Users\sandror\AppData\Roaming\Microsoft\SQL Server Management Studio\"
to
"C:\Users\admin\AppData\Roaming\Microsoft\SQL Server Management Studio\"
relaunch the installer and now you can install sqlprompt and the menu appears (after uncheck in extension)
BTW Sql Search and Sql History buttons are appearing too, but Sql Test & Sql Source Contol not, but this is another story :-( -
Thanks Sandro - that resolved it for me - having to uncheck SQL Prompt from the menu seemed counter intuitive - but was needed :)
-
Thank you Sandro - that resolved it for me too.
Redgate - please note as Sandro points out, not all of us are running SSMS as a local admin user, the same user who installed. Some of us are required by our company to normally run with non-privileged user, then install things requiring admin with a different privileged user.
-
Thank you Sandro - that resolved it for me too! Same with our company we are required to use EPM to run installer.
-
FWIW, after my first attempt resulted in losing the list under Extensions, I reset the extensions to defaults by following this video, How to Reset SSMS Layout & Restore Default Settings (SQL Server Management Studio), then I was able to see and uncheck SQL Prompt, which worked out ok this time. Thought it might help someone else.
-
-
Sandro's solution worked for me.
Oddly, Red Gate support doesn't know about this. They just suggest reinstalling everything, including SSMS.
Red Gate need to fix this. Or maybe add a note to the error message.
-
I have the same problem and like Sandro I don't have local admin rights.
However there is no Admin user in my c:\users to copy the files into.
Our organisation doesn't let us do `right click/run as admin`, we have to ‘right click/run with elevated access’ which launches an ‘endpoint privilege management’ that asks for a ‘business justification’ and asks us to log in again to confirm identity.
So I installed SSMS that way, then ran it as me, so the 22 folder exists in my profile. But I don't know where Redgate is looking for it as the Admin user isn't there (not hidden either). -
OK, just after my last message I had inspiration based on Sandro's approach.
I ran SSMS with the ‘run with elevated access’ option and choose the Import/Export settings option from the menus, and just imported from the previous config it offered me.
Then I ran Redgate again with the elevated access and SQL Prompt is available to install. -
Thanks for all of this, Had the same problem, we use AutoElevate, so I reran the install with User mode elevation (so it runs as me with the admin priviledges flag) and that fixed the issue too.
Problem was I was using chocolatey to install initially so didn't even see the message as it was a silent install. -
@RosieC Genius! We use Azure AD accounts to logon to Windows and a local admin account to install things. I ran SSMS 22 as the admin user, imported settings, and then was able to install SQL Prompt for SSMS 22. Thanks for the tip.
-
Thanks Sandro , that solved it for me too!
-
THANK YOU Sandro !
Add comment
Please sign in to leave a comment.
I installed SSMS 22 and completed the import settings process. However, when I attempted to install SQL Prompt 11.2, I encountered an error. Could you advise on possible solutions?