?
Solved

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

Posted on 2010-09-20
1
Medium Priority
?
302 Views
Last Modified: 2012-05-10
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
Comment
Question by:MaxDes101
1 Comment
 
LVL 15

Accepted Solution

by:
mcmonap earned 2000 total points
ID: 33721464
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Unable to change the program that handles the scan event from a network attached Canon/Brother printer/scanner. This means you'll always have to choose which program handles this action, e.g. ControlCenter4 (in the case of a Brother).
How to fix a SonicWall Gateway Anti-Virus firewall blocking automatic updates to apps like Windows, Adobe, Symantec, etc.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

568 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question