SQL Prompt doesn't work when running SSMS as different user

ed_waystar

This used to work for years, but now when swapping to another SSMS instance with another user SQL Prompt ceases to work and tells me I have an unlicensed trial on the second instance.

When I click "Manage License" and then "Log In" it tells me to use my browser, and nothing happens.

version 10.14.21.9884
SSMS v18.12.1

Kurt_M

Hi @ed_waystar,

I don't see a reason it should have stopped working. My assumption here is that the license has failed to apply when opening SSMS as that other user.

Can you try checking the following localhost link to see what license is being applied? You might be able to manually activate it within this link against the user you're trying to use.

http://localhost:22221/redgate/status.html

bryan_1

I'm experiencing the same issue.  Due to security, to access SSMS properly, I have to shift-right click SSMS and "Run as a different user."  When I do so, the SQL Prompt menu is bare - same as reported by ed_waystar above.  If I log in with my normal user, I get all the SQL Prompt menu choices.  Any idea how to resolve this?