0

have a new Win10 pc and need run MSSQL Management Studio as a different user. However when I do so I get error: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe Access Denied

I am not a local admin on my own pc unless I add myself via using LAPS UI.

1) I add myself and my secondary account to Administrators group.

2) I update secpol.msc to state my secondary account can log on to computer locally whilst ensuring the deny log in to local computer is not set to negate this.

3) I have given my secondary user file system permissions for read/write on the full directory structure.

4) If necessary I create secondary user as new account on my pc.

However, this has not affected anything.

I also tried the powershell syntax: C:\Windows\System32 runas.exe /noprofile /env /netonly /user:SQLAuthority\SecondaryLoginName "C:\Prog ram Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe"

It asked for my secondary user account logon password but then started MSSQLMS as my normal user. I reset the SQL import/export files but it made no difference.

I managed to get it to work last week so unless I have forgotten to do something in meantime I don't understand why I am unable to run as other user today.

Frustrated! Cheers in advance

0

/NETONLY doesn’t perform a local logon using the supplied credentials. It only uses the credentials for NTLM Auth. So you run SSMS as the logged-on user but connect to SQL Server using the supplied credentials for Windows Integrated Auth.

| improve this answer | |
  • Hi David, thanks for very quick reply. Apologies but I'm at a loss still. I only used the /netonly switch because I had no luck trying to run MSSQLMS without it. I've removed it but still have same issue. Are you able advise why the secondary account, on same domain as std account gets access denied. – Eric Nov 11 '19 at 15:52
  • No. Log in using that account to test. – David Browne - Microsoft Nov 11 '19 at 18:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.