Connect to SQL Server with Management Studio using Windows Authentication
sql-server, sql-server-2012, windows-authentication
Solution
The only elegant ways to connect to a SQL Server in another domain but still use Windows Authentication are:
- What you're already doing: `runas /netonly`
- Connecting via remote desktop and opening SSMS locally on the remote server
Problem
I am working with Management studio and I want to log in to databases located on another server in another domain. The only login I have for such is with Windows credentials. I want to be able to log in via Management Studio on my local PC. I have found the only way to do so is using a command similar to: ``` runas /netonly /user:domain\username "C:\Progr...\IDE\Ssms.exe" ``` While this works, it isn't the easiest or nicest way. Is there a better way? Any way I can do it within Management Studio?