8

On Windows 10 and SSMS 2016, I can no longer start SSMS as another user. I need to be able to do this in order to use trusted authentication to connect to some of my databases. This used to work fine, but using Windows 7 and an older version of SSMS.

If I right-click on the icon and choose 'run as a different user', I now get this

enter image description here

Is there a workaround for this?

Thanks

Richard
  • 241
  • 1
  • 2
  • 9

3 Answers3

9

In case it helps anyone, I got it working by:

  • Open the location to the shortcut, such as: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server Tools 17
  • Right-click > Properties > Compatibility >
  • Select "Run this program as an administrator"
  • Select the button "Change settings for all users" (THIS IS IMPORTANT)
  • Again, select "Run this program as an administrator"
  • Select "Okay", and 'Okay" again.

Hope it helps everyone.

raredesign
  • 91
3

Seems to be a known (unresolved) bug:

Archived - SSMS 2016 fails on Windows 10 Version 1607 while trying to execute it as a different domain user

SSMS 2014 still works fine so that's a workaround, or as @yahmoth555 suggested, use a different build of Windows.

KyleMit
  • 498
Richard
  • 241
  • 1
  • 2
  • 9
0

In windows 10 with ssms2018 installed it is little bit tricky.

you need to reach out the application setup file(.exe) (not shortcut) of SSMS and then press SHIFT + Right Click.

Here you go! there you will see a option "run as different user "

Anish Sethi
  • 1