SQL Management Studio – Windows Authentication – different domain

Sometimes you need to use windows authentication to SQL using SQL Management Studio, but the your domain and or username is different than who you are currently logged into you machine as.  In that case run the following command from a Command Prompt.

runas /netonly /user:domainusername “C:Program Files (x86)Microsoft SQL Server100ToolsBinnVSShellCommon7IDESsms.exe”

Leave a Reply

Your email address will not be published. Required fields are marked *