Connecting from ADO in Powershell should be the same as VBA. I use the full server name provided: xxx.database.windows.net. That ought to work for you. You will need to make sure you allow for the fact that the firewall will block individual IP addresses, so if you have a range of those at work, add it to the firewall now.