I'm trying to login to a SQL server on my work network with a VPN connection to the network and by using my AD credentials. When I'm directly on my office machine, I use "Windows Authentication" as the Authentication method in SSMS and that works fine.
When I'm VPN'ed onto the network and using my local machine, Windows Authentication doesn't work (understandably) but if I try to use the "Active Directory - Password" Authentication method (I was hoping I could put in my work's AD account to connect to the remote server) I get the following error:
It sounds like it can't find the server, but when I ping the server from my local machine, I'm getting a response.
Note: "Allow remote connections to this server" is checked.