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.
Bookmarks