How to use Windows Authentication with a different user
说明
When we create a connection, an authentication type, when we choose windows authentication, its automatically fetch the logged in user without the option to change it. Can we use Windows authentication but have the option to use a domain user different from logged one?
解决办法
The only way is to press CTRL+SHIFT, right-click the SQL Optimizer icon and run it as a different user (an option in the Windows menu).
