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

Error running Management Studio under different credentials

To access production databases we are required to use different credentials to that which we normally logon with.
If you change the properties on the shortcut that starts Mgmt Studio and check "Run with different credentials" you get the following error:

"The Add-in 'SQL Prompt 3.0' failed to load or caused an exception.
Would you like to remove this Add-in?
If you choose yes, you will need to reinstall the Add-in to use it again.

Error Message: Class not registered

Error number: 80040154"
pault
0

Comments

6 comments

Sort by
  • Tilman
    Hi,

    Most likely this is, because we only install SQL Prompt for the current user. Could you try installing it for whoever you are running SSMS as and tell me if that works?

    Thanks,

    Tilman
    Tilman
    0
  • pault
    Hi Tilman,

    I tried out your suggestion, but it didn't fix it.

    I logged on as the other user and installed SQL Prompt.
    Tried launching SSMS and got the same error.

    Then logged on as normal user and still getting the error there too.

    Sorry....
    pault
    0
  • Lumbago
    I got the exact same problem...any resolution? When I run SSMS under the logged on user account it works like it should, however for me to be able to use the program I need it to work under alternate credentials also.

    Hope this will be added to the "to-do" list before release :)
    Lumbago
    0
  • Tilman
    Hi again,
    I tried out your suggestion, but it didn't fix it.

    I logged on as the other user and installed SQL Prompt.
    Tried launching SSMS and got the same error.

    Then logged on as normal user and still getting the error there too.

    Could you give me some info about your system? Mainly what version of SSMS are you running? Did you install SQL Server 2005 SP1 + hotfixes? Are you running on Vista, by any chance?
    Hope this will be added to the "to-do" list before release

    Yes, we will probably give users the option to install for all users.

    Regards,

    Tilman
    Tilman
    0
  • Lumbago
    Don't know about the vista-dude but it works like a charm now after a bit of tweaking. What I did is this (User1 is regular user, User2 is alternate user):

    At first:
    - Logged on User1
    - Installed SQL Prompt
    - Started SSMS as User2
    - Got error #80040154

    Then:
    - Logged off computer with User1
    - Logged in with User2
    - Installed SQL Prompt again
    - Verified that it worked in SSMS
    - Logged out as User2
    - Logged back in as User1
    - Started SSMS as User2
    - Everything works like a charm

    :)
    Lumbago
    0
  • pault
    Tilman wrote:
    Could you give me some info about your system? Mainly what version of SSMS are you running? Did you install SQL Server 2005 SP1 + hotfixes? Are you running on Vista, by any chance?

    Windows XP Pro, not Vista

    SSMS info:
    Microsoft SQL Server Management Studio 9.00.1399.00
    Microsoft Analysis Services Client Tools 2005.090.1399.00
    Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
    Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
    Microsoft Internet Explorer 6.0.2900.2180
    Microsoft .NET Framework 2.0.50727.91
    Operating System 5.1.2600

    @version:
    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
    pault
    0

Add comment

Please sign in to leave a comment.