Implementing Connect As Different User from within the Connection String with Windows Authentication RRS feed

  • Question

  • We have two domains.  Ours is on Windows 2012 (dom2012)Sister companies domain is on Windows 2003 (dom2003)

    Domain SIDs are different or not synched, etc.  due to Exchange implementation on both sides, etc. etc.

    So, the Domain Trust works only one way.  Users in dom2012\userA can connect to dom2003 SQL Servers with WinAuth, but not the other way around.  The only way is in dom2003 users to use SSMS Connect as Different User and enter their dom2012\userX and access to SQL Servers in dom2012.  (similar to /Run as from command line, etc.) 

    So the question is: Is there any way to simulate this with a Connection String.  In other words, the connection string will be something like this: server=abcdef; Trusted_Connection=Yes; Integrated_Security=SSPI; uid=dom2012\user...…..

    But in that case, you still have to specify a password so that the connection string inside the ConnString will find the SID.

    I guess that is not possible, right?

    Thank you

    Lovely Cornelia from Boston

    Monday, November 18, 2019 9:50 PM

All replies