Solved

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

Posted on 2010-09-20
1
288 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 500 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

#Citrix #Citrix Netscaler #HTTP Compression #Load Balance
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

810 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