vb.net sql across 2 networks using impersonated windows authentication?
Posted on 2010-09-20
here is my situation:
I need to access SQL DB from a network on which I am NOT on a domain. The SQL server sits on another network WITH a domain. ( all access has been arranged between the 2 networks...)
I need to be added to a read only group for that SQL server, but due to me not being on the same domain it will not allow this with my current setup.
Is there a way that I can create and use a user for that domain while impersonating a different identity than the logged on windows user of the non-domained machine from a VB.net application?
So basically in my connect string inside the application could use a user and password from a domain I am technically not logged into?