When I am on client sites I often have a domain account to use, but bring my own device. When working on SQL servers I have to remote into the server to do any type of SQL queries or database administration.
Solution
I finally came up with a solution for this. I added this to a power shell script on my desktop and now I can connect to SQL server on the domain. When I run the powershell script I just add my domain password and I can connect to the server
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| runas /netonly /user:domain\user “C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe” |
