[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

vb.net sql across 2 networks using impersonated windows authentication?

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?

Thanks!
0
MaxDes101
Asked:
MaxDes101
1 Solution
 
mcmonapCommented:
Hi MaxDes101,

Have you checked whether SQL authentication is enabled on the SQLserver?  If mixed mode is/could be enabled this would resolve your issue.  It allows the configuration of accounts to authenticate against SQL server directly.  More info here (read Connecting Through SQL Server Authentication):

http://technet.microsoft.com/en-us/library/ms144284.aspx
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now