How can we help you today? How can we help you today?

Menu not appearing under "Run as"

I have just installed the release candidate and it all seems to work fine except for the fact that the menu item wount appear when i run SSMS with alternate credentials. This means that I cannot configure the settings etc. Is it the case that SQL Promt is installed only for the current user? I'll try to run the installer with alternate credentials and see what happens...
Lumbago
0

Comments

4 comments

Sort by
  • Lumbago
    It seems that I can't get this menu element to appear if my life depended on it!

    "User1" is my regular account and "User2" is my special account with special privileges in my company network and on the database servers. Both are local admins on my laptop.

    I have uninstalled and installed again with both users and what happens is that if log on with User1 and run SSMS as User1 the menu appears but when I choose "Run as" and runs as User2 it doesn't. The menu doesn't show when I log on with User2 either...I tried modifying the settings running as User1 but they don't seem to work for User2. I have tried rebooting and everything...
    Lumbago
    0
  • Lumbago
    This is really weird. I uninstalled completely and verified that the program was not present when logging on as both User1 and User2. Then I rebooted, logged on as User2, installed, ran SSMS and then the meny appeared. Great...so far. Then I logged off, logged on as User1, ran SSMS as User2 and the meny was not there. So I logged back off, logged on as User2 again, ran SSMS and now the menu was gone! I've spent 1.5 hour on this now and I got tired of it so I located the EngineOptions.xml and UIOptions.xml files in C:\Documents and Settings\User2\Local Settings\Application Data\Red Gate\SQL Prompt 3 and modified the settings using UltraEdit. Tedious but it sees to have done the trick...

    All this rambeling beeing said/done; the new release seems awesome!
    Lumbago
    0
  • Lionel
    Sorry for the late reply. The problem is because the plugin architecture for SSMS is a bit limited it only installs the menus for the user that first uses SSMS after you have run the prompt installation. You should be able to run

    C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe /setup

    This will reset all your menus to their default state which will restore the SQL Prompt menu.

    Lionel
    Lionel
    0
  • marcorusso
    I think you should add this command on readme files - it is necessary also for SQL Refactor and I was not able to work correctly until I found it in the support forum.

    Marco
    marcorusso
    0

Add comment

Please sign in to leave a comment.