I need to connect to a Remote account. I have a Windows Account for this remote machine. To connect to the Database, I RDP which includes entering a password. When I RDP to the machine, I can run SSMS and I can connect with Windows Authentication.
My question is can I connect directly using my SSMS, i.e. without RDPing. As I seem to have everything just that my Windows Account requires a password to connect to Windows and the Windows Authentication has no option for a password.
Another option is to download ShellRunAs from SysInternals. Once you have that, you can register the /netonly option and it will create a context menu item.
With that, you can then right-click (or shift right-click) any application and use the new context menu item to run as with network credentials. This will prompt you with a dialog box where you can enter the domain credentials instead of entering the credentials in a command window. ShellRunAs does open a command window - but you can close it once you enter your credentials.