SQL Prompt installation issues with the SSMS 22 Import Settings flow

SSMS 22 introduced an Import Settings step that runs the first time you open it. If this hasn't been completed, or is completed under the wrong account, it can cause problems for SQL Prompt. This covers the two ways that shows up.

SSMS 22 freezes when importing settings while SQL Prompt is already installed

This happens when both of the following are true:

• SSMS 22 is installed but you haven't completed the Import User Settings step yet.
• SQL Prompt is already installed on the machine.

If you then open SSMS 22 and start Import User Settings, SSMS freezes on the import screen and doesn't proceed.

How to fix it

1. Uninstall SQL Prompt.
2. Open SSMS 22 and complete Import User Settings.
3. Close SSMS 22.
4. Reinstall SQL Prompt.

The SQL Prompt installer now checks for this ahead of time. If it detects SSMS 22 without a completed Import User Settings step, it stops and shows a warning so you can complete the import first:

Installer says the Import Settings flow needs to be completed

You may see this error when installing SQL Prompt after upgrading to SSMS 22:

This usually happens when you're running the installer under a different account (for example an admin account) than the one you normally use. The installer checks for imported settings under the account running the installation, so if you completed Import Settings under your normal account, it won't detect that under the other one.

How to fix it

• Run SSMS under the admin account and complete Import Settings when prompted, then re-run the SQL Prompt installation, or:
• Copy the SSMS 22 settings folder from your normal account to the admin account, then re-run the SQL Prompt installation. The folder is at C:\Users\<your normal account>\AppData\Roaming\Microsoft\SQL Server Management Studio\22.0.