I can manually right click on SSMS and choose "Run as a different user" then input the other users windows authentication user and password which will successfully open the connection to my desired server and DBs.

Is there a way to invoke the "Run as a different User" option from Excel VBA and pass through the User and Password details?

Run as different user.jpg

The VBA code I currently have is as follows:

Please Login or Register  to view this content.