0

Due to Coronavirus, we on my company are working from home. I had setup a virtual machine and am using VPN to connect to company's intranet.

It happens that we use company's AD account to log in MSSQL. We log in Windows with our account, and use Windows Authentication to log in MSSQL.

Now, I'm unable to log in local Windows using AD. I'd need to configure it to connect to AD, but for that Windows/PC needs a machine digital certificate, and be approved by some domain admin. That won't happen.

Anyway, I'm looking for a way to run SSMS using AD account, without needing to use it on Windows. I tried Run as different user but it also didn't work.

6
  • 1
    You could RDP to the server and run SSMS there. If SSMS isn't installed on the server you'd have to install it first... Commented Mar 23, 2020 at 12:06
  • 1
    Also, see the answer by "Dave" with 10 votes at stackoverflow.com/questions/849149/…. Seems like I tried this just for fun once and it worked. Commented Mar 23, 2020 at 12:14
  • tnx! I'm gonna read it. Unfortunately admin staff doesn't allow us to remotely login on server's Windows. I've been asking that for years and they won't allow it.
    – Hikari
    Commented Mar 23, 2020 at 12:18
  • 1
    The cmdkey, runas /netonly and credential manager answers at the other question are the correct ones (they all do basically the same thing). You don't need to domain-join your computer or RDP into the SQL Server. Commented Mar 23, 2020 at 12:53
  • 1
    Thanks @DavidBrowne-Microsoft. I wasn't sure if the runas would work if the workstation can't use the domain. Commented Mar 23, 2020 at 14:12

0