Our production database is hosted by another company on their domain. I'm able to RDP into the box and login with the credentials they provided me but when I try to login from my local computer on my local domain using SSMS SSMS forces my local credentials. I've tried but can find no way to change these credentials using the SSMS front end.
I attemtped using a shortcut with a target of
C:\...\runas.exe /netonly /user:DOMAIN\USERNAME "C:\...\ssms.exe"
But when SSMS comes up it appears to still be trying to use my local credentials and does not allow me to connect. Is there something I'm missing. How do I tell SSMS that its connecting to a different domain account?